• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/18

Click to flip

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