Microsoft Access Intermediate

12/07/2017
Loading Map....

Date/Time
Date(s) - 12/07/2017
All Day

Location
Edinburgh Training Centre

Categories


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

Course Duration: 1 day(1)

Module 1: Table Design

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

Module 2: Creating Relationships between Tables

  • 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

Bookings

£245.00