An organisation development specialistLinked In

Access Advanced 2010 / 2007

Duration 1 day

Designed for

This course is for experienced users who wish to extend their knowledge further and for those who are responsible for maintaining databases for other users

Pre-requisites

Delegates should have attended the introductory course or have been using the software for at least three months and have a thorough understanding of tables, queries and reports before attending this course.

Course Aims

By the end of this course delegates will be able to design a relational database, write complex queries and create advanced forms and reports. In addition they will be able to develop more sophisticated database models for use in a multi-user environment

Course Content

  • A Review of the Basics
  • Indexes
  • Hyperlinks and Attaching Files to Records
  • Adding Calendar Controls and other Active X Controls
  • Editing the Tab order
  • Creating Option Buttons, Combo and List Boxes
  • Creating Interactive Forms for Criteria Input and Menus
  • Queries to Link Data from Different Tables
  • Conditional Formatting with Reports
  • Integrating with other Microsoft Applications
  • Exporting to PDF
  • SharePoint Overview
  • Macros – Creating, Events, Grouping, Conditional
  • Startup Databases
  • Switchboard Manager Vs Automated Forms
  • Database Documenter
  • Analyze Table and Performance
  • Additional Items – Time Allowing
  • The Need for Security (SharePoint Services)
  • Activating Log On Procedure to Secure the Database

 

Content may vary slightly depending on version being used

More