Access Ch.1 vocabulary

45 terms by hernkar2254

Create a new folder

Advertisement Upgrade to remove ads

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.

Compact

the option that compacts the data base also repairs the porblems that might have ocurred in the data base.

Criterion

is a condition that records to be included must satisfy.

Currency

the field thth can only contain monetary data.

Data type

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, 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.

Datasheet

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.

Field

contains a specific piece of information within a record.

Form

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.

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

the printout is across the height of the page.

Layout

design of the table.

List

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.

Metadata

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.

Number

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.

Printout

informatin that exists on a physical madium such as paper.

Queries

aew simply questions, the answers to which are in the database.

Records

the rows in the tables

Recover

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.

Resizing

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.

Text

the field can contain any character.

Unique identifier

the client numbers are unique; thath is, not two clients are assigned the same number.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set