Exam 13: Access_Module_3

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

Case 3-2 ​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes. -Bavant would like to move the Account Type field in the Account table. The field should appear before the Account Manager field. What do you need to do to move the field?

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

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

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

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 ____.

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

To specify that entries in the current due field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

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

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

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.

Case 3-1 PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules. -Because many of the accounts that PrattLast Associates services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property 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.

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

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

To use Filter By Form to filter records, click the ____ button on the HOME tab and then click Filter By Form.

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

The wildcard symbols for use with filters are ____.

A(n) ____________________ query adds, deletes, or changes data in a table.

A multilookup field is a field that contains more than one value. ____________________