click below
click below
Normal Size Small Size show me how
CA Final Exam Review
Access
Question | Answer |
---|---|
Access | a database management system |
Database | a collection of objects |
Datasheet | the table displays its data in rows and colums |
How do you move from one field to the next in Datasheet view? | Tab |
How do you move from one field to the previous field in Datasheet view? | Shift + Tab |
Best fit | Automatically resizes the column to the best width for the data contained in the column |
How are the fields rearranged in Datasheet View? | by clicking and dragging them into a new location |
What is the purpose of Print Preview | to check the print settings prior to printing |
Field Selector | a small bar or box that you press to select an entire column in datasheet |
Show an example of a field name | address |
Show an example of a "field value" for an adresss | 1255 Dogwood Road |
Define "primary key" and give an example | A unique identifier for each record in the table. Example: Student Number |
Design grid | the top half of the Table window |
Field Properties Pane | the bottom half of the Table window |
How do you "run" a query? | By opening a query object |
Simple Query Wizard | An easy way to create a query. It asks you what data you want to see by letting you select options in dialog boxes |
One to many relationship | one record in the first table can match many records in the second table |
Primary table | the "one" side of two related tables in one-to-many relationship |
Related table | the table containing "many" records |
Referential integrity | a set of rules to ensure that there are matching values in the common field used to form the relationship |