Advertisement Upgrade to remove ads

The purpose of a database is to store data so that information can be obtained easily by asking questions.

False

When data in a table becomes redundant,

it is usually an indication that you need a new table to contain information about the topic.

When you delete a field,

if you do so by mistake, you must repopulate every record.

A select query creates subsets of data to answer specific questions, then displays them in the query's datasheet.

True

To view a table in Design view:

in the Views group, click the View button and click Design View.

Raw, collected data--to which no structure has been added--is all that is needed for a database.

False

To rename a table, you can

right-click the table name in the Navigation Pane.

The Multiple Items form enables display or entry of multiple records, but with simplified layout.

True

The default field size for the Text data type is 255.

True

In Print Preview, if the Next Page button is dimmed, it means there are no more pages.

True

The Text data type can describe numbers not used in calculations.

True

To conserve space when planning a database, information should be organized by the largest useful parts possible.

False

You can view a table in either Datasheet view or Design view.

True

An Access record is saved when you

move to the next record.

The process of creating a query involves

choosing the table(s) and selecting the fields you want to include in the query result.

Raw data that has been organized so as to become useful is also known as

information

To append data to a table, the table must be open.

False

The table Design view shows

the structure of the table.

Redundancy in databases is a desirable characteristic.

False

When records have no unique value, the AutoNumber data type is a useful way to automatically create a unique number for each record.

True

One purpose of a report is to

display the fields and records from a table in an easy-to-read format.

When importing data from an Excel workbook, you may NOT

append a copy of the records to an open, active table.

The most common database objects are

tables, forms, and reports.

Headers and footers in tables and queries can be edited by the user before printing.

False

Microsoft Access is NOT a relational database.

False

A field contains a single piece of information for each record.

True

The Design view icon features a pencil, a ruler, and a protractor.

True

The advantage of using a template when starting a new database is that

database objects are already created.

To append data to a table, the table must already be created, and it must be closed.

True

When you create a table using the Blank Database command, by default Access designates the first field as the primary key field.

True

Which of the following is a good candidate for a primary key?

A student ID in a college registration database.

Which view allows you to make quick changes to a report prior to printing it?

Layout view

Which of the following is NOT a characteristic of the Currency data type?

Data must be displayed with two decimal places.

The Caption property

displays a name for a field other than the field name.

The Access view that displays the table data in columns and rows is called

Datasheet view.

When creating a new table, Access does NOT

prevent the user from modifying the ID field.

To create a query using the Simple Query Wizard, you choose the data source and

field names.

Which of the following does NOT happen when you close an Access database?

The Access window will automatically close.

Good database design does NOT include

accessible coding so that users can alter the structure of the database.

The Unique check box is the indicator on the Ribbon in Datasheet view that a field is the primary key.

True

One purpose of a form is to

simplify data entry in a table

By default, tables are sorted in ascending order by the primary key field.

True

You can make permanent changes to a table's structure in either Datasheet view or Design view.

True

Which of the following is NOT a benefit of avoiding redundancy in a database?

Prevents unauthorized manipulation of data

A primary key refers to the field in the table that uniquely identifies a record.

True

A database object that retrieves specific data from one or more tables is a

query.

Each table row contains all the categories of data pertaining to one entity and is called a

record.

In Microsoft Access, all data is stored in one or more

tables.

To organize your database objects you must use the

Navigation Pane.

When data in a table becomes redundant, it usually means that you need fewer tables.

False

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