click below
click below
Normal Size Small Size show me how
Access v
Vocab for 2010 Microsoft Access
Question | Answer |
---|---|
Access | A data base 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 in datasheet view? | [Shift] + [Tab] |
Best Fit | Automatically resixes the column to the best width for the data contained in the column |
How are fields rearranged in datasheet view? | By clicking and dragging them to a new location |
What is the purpopse of print preview? | To check the print settings prior to printing |
Field Selector | A small bar or box that you press to selct an entire column in a datasheet |
Primary key | A unique identifier for each record in a table. I.E.: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, the click the run button |
Simple Query Wizard | An easy way to creat a query. 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. |
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 |