Microsoft Access 2013 Advanced

Course Details

The Course Bargains Microsoft Access course is a desktop database application, along with Microsoft Office Professional. Contrasting Excel, Access is capable to collaborate with millions of records, permitting vast databases to be produced, modernized, studied and conveyed on by multiple users. From simple data capture to complex automation and user interfaces, Access conveys all of the commanding features of a complete database, without the essentials for costly servers and administration.

Course Contents

Below is a list of modules that will be included within the course:

Advanced Data Management

  • Referential Integrity 
  • Table Relationships 
  • An Introduction to SQL 
  • Modal Dialog Boxes

Advanced Form Tasks

  • Using Sub forms 
  • Creating a Navigation Form 
  • Advanced Form Controls 
  • Exporting a Form 
  • Other Form Tasks

Creating Web Apps

  • Creating a Ready to go Web App 
  • Creating a Custom Web App 
  • Modifying Web Apps

SQL and Microsoft Access

  • Understanding SQL 
  • Using the SELECT Statement 
  • Using Sub-queries 
  • Using SQL Joins

Macros and Visual Basic for Applications (VBA)

  • Macro Basics 
  • More about Macros 
  • Access and VBA
  • Building Advanced Procedures 
  • Using VBA in a Database

FAQ's

Who will be instructing me?

You will be a taught by a qualified, knowledgeable instructor with years of experience in their field.

When should I arrive to the venue?

You should aim to arrive at 9am.

How can I contact you?

If you would like more information about any course please feel free to either contact us on 01159 031 029 or you can email us at info@coursebargains.com.