Microsoft Office Tutorials and References
In Depth Information
Chapter Summary
AC 195
2. Click Table Properties (if the object is a table) or Object Properties on the
shortcut menu.
3. Change the desired property and click the OK button.
To Quit Access
You saved all your changes and are ready to quit Access. The following step quits Access.
1 Click the Close button on the right side of the Access title bar to quit Access.
Chapter Summary
In this chapter you have learned how to use a form to add records to a table; search for records; delete records; fi lter
records; create and use Lookup fi elds; create and use multivalued fi elds; make mass changes; create validation rules;
change the appearance of a datasheet; specify referential integrity; and use subdatasheets. The following list includes all
the new Access skills you have learned in this chapter.
1. Create a Simple Form (AC 142)
2. Use a Form to Add Records (AC 144)
3. Search for a Record (AC 145)
4. Update the Contents of a Record (AC 147)
5. Delete a Record (AC 148)
6. Use Filter By Selection (AC 149)
7. Toggle a Filter (AC 151)
8. Clear a Filter (AC 151)
9. Use a Common Filter (AC 152)
10. Use Filter By Form (AC 153)
11. Use Advanced Filter/Sort (AC 155)
12. Delete a Field (AC 157)
13. Add a New Field (AC 157)
14. Create a Lookup Field (AC 158)
15. Add a Multivalued Field (AC 160)
16. Save the Changes and Close the Table (AC 161)
17. Modify Single or Multivalued Lookup Fields (AC 161)
18. Use an Update Query (AC 162)
19. Use a Delete Query (AC 163)
20. Use an Append Query (AC 165)
21. Use a Make-Table Query (AC 165)
22. Specify a Required Field (AC 166)
23. Specify a Range (AC 166)
24. Specify a Default Value (AC 167)
25. Specify a Collection of Allowable Values (AC 167)
26. Specify a Format (AC 168)
27. Save the Validation Rules, Default Values, and
Formats (AC 169)
28. Use a Lookup Field (AC 172)
29. Use a Multivalued Lookup Field (AC 173)
30. Resize a Column in a Datasheet (AC 175)
31. Include Totals in a Datasheet (AC 176)
32. Remove Totals from a Datasheet (AC 178)
33. Change Gridlines in a Datasheet (AC 179)
34. Change the Colors and Font in a Datasheet (AC 180)
35. Close the Datasheet Without Saving the Format
Changes (AC 181)
36. Query a Multivalued Field Showing Multiple Values
on a Single Row (AC 182)
37. Query a Multivalued Field Showing Multiple Values
on Multiple Rows (AC 183)
38. Specify Referential Integrity (AC 186)
39. Use a Subdatasheet (AC 190)
40. Find Duplicate Records (AC 191)
41. Find Unmatched Records (AC 191)
42. Use the Ascending Button to Order Records
(AC 192)
43. Backup a Database (AC 193)
44. Compact and Repair a Database (AC 193)
45. Open Another Database (AC 194)
46. Close a Database Without Exiting Access (AC 194)
47. Save a Database with Another Name (AC 194)
48. Check for Dependent Objects (AC 194)
49. Delete a Table or Other Object (AC 194)
50. Rename an Object (AC 194)
51. Change Object Properties (AC 194)
If you have a SAM user profi le, you may have access to hands-on instruction, practice, and
assessment. Log in to your SAM account ( to launch any assigned
training activities or exams that relate to the skills covered in this chapter.
Search JabSto ::

Custom Search