Microsoft Access Advanced

Versions Available: 2007, 2010 and 2013

Course Overview:

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 Content:

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

Duration: One Day

Availability: Course only available on Customer Premises