Microsoft Access

Microsoft Access Training CoursesMicrosoft Access Foundation 1 Day Course

The Course Includes:

  • What’s new in Access 2007
  • Creating a new database
  • Opening database files
  • Creating tables
  • Using table views
  • Understanding data types
  • Setting Primary keys
  • Changing field properties
  • Creating input masks
  • Understanding table relationships
  • Using sub datasheets
  • Creating & using forms
  • Using filters
  • Creating queries

Microsoft Access Advanced 1 Day Course
The Course Includes:

  • Querying with SQL
  • Writing SQL statements
  • Attaching SQL queries to controls
  • Creating parameter queries
  • Creating crosstab queries
  • Using action queries
  • Creating and editing macros
  • Importing and exporting objects
  • Linking Access objects
  • Synchronising and replicating the database
  • Encrypting and decrypting databases