>

Access Course

Access Course

Access Course

Advanced Users

This access course is suited for users who already have a good working knowledge of Access, during your access course you feel confident to be able to design and build relational databases that incorporate macro automation, manipulate data  and have the skills to work with and run advanced queries coupled with the knowledge of being able to produce advanced forms and create reports

As many versions of Access are available when enquiring about this access course please let us know which version of Microsoft Access you are using, we are able to train on all versions – 2003 / 2007 / 2010 In addition we are able to provide 10 laptops with 2007/10 access preloaded to make setting up a training course much easier, we only charge a delivery and collection fee for their use.

]What will I learn

The current outline for the access training for advanced users course enables you 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 Outline

During this access training course, you learn about:

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

 

Delivery Formats:

All our in house training course are available tailored to yours and your companies/delegates needs with our CTP (customised training programme) solution. Designed to meet any challenge or level required. Ask for a full proposal for your training, tailored to suit you.

In house training at your premises – £749 for a group of up to 12 per day  (ex travel charged at 45 pence per mile)

 

X

Send this to a friend