Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
access is a |
database management system |
|
words are words that have special meaning to access and cannot be used for the names of fields |
reserved |
|
contains information about a given person, product, or event |
record |
|
a field whose data type can contain any characters |
short text |
|
when you create a table in datasheet view, access automatically adds a field called as the first field in the table |
ID |
|
to delete a field in a table, press and hold or right click the column heading for the field, and then tap or click on the shortcut menu |
delete field |
|
in the accompanying figure, the key symbol that appears in the row selector for the book rep number field indicates that book rep number is the for the the table |
primary key |
|
in the accompanying figure, the small box or bar to the left of each field is called |
row selector |
|
in the accompanying figure, the book rep table displays in |
design view |
|
to save the changes to the layout of a table, tap or click the save button on the |
quick access toolbar |
|
to open the navigation pane, tap or click the button |
shutter bar open / close |
|
a field with the data type can store a unique sequential number that access assigns to a record access will increment the number by 1 as each new record is added |
autonumber |
|
to create a query using query wizard, tap or click on the ribbon and then click the query wizard button |
create |
|
to create an initial report that can be modified in layout view tap or click on the create tab |
report |
|
the rows in the tables are called |
records |
|
a unique identifier is also called a |
primary key |
|
to delete a record, tap or click the record selector for the record and then press the key |
delete |
|
you can place an insertion point clicking in the field or by pressing |
F2 |