Microsoft Access
Level 2


Outcomes

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.

Prerequisites

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

Location

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
          Subreports

          Appendices

          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 2017