Microsoft Access
Level 3


Outcomes

Participants will learn how to use parameter and action queries, use macros to automate and streamline an Access database and use Access in conjunction with the Internet and other windows based applications.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1 and 2, 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



          Designing parameter and action queries
          Creating parameter queries
          Creating action queries

          Outer join and crosstab query techniques

          Joining tables and working with join properties
          Crosstab queries
          Editing limitations in query datasheets

          Form design enhancements

          Building a form based on joined tables; using functions in forms
          Using option groups and additional form design enhancements

          Using command buttons and macros with forms

          Creating macros and command buttons
          Using macros to control form properties
          Using macros to provide user interaction and automate tasks
          Using macros to provide user interaction
          Using macros to automate tasks

          Advanced report techniques

          Hiding duplicate data, grouping data, and using functions in reports

          Introduction to the Internet

          Using hyperlinks

          Appendices

          Replicating databases
          Using Access with other applications




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