Accesse Exam

A flat database:

Data that is organized in a useful manner is:

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

good database design does not include

each table row contains all categories of data pertaining to one entity and is called a:

In Microsoft Access all data is stored in one or more

An access record is saved when you

which of the following is not a characteristic of the currency data type

To rename a table, you can:

Before populating a table, which is the correct sequence of steps?

While in Datasheet view, to display a table in Design View:

When creating a new table, Access does NOT

The most common database objects are:

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

The Caption property:

When you delete a field:

Headers and footers for Microsoft Access tables and queries:

The table Design view shows:

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

When importing data from an Excel workbook, you may NOT:

The process of creating a query involves selecting the:

One purpose of a form is to:

one purpose of a report is to

A query is a database object that:

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

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

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

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

To organize your database objects you must use the

When data in a table becomes redundant,

Which view allows you to make margin or page orientation changes to a report prior to printing it?

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

Microsoft Access is NOT a relational database.

Redundancy in databases is a desirable characteristic.

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

A database that contains contact information for students and movie DVD information is a good design?

A Microsoft Access table is similar in structure to a Microsoft Excel worksheet

to see the structure of a table display it in design view

each field in a table can have only one data type

A field contains a single piece of information for each record

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

Field names are listed at the beginning of each row in Datasheet view.

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

Field properties control how the field displays and how data can be entered into a table.

For numbers not used in a calculation, such as a ZIP code, set the data type as Short Text.

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

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

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

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

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

In Print Preview, if the Next Page button is dimmed, it means you are viewing the only page or the last page.

The Design view icon features a pencil, a ruler, and an angle.

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

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

Access forms can display only one record at a time.

In Form view, you can view a form's records but cannot change the layout or design of the form.

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

A database template contains prebuilt tables, queries, forms, and reports to perform a specific task, such as tracking a large number of events.

When you create a simple report, you can delete fields.

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