Exam 4: Workshop 4: Access Information From an Access Database

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

________ view allows you to filter data or copy parts of the report to the Clipboard.

A split form is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

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

Match the following form controls with their description. I.Bound II.Unbound III.Calculated IV.Text box V.Label A.Does not have a data source B.Data source is an expression C.Data source is a field in a table D.Represents the actual value of a field E.May be the name of the field

On a form,a group is a collection of records along with introductory and summary information about the records.

A ________ is a built-in combination of colors and fonts.

Calculations performed on a group in a report are added to a section called the ________.

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

Before you can use two tables in a form,you must make sure there is a(n)________ relationship between the tables.

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

An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable.

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

If you can see the blinking insertion point in a field,you are in ________.

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.

Which of the following is NOT true when resizing and managing controls?

The ________ will walk you step by step through the process of building your report.

Which of the following is NOT true about modifying a form's design?

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.