Access 2007 Level 2


Full Description
Access 2007 Level 2

Strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office Access 2007, including tables, queries, forms, and reports. The course also shows how to work with individual fields to ensure that overall database structure is consistent and correct. In addition, students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. Finally, students will be introduced to a few methods of managing and backing up database files.


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.


Course Information (see above or below lessons, outlines, activities, etc.)
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