click below
click below
Normal Size Small Size show me how
CA Final FC - Access
CA Final Flashcards for Access
Question | Answer |
---|---|
Access | A database management system |
Database | A collection of objects |
Datasheet | The table displays its data in rows and columns |
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 fields rearranges in Datasheet view? | By clicking and dragging them to 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 a datasheet |
Show an example of a field name | Address |
Show an example of a "field value" for the field identified above (Address) | 1255 Dogwood Road |
Define "primary key" and give an example | A unique identifier for each record in a 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 dialogue 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 a one-to-many relationship. Example: you have one mother and she has many children. In this case, the "mother" is primary |
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 |