Access 2003 Advanced
Who is this training course suitable for?
Our advanced Microsoft Access training 2003 course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.
Prerequisites
A working knowledge of Access or our Access Intermediate course will allow sufficient knowledge to attend our access advanced courses.
Benefits
At the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources.
Course Syllabus
PivotTables and PivotChartsCreate 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