Access Training (Advanced Users)

Delegates at the end of the advanced course will be able to:

• Have a complete understanding of the higher functions of Access
• Learn to automate functions by creating simple and then very advanced macros
• Understand advanced querying
• Add SQL statements in your queries
• Work with objects
• Understand the fundamentals of database management
• Protect valuable data sources
  

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for 10 delegates attending.

None - proficient users of Access only, or delegates who have completed our database creation course

PivotTables and PivotCharts

• Create a PivotTable
• Modify a PivotTable
• Working with a PivotChart

Creating Advanced Forms

• Designing a form based on joined tables
• Automating data entry
• Grouped control
• How to improve the user interface
• Designing subforms

Macros

• Create and run macros
• Attach macros to events of database objects

Creating Advanced Macros

• Create macros to provide user interaction
• Create macros requiring user decision
• Use AutoKeys and AutoExec macros

Exploring Access SQL

• How to identify different clauses in an SQL statement
• Writing SQL statements
• Attach an SQL statement to database objects

Integrating the Internet

• Work with hyperlink fields
• Work with data access pages

Managing Databases

• Work with database utilities to optimise resources
• Secure data by database replication

Security Fundamentals

• Protect databases

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.