Access Module 3 Study Guide

To create a split form, select the table in the navigation pane, click CREATE on the ribbon, click the ___ button on the CREATE tab to display a menu, and then click split form on the menu.

To move from Layout view to Form view, click the ____ button on the access status bar.

To use filter by selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.

When a filter is in effect, you can redisplay all records by clicking the ___ button on the HOME tab.

To clear a filter, click the ___ button on the HOME tab and then click clear all filters.

To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ___ command to display the custom text filters.

To use filter by form to filter records, click the ___ button on the HOME tab and then click Filter by form.

When you use Filter by Form to restrict records that appear, you create the filter and then click the ___ button to apply the filter

To filter records using complex criteria, click the ___ button on the HOME tab and then click Advanced Filter/Sort on the menu that appears.

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ___ button on the HOME tab to view the results.

To delete a field from a table, open the table in ___ view, click the row selector for the field to be deleted, and then press the DELETE key.

A ___ field allows the user to select from a list of values

To create a multivalued field, create a ___ field being sure to check the Allow Multiple Values check box.

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and click the ___ tab in the Field Properties pane.

A(n) ___ field is a field that can be computed from other fields.

To create an update query, create a new query and then click the ___ button on DESIGN tab.

To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the ___ button to update the records.

A(n) ___ query adds a group of records from one table to the end of another table.

A(n) ___ query adds records from an existing table to a new table, that is, a table that has not yet been created.

To specify that a field is to be required, change the value for the ___ property from NO to Yes.

To create a validation rule for the State field to restrict entries to TN or TX, enter ___ in the Validation Rule property box.

To specify that entries in the current due field must be between $0.00 and $30,000, enter ___ in the validation Rule property box.

If the account number field in a record always should display the three characters in the account number in uppercase, then the correct format for this field is ___.

To save validation rules, default values, and formats, click the Save button on the ___ to save the changes.

To include totals and other statistics at the bottom of a datasheet, click the ___ button on the HOME tab to include the Total row in the datasheet.

To remove a total row that appears in a datasheet, click the ___ button on the HOME tab.

To find duplicate records in a table, use the ___ Query Wizard.

To find records in one table that have no matching records in another table, use the ___ Query Wizard.

To order the records in the Account table by city in alphabetical order, use the __ button.

To order the records in the Account Table in reverse alphabetical order by City, click the ___ button.

Restructuring the database includes adding new field to a table, changing the characteristics of existing fields, and removing existing fields.

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

When you use a split form, you only can add records using the simple form.

The button on the Access status bar that displays a form in Form view is Form View.

To add a new record using Form view, click the New (blank) record button on the Navigation Bar.

Looking for the account whose number is LI268 is an example of searching.

You can search for a record in Form view but not in Datasheet view.

To open a form in Form view from the navigation Pane, right-click the form and click Form View on the shortcut menu.

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.

Four types of filters are available in Access: Filter by Selection, Common Filters, Filter by Form, and Advanced Filters.

You can use a filter in either Datasheet view or Form view.

The unfilter button toggles between filtered and unfiltered displays of the records in a table.

The Remove Filter command on the Advanced menu clear all filters.

Filter by query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38.

A lookup field allows the user to select from a list of values when updating the contents of a field.

When you create a calculated field, users can update the field.

Validation rules are rules that a user must follow when entering the data.

In the PrattLast Associates database, a one-to-many relationship exists between the Account manager table and the Account table.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

Maintenance of a database can involve the need to ____ periodically; that is , to change the database restructure.

A(n) ___ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____ command on the Advanced menu.

You can restore filter setting that you previously saved in a query by using the ___ command on the Advanced menu.

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, click the ___ for the field and the drag the field to a new location.

to create a lookup field, select ___ from the menu of available data types.

To create a multivalued field, select ___ field being sure to check the Allow Multiple Values check box.

A(n) ____ query adds, deleted, or changes data in a table.

When an update query is created, a(n) ____ row displays in the design grid.

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and click the ___ button on the HOME tab.

The property that the value in a foreign key must match another table's primary key is called ____

A(n) _____ is a field is one table whose values are required to match a primary key in another table.