Access Chapter 3 Maintaining a Database Student Name

Access Chapter 3 – Maintaining a Database Student Name

1. To create a simple form, select the table in the Navigation pane, click Create on the Ribbon and then click the _______________ ____ button on the Create tab.

REF: AC 142 - AC 143

2. To move from Layout view to Form view, click the ______________ ____ button.

REF: AC 143

3. To move to the first record the quickest way is to use the shortcut at the bottom of the page and click on the ____ ___________________ button on the Navigation bar.

REF: AC 143

4. To add a record, click the _ __________________ ___ button on the Navigation bar.

REF: AC 144

5. To search for a specific record click the Find button on the Home tab shown in the accompanying figure to display the __________________ ___ dialog box.

REF: AC 146

6. As an alternate to using the Find button shown in the accompanying figure, you can press _________________ __ to search for a specific record.

REF: AC 146

7. To use Filter By Selection to find all clients located in Brandenburg, click the City field for any record where the city is Brandenburg and then click the _ _________________ button on the Home tab shown in the accompanying figure.

REF: AC 149

8. To redisplay all records after using a filter, click the _ _________________ button on the Home tab.

REF: AC 151

9. To use Filter By Form to filter records, click the _ _______________ button on the Home tab and then click Filter By Form.

REF: AC 153

10. When you use Filter By Form to restrict records that appear, you create the filter and then click the __ ____________________ button to apply the filter.

REF: AC 154

11. To create a multi valued field, create a ________________ field being sure to check the Allow Multiple Values check box.

REF: AC 161

12. To create an update query, create a new query and then click the __ ________________ button on the Design tab.

REF: AC 162

13. To preview data to be deleted in a delete query, click the _______________ ___ button after you create the query, but before you run it.

REF: AC 163

14. 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. REF: AC163

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

REF: AC 165

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

REF: AC 165

17. To specify that entries in the Amount Paid field must be between $5.00 and $100, enter ___________________ in the Validation Rule property box.

REF: AC 166

18. To indicate that the only allowable values for the Client Type field are DEM, NTD, and LAB, enter ________________________ in the Validation Rule property box.

REF: AC 167

19. If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ______________

REF: AC 168

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

REF: AC 169

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

REF: AC 176

22. To remove a total row that appears in a datasheet, click the __ ____________ __ button on the Home tab.

REF: AC 178

23. To change a query so that each item in a multi-valued field occurs on a different row, use the ____________ ___ property.

REF: AC 183

24. To order the records in the Client table by city in alphabetical order, use the ___________________ button.

REF: AC 192

25. To order the records in the Client table in reverse alphabetical order by City, click the ____________________ __ button.

REF: AC 192

26. When a database is damaged, you must return the database to a correct state. This process is called ___________ __.

REF: AC 193

27. To back up a database, open the database to be backed up, click the Office Button, point to ___________________ on the Office Button menu, and then click Back Up Database on the submenu that appears.

REF: AC 193

28. To open another database, click the Office Button, click ______________ __ on the Office Button menu, select the database to be opened, and then click the Open button.

REF: AC 194

29. To close a database without exiting Access, click the Office Button and then click __________ ___ on the Office Button menu. REF: AC 194