Microsoft Access
Level 2


Participants build on the skills gained in Microsoft Access Level 1 to create a relational database system, use enhanced form design elements, use calculated queries and create customised reports.


Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1, or equivalent knowledge.

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          Principles of table design
          Normalizing data
          Normalizing data for fourth and fifth normal forms

          Principles of table relationships

          Analyzing table relationships
          Establishing and testing referential integrity

          Table design techniques

          Data validation techniques
          Indexing techniques

          Designing select queries

          Working with calculations
          Creating multiple-table queries
          Enhanced form design
          Customizing the form design
          Adding calculations to a form
          Adding combo boxes to a form
          Adding unbound controls

          Subform design

          Creating a form that contains a subform
          Using the Form Wizard to create a form that contains a subform

          Customizing reports

          Customizing a report created by the Report Wizard


          Using the Chart Wizard
          Mailing labels

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2018