Microsoft Access 2007 Introduction Training Course Outline

Audience: This course is designed for new or self-taught Microsoft Access 2007 users. The course will cover all aspects of database design and objects.

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Access 2007 introduction training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Understand the role of Microsoft Access objects
  • Plan a relational database
  • Create fields and tables
  • Create forms from scratch or using the Form Wizard
  • Understand Select queries
  • Create calculated fields
  • Produce Reports

Course Outline

Module 1: Introduction to Microsoft Access

  • What is a Microsoft Access Table?
  • What is a Microsoft Access Query?
  • What is a Microsoft Access Form?
  • What is a Microsoft Access Report?

Module 2: Working with Microsoft Access

  • Starting Microsoft Access
  • Using the Access Ribbon
  • Opening an existing Microsoft Access database
  • Navigating Microsoft Access
  • Quitting Microsoft Access

Module 3: Working with Tables

  • Opening an existing Microsoft Access table
  • Adding, editing and deleting records
  • Finding specific records 
  • Sorting and filtering the data
  • Hiding and unhiding columns
  • Printing the table
  • Freezing columns
  • Moving columns

 

Module 4: Planning a Microsoft Access Relational Database

  • Creating tables
  • Using Quick Start fields
  • Setting field properties
  • Setting the primary key
  • Defining relationships
  • Setting referential integrity
  • Creating lookups
  • Creating calculated fields

Module 5: Working with Forms

  • Creating a form with the Form Wizard
  • Editing a form
  • Opening a form
  • Adding, editing and deleting records
  • Find and replace records
  • Filtering data in a form

Module 6: Introduction to Select Queries

  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Using query criteria
  • Adding calculated fields
  • Summarising data

Module 7: Microsoft Access Reports

  • Creating a report using the Report Wizard
  • Using Design View to modify a report
  • Previewing a report
  • Printing the report