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.
is the simplest approach to recovery invoving periodically making a copy of the database.
or called a save copy, is the simplest approach to recovery involving periodically making a copy of the database
to remove wasted space from the database
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.
is in each field and indicates the type of data that can be stored in the field.
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.
are details about a file.
the table is represented as a collection of rows and columns.
the data in the table is presented in rows and columns, similar to a spreadsheet.
is only used to create a table or to modify the structure of the table.
contains a specific piece of information within a record.
is a formatted document with fields that contain data.
is where data is displayed in a form on the screen, yu usually can see all the fields, but only for one record.
involves reducing the environmental waste generated when using a computer.
or printout is 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.
means the printout is across the height of the page.
is the design of a table.
the first row contains column headings describing the data in each of the columns, and the remaining rows contain the data.
is when you correct the problem by copying this backup copy over the actual database.
can include such information as the file’s author, title, or subject.
are buttons used to move within a table, found near the lower-left corner of the screen when a table is open.
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.
for the open objects appear at the top of the work area.
is the most common type of relationship you will encounter between tables.
means to printout is across the height of the page.
is a unique identifier.
or hardcopy is information that exists on a physical medium such as paper.
are simply questions, the answers to which are in the database.
are the rows in the tables.
is the process called recovery.
such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
means changing its size.
the small box that precedes the field.
is the simplest approach to recovery involving periodically making a copy of the database.
are associated with all Microsoft Office documents and inblude author, title, and subject.
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.
is a way of uniquely identifying each record in a database.
Get access to
MOney BackBecome a Member
Guarantee No Hidden
Guarantee No Hidden