click below
click below
Normal Size Small Size show me how
Period CA
Study Guide: 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? | Shift+Tab |
| Best Fit | Automatically resizes the column to the best width for the data contained in the column |
| How are fields rearragned 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 entirecolumn in datasheet |
| Show an example of a field name | Addtress |
| Show an example of a "field value" for the field identified above | 1225 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 dialig boxes |
| One to many relationships | One record in the first table can match many recirds 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 | Aset of rules to ensure that there are matching values in the common field used to form the relationship |