This is a collection of data that has been organized so that the data can be easily stored, sorted, extracted, and reported
database
This term describes a single unit of information about a person, place, item, or event
record
This term describes all of the data about one subject in a table
field
This object is created first, before any other objects in a database
table
This object provides a user-friendly interface with which you can edit, view, or print data by working with only one record at a time
form
This database object is used to display or print data from one or more tables in a specific layout or format
report
Click this button at the column width dialog box to set the column width to the length of the longest entry in the column
Best Fit
Press this key to turn on Edit mode in a datasheet
F2
Access displays a message box requesting confirmation when a record is about to be deleted because this feature is not available for a delete operation
undo
When more than one column is selected for a sort operation, Access sorts first by this column
leftmost column
This feature temporarily hides records in the datasheet that do not meet the specified criteria
filter
This page layout orientation rotates the printout to print wider than it is tall
landscape
Display this dialog box to set your own custom margins
Page Setup
These are the steps to hide a column in a datasheet
right-click field name in header row and then click Hide Fields
This keyboard command selects all records in the datasheet
Ctrl+A or Ctrl + Shift + spacebar
A field name can contain this number of characters
64
Assign a field this data type if the field will contain dollar values that you do not want rounded off in calculations
Currency
This is the term for the field in a table that must contain unique information for each record
primary key
Enter a value in this field property if you want the value to appear automatically in the field whenever a new record is created
Default value
Enter a statement in this field property to prevent data that does not meet the range or other criteria from being entered into the field
Validation rule
This is the field property that controls data as it is being entered by ensuring data typed in the field conforms to the code entered in the property box
input mask
This field property controls how data is displayed after it has been accepted for entry in the field
Format
This is the name of the wizard used to create a drop down list in a field
Input Mask Wizard
this button can be used to add a SUM function to the bottom of a numeric field in the datasheet
Totals