Organizes data in fields (columns) and records (rows)
What is a table?
100
To add a new record to the open table, click this Home Tab Records group button
What is the New button?
100
This field has an asterisk next to its name
What is the Primary Key?
100
Alphanumeric data up to 255 characters in lenght
What is Short Text?
200
Shutter Bar Open / Close Button
What is F11?
200
Displays data from a table or related tables that meets a conditional statement and/or performs calculations
What is a query?
200
To hide a column or adjacent columns click this button in the Records group on the Home Tab
What is the More button?
200
Lines drawn between tables that represent links between these tables
What are join lines?
200
Positive or negative values that can be used in calculations: not to be used for values that will calculate monetary accounts
What is number?
300
This keyboard short cut will make the next field active.
What is Tab?
300
Allows fields and records to be presented in a layout different than the datasheet. Used to facilitate data entry and maintenance
What is a form?
300
To unfreeze all of the columns in a database click this option in the drop down list from the More button in the Records group in the Home Tab
What is Unfreeze All Fields
300
The maximum length of a field name
What is 64 characters?
300
Values that involve money; Access will not round off during calculations
What is Currency?
400
This keyboard shortcut will make the previous field active.
What is Shift + Tab?
400
Prints data from tables or queries
What is a report?
400
At the Enter Field Properties dialog box you can provide a caption and a description for each field by clicking this button.
What is the Name & Caption button
400
The maximum length of data in a short text data field typ
What is 255 characters?
400
Access automatically assigns this data type to the first field in a table.
What is AutoNumber?
500
This Keyboard Shortcut is use to create a new record
What is Ctrl ++
500
Click this Navigation Pane option to display a list of all of the saved objects in a database
What is Object Type?
500
This button found in the Properties group on the TABLE TOOLS FIELDS tab is use if most records in a table are likely to contain the same field value in a column
What is the Default Value button?
500
The first principle in database design is to
What is reduce redundant (duplicate) data?
500
This data type allows you to add a group of related fields in one step