Access Database Management System Quiz

Access is a ____.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject

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

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

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

A field whose data type is ____ can contain any characters

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.

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.

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

A field whose data type is ____ can store text that can be used as a hyperlink address.

File names cannot contain a(n) ____.

In Access, the columns in a table are called records.

A unique identifier also is called a primary key.

In Access, table names cannot contain digits.

The Navigation Pane contains a list of all the objects in the database.

In Datasheet view, a table is represented as a collection of rows and columns called a list.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

A(n)____________________ is a software tool that can be used 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.

The rows in the tables are called ____________________.

A(n) ____________________ contains a specific piece of information within a record.

The ____________________ data type in Access is referred to as Money in SQL Server.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

To define an additional field in Datasheet view, tap or click the ____ column heading.

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

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

You can create a table in ____.

The Access window consists of a variety of components. These include the ____.

When Access first creates a database, it automatically creates a table.

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________

____________________ view has more functionality for creating a table than Datasheet view.

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

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

To add a record to a table, tap or click the ____ record button.

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

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

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

To save the changes to the layout of a table, tap or click the Save button on the ____.

Changing the column width in a datasheet changes the structure of a table.

Landscape orientation means the printout is across the length (height) of the page.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Add record Navigation button.

To preview and then print the contents of a table, use Table Preview.

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies

A hard copy or ____________________ is information that exists on a physical medium such as paper

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

To open the Navigation Pane, click the ____ Button.

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

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu

To change the design of a query, right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Form view displays a single record at a time.

Layout view shows a report on the screen and allows the user to make changes to the report.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Redundancy means storing the same fact in more than one place.

____________________ refers to the process of determining the tables and fields that make up the database.

The determination of database requirements is part of a process known as ____________________.

Designing to omit ____________________ will help to produce good and valid database designs.