MS Access

Students will learn the skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports.

Course Content:

• Unit 1: Getting Started
  • Database concepts
  • Exploring the Access environment
• Unit 2: Databases and tables
  • Planning and designing databases
  • Exploring tables
  • Creating tables
• Unit 3: Fields and records
  • Changing the design of a table
  • Finding and editing records
  • Organizing records
• Unit 4: Data entry rules
  • Setting field properties
  • Working with input masks
  • Setting validation rules
• Unit 5: Basic queries
  • Creating and using queries
  • Modifying query results and queries
  • Performing operations in queries
• Unit 6: Using forms
  • Creating forms
  • Using Design view
  • Sorting and filtering records
• Unit 7:Working with reports
  • Creating reports
  • Modifying and printing reports