Field Data Type Description Size Alphabetical/Numeric Required Indexed
Annotation ID AutoNumber Primary Key: Identifies the unique number given to each citation Long Integer (Estimating 15) A Yes Yes
Author 1 Text Identifies the first author of the article listed in the citation 30 A No Yes (Duplicates Ok)
Author 2 Text Identifies the second author of the article listed in the citation 30 A No Yes (Duplicates Ok)
Author 3 Text Identifies the third author of the article listed in the citation (Although APA recognizes up to 6 authors, only 3 entries are permitted in order to conserve space in database.) 30 A No Yes (Duplicates Ok)
DateÝÝ Text Identifies the year of publication of the article listed in the citation 4 A No Yes (Duplicates Ok)
Article Title Text Identifies the title of the article listed in the citation 100 A Yes Yes (Duplicates Ok)
Article Subtitle Text Identifies the subtitle of the article listed in the citation 100 A No Yes (Duplicates Ok)
Electronic Version Yes/No Identifies whether or not the article listed in the citation is an exact duplicate of print version 3 A Yes No
Journal Title Text Identifies the journal title of the article listed in the citation 100 A No Yes (Duplicates Ok)
Volume Text Identifies the volume number of the article listed in the citation 20 A No No
Issue Text Identifies the issue number of the article listed in the citation 20 A No No
Page Numbers Text Identifies the page number(s) of the article listed in the citation 20 A No No
Internet Journal Website Yes/No Identifies whether or not the article listed in the citation is from online 3 A Yes No
Internet Journal Database Yes/No Identifies whether or not the article listed in the citation is from an Internet database 3 A Yes No
Date of Retrieval Date/Time Identifies the date of retrieval of the online journal article listed in the citation (example 06/19/1994) Short Date (Estimating 8) A No No
Website Hyperlink Identifies the website address of the online journal article listed in the citation 30 A No No
Database Text Identifies the database of the online journal article listed in the citation 50 A No Yes (Duplicates Ok)
Annotation Memo Identifies the complete 50 word annotation of the article listed in the citation 700 A Yes No
Number of Pages Number Identifies the number of pages of the article listed in the citation Long Integer (Estimating 2) A No Yes (Duplicates Ok)
Keyword 1 Text Identifies the keyword(s) of the article listed in the citation 50 A Yes Yes (Duplicates Ok)
Keyword 2 Text Identifies the keyword(s) of the article listed in the citation 50 A Yes Yes (Duplicates Ok)
Keyword 3 Text Identifies the keyword(s) of the article listed in the citation 50 A Yes Yes (Duplicates Ok)
Keyword 4 Text Identifies the keyword(s) of the article listed in the citation 50 A Yes Yes (Duplicates Ok)
Keyword 5 Text Identifies the keyword(s) of the article listed in the citationÝ (Although citations recognize an unlimited number of keywords, only 5 entries are permitted in order to conserve space in database.) 50 A Yes Yes (Duplicates Ok)
Weekly Lesson Text Identifies the lesson of the week of the article in the citation 50 A Yes Yes (Duplicates Ok)
Student ID Text Identifies the unique ID number of the student who created the citation. 15 A Yes Yes (Duplicates Ok)