Microsoft Acccess

Microsoft Access

Course Duration: 15 hours

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Advanced Table Design Techniques

  • Validating Field Entries Creating a Custom Input Mask

Advanced Form Techniques

  • Creating a Master-Detail Form
  • Adding a Picture to a Form
  • Displaying the Current Date on a Form
  • Modifying Form Properties

Advanced Filter And Query Techniques

  • Creating an Advanced Filter
  • Including Multiple Conditions in a Query
  • Creating a Parameter Query
  • Creating an Action Query

Advanced Report Techniques

  • Creating an Advanced Filter
  • Including Multiple Conditions in a Query
  • Creating a Parameter Query
  • Creating an Action Query

Working With Macros And Modules

  • What is a Macro?
  • Creating a Macro
  • Running a Macro
  • Creating a Command Button
  • Writing an Event Procedure

Using Tools Menu Options

  • Setting Database Startup Options
  • Setting a Database Password
  • Encoding and Decoding a Database
  • Using the Database Splitter Wizard and the Linked Table Manager
  • Creating a Replica of a Database

Additional Advanced Access Features

  • Creating a Many-to-Many Relationship Between Tables
  • Creating a Switchboard
  • Exporting Access Data to an XML Document / Importing an XML Document into Access
  • Saving an Access Database in an MDE File
  • Creating an Access Workgroup
  • Macro Security