Access Ch.1 Vocabulary

Access work area
is the area where you work on objects such as tables, forms, and reports.
Automatically updated properties
include file system properties, such as the date you create or change a file, and statistics, such as the file size.
Backing up
is the simplest approach to recovery invoving periodically making a copy of the database.
Backup copy
or called a save copy, is the simplest approach to recovery involving periodically making a copy of the database
Compact
to remove wasted space from the database
Criterion
is a condition that the records to be included must satisfy.
Currency (data type)
is the field that contains only monetary data.The values will appear with currency symbols, such as dollar signs, commas, and decimal points, and with two digits following the decimal point. Like numerical fields, you can use currency fields in arithmetic operations. Access assigns a size to currency fields automatically.
Data type
is in each field and indicates the type of data that can be stored in the field.
Database
describes a collection of data organized in a manner that allows access retrieval, and use of that data.
Database management system
such as Access, is software that allows you to use a computer to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.
Database properties
are details about a file.
Datasheet
the table is represented as a collection of rows and columns.
Datasheet view
the data in the table is presented in rows and columns, similar to a spreadsheet.
Design view
is only used to create a table or to modify the structure of the table.
Field
contains a specific piece of information within a record.
Form
is a formatted document with fields that contain data.
Form view
is where data is displayed in a form on the screen, yu usually can see all the fields, but only for one record.
Green computuing
involves reducing the environmental waste generated when using a computer.
Hard copy
or printout is information that exists on a physical medium such as paper.
Import
means to make a copy of the data in a table in the Access database.
Keywords
are words or phrases that further describe the database.
Landscape orientation
means the printout is across the height of the page.
Layout
is the design of a table.
List
the first row contains column headings describing the data in each of the columns, and the remaining rows contain the data.
Live database
is when you correct the problem by copying this backup copy over the actual database.
Metadata
can include such information as the file’s author, title, or subject.
Navigation buttons
are buttons used to move within a table, found near the lower-left corner of the screen when a table is open.
Navigation Pane
contains a list of all the object in the database.
Number (data type)
is the field that can contain only numbers. The numbers either can be posittive or negative. Fields are assigned this type so they can be used in arithmetic operations. Fields that contain numbers but will not be used for arithmetic operations (such as postal codes) usually are assigned a data type of Text.
Object tabs
for the open objects appear at the top of the work area.
One-to-many relationship
is the most common type of relationship you will encounter between tables.
Portrait orientation
means to printout is across the height of the page.
Primary keys
is a unique identifier.
Printout
or hardcopy is information that exists on a physical medium such as paper.
Queries
are simply questions, the answers to which are in the database.
Records
are the rows in the tables.
Recover
is the process called recovery.
Relational database
such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
Resizing
means changing its size.
Row selector
the small box that precedes the field.
Save copy
is the simplest approach to recovery involving periodically making a copy of the database.
Standard properties
are associated with all Microsoft Office documents and inblude author, title, and subject.
Status bar
located at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the status of certain commands and keys; it also provides controls for viewing the object.
Text (data type)
The field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.
Unique identifier
is a way of uniquely identifying each record in a database.