Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
ComputerApps
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 rearranged in the Datasheet view? | By clicking and dragging them to a new location |
| What is the purpose of Print Preview | To check the pring settings prior to printing |
| Field Selector | a small bar or box that you press to select an entire column in datasheet |
| Sow an example of a field name | Address |
| Show an example of a "field value" for the identified above. | 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 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 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. |
| Database management system | Allows you to store retrieve, analyze, and print info. |
| database | collection of objects |
| Navigation Pane | Opens on the left side of the screen, lists objects in the database |
| record | complete set of data |
| Fields | records are made up of one or more of these |
| field names | how to identify the field |
| field value | the value that the feild holds |
| datasheet view | data in rows and columns |
| datasheet | data in rows and columns |
| field selctor | appears at top of each column in a table and completes the name |
| best fit | way of resizing a column, picks the best way of fit |
Created by:
mollymcmillan
Popular Computers sets