Access Chapter 1: End of Chapter Quiz
Autonumber
The data type that describes a unique sequential or random number assigned by Access as each record is entered
Currency
The data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places
Short Text
The data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a ZIP code
Table
The database object that stores the data, and which is the foundation of an Access database
Primary Key
The field that uniquely identifies a record in a table
Report
The object that displays fields and records from a table or query in a printable format
Query
The object that retrieves specific data and then displays only the data that you specify
Object Window
The window area that displays each open object on its own tab
Navigation Pane
The window area that organizes the database objects and from which you open objects
Append
To add on to the end of an object, such as to add records to the end of an existing table
Database
An organized collection of facts about people, events, things, or ideas related to a specific topic
Property Sheet
Precise changes to the properties-characteristics-of selected items in database can be made
Common Field
A field in one or more tables that stores the same data
Flat Database
A simple database file that is not related or linked to any other collection of data
Field
A single piece of information that is stored in every record and represented by a column in a table
Record
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea
Datasheet View
The Access view that displays data in columns and rows like an Excel worksheet
Populate
The action of filling a database with records
Objects
The basic parts of a database; for example tables, queries, forms, and reports
Data Type
The characteristic that defines the kind of data you can store in a field