Microsoft Access Vocabulary

5 Written Questions

1. Listing of all the objects in the database.
2. A database file that does not yet contain any objects (tables, queries, reports, and so on)
3. A window showing the data in a tale with one record's field appearing at a time in individually labeled boxes.
4. To organize data alphabetically or in numerical order.
5. A view in which you can add, edit, and delete fields from thr table, change field types and descriptions, set a primary key, and more.

5 Matching Questions

1. Primary Key
2. Field Edit Mode
3. Preview
4. Dialog Box Launcher
5. Composite Key

1. a A button in the bottom right corner of a group on a tab of the Ribbon, which when clicked opens a dialog box or task pane.
2. b 2+ fields that collectively define the primary key by unique combinations of their values
3. c A mode in which the insertion point displays in a selected field.
4. d To produce a screen view of what a printed page will look like.
5. e A field that uniquely identifies each record in a table.

5 Multiple Choice Questions

1. A mode in which the entire field entry is highlighted in a selected field.
   1. Data Type
   2. Navigation Pane
   3. Navigation Mode
   4. Field Edit Mode
2. An optional brief comment or explanation of a field. The field description appears in the status bar at the bottom of the window when its field is selected.
   1. Field Properties
   2. Table Design Vieiw
   3. Field Description
   4. Field Edit Mode
3. The type of data that aparticular field is designed to hold. Common types = Text, Number, Date, Memo
   1. Data Type
   2. Datasheet
   3. Table
   4. Database File
4. Characteristics of a field that determine how long an entry can be, how the entry will be formatted, whether there should be a default entry, and what can be entered (for ex. #'s only or valid dates only)
   1. Field Edit Mode
   2. Field Description
   3. Field Properties
   4. Preview
5. To sort from the smallest to the largest (from A to Z and 0 to 9)
   1. Object
   2. Preview
   3. Descending
   4. Ascending

5 True/False Questions

1. Datasheet → The type of data that aparticular field is designed to hold. Common types = Text, Number, Date, Memo

   True        False

2. Template → A predefined group of settings for creating a new database, uncluding what tables will be included, what fields will be used, and so on.

   True        False

3. Descending → To sort from the largest to the smallest. (from Z to A or 9 to 0)

   True        False

4. Table → A collection of database fields designed to be used together.

   True        False

5. Database File → File the contains all objects of your database.

   True        False