Advertisement Upgrade to remove ads

database management system

Access is a ________.

record

A(n) ________ contains information about a given person, product, or event.

design

Database ________ refers to the arrangement of data into tables and fields.

Reserved

________ words are words that have a special meaning to Access and cannot be used for the names of fields.

64

In Access, table and field names can be up to ________ characters in length.

Text

A field whose data type is ________ can contain any characters.

Memo

A(n) ________ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

AutoNumber

A field with the ________ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

Attachment

A field with the ________ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

OLE Object

A field whose data type is ________ can store an OLE object, which is an object linked to or embedded in the table.

database

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ________.

Create

One way to create a table, is to click ________ on the Ribbon and then click the Table button.

ID

When you create a table in Datasheet view, Access automatically adds a field called ________ as the first field in the table.

Click to Add

To define an additional field in Datasheet view, click the ________ column heading.

Undo

To undo the most recent change to a table structure, click the ________ button on the Quick Access Toolbar.

Delete Field

To delete a field in a table, right-click the column heading for the field, and then click ________ on the shortcut menu.

Rename Field

To change the name of a field, right-click the column heading for the field, click ________ on the shortcut menu, and then type the desired field name.

Format

To show the symbol for the Euro instead of the dollar sign, change the ________ property for the field whose data type is Currency.

Insert Field

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ________ on the shortcut menu.

Design View

To open a table in Design view, right-click the table in the Navigation Pane and then click ________ on the shortcut menu.

New (blank)

To add a record to a table, click the ________ record button.

F2

You can place an insertion point by clicking in the field or by pressing ________.

DELETE

To delete a record, click the record selector for the record, and then press the ________ key(s).

Landscape

To change the print orientation from portrait to landscape, click the ________ button on the Print Preview tab.

Options

To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ________, and then click Proofing in the dialog box that displays.

External Data

To import data to a table, click the ________ tab on the Ribbon.

Quick Access Toolbar

To save the changes to the layout of a table, click the Save button on the ________.

Shutter Bar Open/Close

To open the Navigation Pane, click the ________ Button.

Create

To create a query using the Query Wizard, click ________ on the Ribbon and then click the Query Wizard button.

Open

To view the results of a saved query, right-click the query in the Navigation Pane and click ________ on the shortcut menu.

Design View

To change the design of a query, right-click the query in the Navigation Pane and the click ________ on the shortcut menu.

Report

To create an initial report that can be modified in Layout view, click ________ on the Create tab.

Close

To quit Access, click the ________ button on the right side of the title bar.

Compact & Repair

To compact and repair a database, click the ________ button in the Information gallery in the Backstage view.

Save & Publish

To back up a database, use the Back Up Database command on the ________ in the Backstage view.

Delete

To delete a database object, right-click the object in the Navigation Pane and then click ________ on the shortcut menu.

Rename

To rename a database object, right-click the object in the Navigation Pane and then click ________ on the shortcut menu.

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