45 terms

Access Ch.1 vocabulary

Karla D. Hernandez
Access work area
work on objects such as tables, forms, and reports.
Automatically updated properties
include file system properties, such as the date you create or change file, and statistics, such as the file size.
Backing up
the simplest approach to recovery involves periodically making a copy of the data base.
Backup copy
the simplest approach to recovery involves periodically making a copy of the data base.
the option that compacts the data base also repairs the porblems that might have ocurred in the data base.
is a condition that records to be included must satisfy.
the field thth can only contain monetary data.
Data type
indicates the type of data that can be stored in the field.
describes a collection of data organized in a manner that allows access, retrival, and use of that data.
Database managment system
such as Access, is software thth allows you to use a computer to create a data base; add, change, and delete data in the data base, ask and answer questions concerning the data in the databse, and create forms and reports using the data in teh database.
Database properties
the details about the file.
the table is represented as a collection of rows and columns.
Datasheet view
the data inthe table is represented in rows and columns, similar to a spreadsheet.
Design view
is only used to create a table or to modify the structure.
contains a specific piece of information within a record.
in a database is formatted document with fields that contain data.
Form view
where data is displayed in a form on the screen, you usually can see all the fields, bit only for one record.
Green computing
involves reducing the environmental waste generated when using a computer.
Hard copy
information that exists on a physical medium such as paper.
means to make a copy of the data in a table in the Access database.
are words or phrases that further describe the database.
Landscape orientation
the printout is across the height of the page.
design of the table.
the first row that contains column headings describing the data in each of the columns, and the remaining rows containing the data.
Live database
you correct a problem by copying this backup copy over the actual database.
can include such information as the file's author, title, or subject.
Navigation buttons
which are the 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 objects in the database.
the field can contain any characters. A number maximum of 255 characters is allowed in a field whose data type is Text.
Object tabs
for the open objects appear at the top of the work area.
One-to-many relationships`
the most common type of relationship you will encounter between tables.
Portrait otientation
means the printout is accross the width of the page.
Primary keys
a unique identifier.
informatin that exists on a physical madium such as paper.
aew simply questions, the answers to which are in the database.
the rows in the tables
this process is called recovery because you recover tha database.
Relational database
such as thsoe maintained by Access, a database consists of a collection of tabels, each of which contains information on a specific subject.
changing the size in the datasheet.
Row selector
you can see the field name, data type, and description without taking any special action, to see the field's size and/or caption.
Save copy
the simplest approach to recovering involves periodically making a copy of the database this is the save copy.
Standard properties
are assosiated with all Microsoft Office socuments and include author, title, and subject.
Status bar
located at the bottom of the Access window, presents information about the database object, the progress of the current tasks, and the status of ceratain mands and keys; it also provides controls for viewing the object.
the field can contain any character.
Unique identifier
the client numbers are unique; thath is, not two clients are assigned the same number.