Access 2007 Level 2

Outcomes This course will teach students how to:

1. broaden and develop the basic database design skills
2. gain a more complete understanding of how to create and use the primary database objects
3. how to work with individual fields to ensure that overall database structure is consistent and correct
4. learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone
5. how to manage and back up database files

Assessment Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery. Program Outline This course consists of 58 lessons

1. Move And Delete Fields
2. Modify Multiple Data Types
3. Create And Use Hyperlinks In Tables
4. Attach A File To A Record
5. Remove A Record Attachment
6. Understand The Lookup Wizard
7. Create And Use Lookup Lists
8. Generate And Use Value Lists
9. Understand Input Masks
10. Apply And Use Input Masks
11. Understand Field Properties
12. Add Captions To Fields
13. Add Default Values
14. Propagate Field Properties
15. Specify Field Size And Format
16. Understand Indexes
17. Index Fields
18. Examine Importing And Exporting
19. Import Data To Existing Tables
20. Export Data From Access To Other Applications
21. Learn About XML
22. Import XML Files To New Tables
23. Export Database Data To XML Files
24. Understand E-mail Data Collection
25. Create A Data Collection E-mail
26. Respond To A Data Collection E-mail
27. Manage Data Collection E-mails
28. Create Multi-table Queries
29. Examine Operators And Expressions
30. Specify Criteria
31. Create Crosstab Queries
32. Display Queries In PivotChart View
33. Look At The Expression Builder
34. Add Calculated Fields Using The Expression Builder
35. Format Calculated Fields
36. Understand Aggregate Functions
37. Use Aggregate Functions In Queries
38. Understand Form Sections
39. Add Headers And Footers To Forms
40. Understand Controls
41. Add Bound Controls To Forms
42. Use Layout View
43. Create Calculated Controls
44. Add Option Groups Using A Wizard
45. Define Tab Order
46. Change Form Properties
47. Understand Report Sections
48. Create Reports In Design View
49. Add Calculated Controls To Reports
50. Add Controls To Headers And Footers
51. Format Controls In Reports
52. Look At Reports In Layout View
53. Align, Resize, And Space Controls
54. View Object Dependencies
55. Use The Database Documenter
56. Print Database Objects
57. Compact And Repair Databases
58. Back Up Database Files

Contact Hours: 6