Microsoft Access is an excellent package for creating small to medium size databases. It is a relational database which means that data can be held in many different tables and then linked to create data entry forms, queries and reports.

Many people use Excel to create a database when they should be using Access. Excel is a ‘flat file’ format and is limited in it’s database capabilities. We specialise in helping people create Access databases rather than using Excel or when their Excel files start to become too cumbersome.

This two day course will take the participant through the design aspects of Access, teaching the essential aspects of database design. It covers creating forms, queries and reports and is an excellent course for people needing to create or edit an existing database.

Duration: 14 Hours

  • Initial database concepts
  • Database design
  • Creating a new database
  • Primary keys
  • Entering data
  • Using Table Wizards and the Build feature
  • Copying and Importing data
  • Formatting and Printing Tables
  • Table Properties
  • Table Relationships
  • Forms
  • Queries
  • Reports

Duration: 14 Hours

  • Compacting And Repairing a Database
  • Linking Tables
  • Advanced Queries
  • Advanced Forms
  • Advanced Reports
  • Macros
  • Creating An Complete Application
  • Check Schedule

Duration: 14 Hours

  • Modules Visual Basic
  • Working with a Form or Report Module
  • Creating a Function
  • Adding Comments to your procedures
  • Creating a more complete application
  • Combo Box Code
  • Data Access Page
  • Putting your database on an intranet with a Data Access Page.
  • Formatting Data Access Pages
  • Replicating Your Database
  • Creating replicas
  • Synchronizing replicas
  • Resolving conflicts
  • Securing Your Applicatio
  • Security basics
  • Creating a new workgroup
  • Changing user accounts
  • The logon procedure
  • Ownership
  • Permissions
  • Encryption
  • Common Mistakes
  • Security Alternative
  • Setting a Database Password
  • MDE Files
  • The Tools, Startup dialog box
  • Other useful form properties

Check Schedule
Book Now