Microsoft Access 2007 Intermediate Training Course Outline

Audience: This course is ideal for those who wish to interrogate existing Access databases creating queries and reports as well as gaining an insight into the fundamentals of database design using Tables and Relationships.

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 intermediate 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:

  • Create Table / Query Relationships 
  • Understand Referential Integrity 
  • Create Select queries
  • Create Calculated fields
  • Group queries
  • Create Action queries
  • Create forms and reports

Course Outline

Module 1: Table Design

  • Setting advanced field properties in tables
  • Input masks
  • Validation rules
  • Default values
  • Lookup fields
  • Relating Tables and the types of Relationships

Module 2: Creating Relationships 

  • Creating Relationships
  • Different Relationship types
  • Viewing subdatasheets
  • Setting referential integrity
  • Cascade options

Module 3: 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

Module 4: Designing Advanced Queries

  • Setting join types between tables and queries
  • Setting top values in a query
  • Creating Calculated fields
  • Creating Summary queries
  • Grouping queries
  • Creating Parameter queries

Module 5: Action Queries

  • Update Query
  • Make Table Query
  • Delete Query
  • Append Query
  • Union Query

Module 6: Working in Form Design View

  • Manipulating controls in form design view
  • Changing form and control properties
  • Adding controls to a form:
  • List boxes, Check boxes and Option buttons etc.
  • Using calculations on forms

Module 7: Working in Report Design View

  • Manipulating controls in a report
  • Changing report control properties
  • Managing sorting and grouping in reports
  • Adding calculations to a report
  • Controlling pagination

Module 8: Using Sub forms and Sub reports

  • Creating Sub forms
  • Creating Sub reports
, Microsoft Access 2007 Intermediate Training Course Outline
, Microsoft Access 2007 Intermediate Training Course Outline