Advanced - Access Training Course:  

 

 

Synopsis:

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/2010 applications.

Pre-Requisites:

None

Course Outline:

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

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

Learning Outcomes;

You'll learn a wealth of new techniques for manipulating information and the database that will make your life simpler, save you hours and enable you to do precisely what you want with Access.

Duration:

1 Day

No of Delegates – The Total Number of delegates that can sit this is course is a maximum of 12 to uphold the quality of our training and to ensure the course is properly embedded to achieve the companies /  individual goals.

Prices – £849 (ex VAT)  Per day for up to 12 delegates trained onsite

(An additional charge for travel will be applied at 40p per mile from Sequence HQ to your premises)