Access

Data stored as a(n) ________ file cannot be imported into a table in Access.

Adobe PDF

In corporate databases, end users of a database computer system often use queries to enter and change data

False

The Format property tells Access how data is to be displayed

False

We use design view of a form to enter and edit data

False

When defining keys, the combination of two fields is called a natural primary key.

False

When the Report Wizard is done creating the report, it shows you the report in Layout view.

False

When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the subform and the second table you select becomes the main form.

False

When you delete records from a table and realize you made a mistake, you can undo the deletion by clicking Undo in the Quick Access toolbar.

False

When you enter data in a form, it is stored in the form and not the table.

False

________ give more information on how the data is stored, entered, and processed.

Field properties

Calculated query fields must be formatted in the query design grid using the ________.

Field properties sheet

A ________ query is used when you want to find records with the same specific value.

Find Duplicates

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

Find Unmatched

Which of the following is NOT true regarding the Find Unmatched query?

The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query

A split form is a form created from one table, but it has a Form view and a Datasheet view in the same window.

True

Access is a relational database program

True

Which of the following is NOT true regarding split forms?

You can highlight a different record in the form part and the datasheet part at the same time.

When you ________, you select a value in a record and Access filters the records that contain only the values that match what you have selected.

filter by selection

There are ________ major kinds of form controls

three

A(n) ________ control is a control that does not have a source of data such as the title of the form.

unbound

When you want to specify multiple criteria, and all criteria must be true for a record to be included in the results, then the ________ logical operator is used.

AND

How is Access different from Excel?

Access allows multiple tables with relationships between the tables.

By default, records in a table or query are sorted by the foreign key field.

False

Design view of a table shows the data contents within a table.

False

Design view shows all the records and fields at one time, which is one advantage to using it to update your records.

False

A report in Access has _____ views.

4

Which of the following is NOT true regarding database design?

A field is an instance of an entity.

Which of the following is NOT true about applying filters to a datasheet?

A filter is a condition you apply permanently to a table or query.

Many-to-many

A many-to-many relationship is really two one-to-many relationships with a junction/link table.

While Access allows you to leave several tables open at the same time, it is a good idea to get into the habit of ________ a table when you are finished with it.

Closing

________ define the kind of data that can be entered into a field, such as numbers, text, or dates.

Data types

________ allows you to change more details of the report design or add other controls that are only available in this view.

Design view

Which of the following is NOT one of the three steps in database design?

Determine the queries you want to create.

Which of the following is NOT true regarding tables and relational databases?

Do not use special characters, such as an underscore, in table names.

A many-to-many relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.

False

A primary key is a value in a table that is the foreign key of another table.

False

A report is an object in Access that you can use to enter, edit, or view records in a table.

False

A text box control represents the actual value of a field and is an unbound control.

False

A ________ provides another interface beyond the table in Datasheet view.

Form

Which of the following is NOT true about editing, adding, and deleting records?

If the table is part of a relationship, referential integrity has been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.

In a query, you can select any records that have no value in a field using the ________ criteria.

Is Null

________ allows you to modify the report while seeing the data.

Layout view

When you open a database, Access displays the ________ on the left side.

Navigation Pane

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

Navigation bar

Which of the following is NOT true about creating a report using the Report Wizard?

Once a report is created using the wizard, it will open in Design view.

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

Shutter

A ________ is used to ask questions about your data.

Query

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

Report

Which of the following is NOT a main object in an Access database?

Script

The most appropriate data type to use for a Street Address field is the ________ data type, so a street address can contain numbers, letters, and special characters.

Short Text

When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the main form and the second table you select becomes the ________.

Subform

Which of the following is NOT true about creating queries in Design view?

The query window in Design view allows you to specify the data you want to see by building a query by wizard.

Which of the following is NOT true about multiple-table forms?

The subform will display "one" record in the one-to-many relationship.

Which of the following is NOT true about tables?

The upper pane of Design view has four columns: Field Name, Data Type, Length, and Description.

Which of the following is NOT true about form views?

To make any changes to the form you need to switch to either Layout view or Datasheet view.

Which of the following is NOT a method used to open or switch views?

To open an object in default view, double-click it in the Navigation bar.

An Access table looks similar to an Excel worksheet. Both have rows and columns of data. In addition, both applications can manage data, perform calculations, and produce reports

True

An input mask defines a consistent template and provides the punctuation, so you do not have to type it.

True

Changing the sort order of a table in a query does not affect how the data are stored, only how they appear in the query results

True

Comparison operators are used to compare the values in a table or another query with the criteria value in a query

True

Datasheet view shows all the fields and records at one time, which provides all the information you need to update your data, unlike in a form or query, where some of the fields or records may not be in view.

True

Datasheet view shows the values of the data within the table.

True

Datasheets are used to view all records in a table at one time.

True

Design view shows the structure of the table with the fields and their definitions.

True

Each row in an Access table is called a record

True

If your data has a unique identifier that is a natural part of your data, you can use the field as a natural primary key.

True

In addition to the Simple Query Wizard, there are three additional query wizards available to make quick, step-by-step queries.

True

The AutoNumber data type is used for keys.

True

The Query Wizard uses a question-and-answer dialog box to create a query.

True

The power of a database system comes with the ability to link tables together.

True

When creating a query with multiple criteria, the logical operators are used to combine these criteria.

True

You can easily import data from Excel to Access.

True

You can use both the AND and OR logical operators in design view of a query

True

Which of the following is NOT true when entering data manually?

When you open a table in Design view, you can type data directly into the table.

A(n) ________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.

Wizard

To search for a word that starts with "ar" you would enter ________.

ar*

A(n) ________ control is a control whose data source is a field in the table such as the customer name.

bound

Access allows you to import a smaller portion of a worksheet, known as a ________, into a table.

named range

A(n) ________ key field is a field that uniquely identifies the record.

primary

A ________ is a form created from one table, but it has a Form view and a Datasheet view in the same window.

split form

To search for a three-letter word that starts with "t" and ends with "p" you would enter ________.

t?p