Advertisement Upgrade to remove ads

An Access database can have a maximum of one table

False

Datasheet View is used to precisely determine the characteristics of each field

False

You cannot modify the size of a field in Design View

False

A database is like a container because it can hold several types of objects, including tables, forms, reports, and queries

True

The Show Margins command can be used to set precise column widths

False

The page orientation can be changed with the Print Preview command

True

Portrait orientation causes a table to print horizontally on a page

False

Tables are composed of records

True

Text, Number, and Currency are examples of data types

True

You can enter data into a table in Design View

False

Filters are a temporary way to view records that meet specific criteria

True

To select an entire record, click anywhere in the record

False

An input mask can automatically enter parentheses around the area code of a phone number

True

Changing the structure of a table will never result in lost data

False

The table template is used to automate data entry in a table

False

A pencil icon in the row selector indicates that a record is being edited

True

Once you are in Datasheet View, you cannot go back to the Table Design View

False

To use Filter by Form you must first click on the field that contains the desired value

True

The Table Template provides a variety of sample fields to use in a table

True

Using validation rules, you can set a specific range of values allowed in the field

True

Forms can be used to enter data in tables

True

The main benefit of forms is that they allow you to view several records simultaneously

False

The navigation buttons at the bottom of a form can be used to move between records

True

Forms do not display currency symbols ($) and other formatting characters

False

You must first select a table before creating a simple form from the ribbon

True

The Report Wizard lets you choose the fields you wish to include in a report

True

The design of a report cannot be changed once the report has been saved

False

The Report Wizard lets you choose Portrait or Landscape orientation

True

Reports can be used to enter data

False

An object can be copied and then pasted to a different database

True

Criteria determine the records selected by a query

True

The Query Design grid is where you define a query

True

You can add fields to the Query Design grid by double clicking the desired fields on the field list(s) above the Query Design grid

True

You can add all fields to the Query Design grid by double clicking any field in the field list

False

Changing data in the recordset has no impact on the underlying data in the table(s) on which the query is based

False

You must type criteria in the same case (upper or lower) as the data in the tables you are querying or Access will not select the desired records

False

If a field has been entered into the Query Design grid, you cannot prevent the field from appearing in the recordset

False

The two types of compound criteria are AND and OR

True

You cannot use wildcards for numeric values

False

Access can sort on more than one field at a time

True

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