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 |