MICROSOFT ACCESS IS USED TO DEVELOP SIMPLE OR COMPLEX, PERSONAL AND BUSINESS DATABASE MANAGEMENT SYSTEMS. ITS CAPABLE OF RUNNING REPORTS FROM QUERIED DATA

ACCESS

INTRODUCTION COURSE

Access is a hugely popular relational database management system. This course will help you to understand the design concepts of a database and then build a relational database system. It consists of building table, query, form and report objects.

Our introduction course is suited to those who not only want to use a database but to also better understand its functions, by building a working relational database from the ground up.

  • Database basics
  • The initial screen
  • Open a database
  • View a table
  • Navigate database objects
  • Edit data
  • Spell check
  • Table vs form view
  • Resize a column
  • Move a column
  • Hide and unhide columns
  • Freeze and unfreeze columns
  • Sort data
  • Print objects
  • Create a database
  • Design a table
  • Table field properties
  • Restructure tables
  • Filter records
  • Find data
  • Create a form
  • Create a report
  • Create a report using the wizard

This course is designed for those who have had some or no experience of using Microsoft Access.

INTERMEDIATE COURSE

A business requires its people to be capable of understanding the design and operation of their databases. Our intermediate course is designed to fulfil this need and includes building useful business queries to extract and manuipulate data. Enhance user forms with essential controls to quickly view data. Group records with calculations in reports. Run action queries to give users more control over the manipulation of existing data.

  • Import and export data
  • Create primary keys
  • Convert field types
  • Customize field properties
  • Use the expression builder
  • Query tables
  • Save and open a query
  • utilise wildcards
  • Compound queries
  • Miscellaneous operators
  • How to validate data
  • Add basic form controls
  • Use form properties
  • Summary operators
  • Query multiple tables
  • Create reports
  • Customize reports
  • Add simple report calculation
  • Creating forms
  • Customize forms
  • Add simple form controls

Attendees are required to be competent with our introduction content before attending the intermediate course.

ADVANCED COURSE

When a business must be sure that steps are taken to prevent accidental or deliberate loss, damage or misuse of data, a customised approach is often preferred. Our advanced course takes these steps, integrating and automating the system using events, and building calculations within query, form and report objects.

  • Index a table
  • Parameter queries
  • Crosstab queries
  • Designing forms with subforms
  • Adding bound and unbound objects
  • Change object properties
  • Add combo and list boxes
  • Add group options
  • Design command buttons
  • Link forms to controls
  • Edit form controls
  • Create custom reports
  • Create grouped reports with calculation
  • Display choices
  • Back up your database
  • Convert a database
  • Compact and repair databases
  • Linked table manager
  • Secure your database

Attendees are required to be regularly using Access and feel competent with our intermediate content before attending this course.