Course not currently available

Access for Advanced Users

Taylor Mason Training

Short course

Inhouse

£ 949 VAT exempt

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

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. Suitable for: This course is suitable for anyone who wants to develop their skills in Access

About this course

No pre course work is required for this access training course

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database Design
  • IT
  • Database
  • SQL
  • Database training
  • Data analysis
  • Microsoft Access
  • Microsoft Office
  • Access training

Teachers and trainers (1)

Taylor Mason

Taylor Mason

Very Experienced Trainers

All our trainers are experts in their field, most of which have worked for us for some time. From 1-1 coaching to complex change programmes we have the skills and experinece. We cover, Human Resouces, Communicaton Skills, Leadership and Supervision, Microsoft & IT, Sales & Marketing, Personal Development, Health & Safety, Project Management, PA & Office Skills,

Course programme

Course review:

We can train 2000 / 2003 / 2007 / 2010 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.

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

Additional information

Payment options: The price shown is cost per day **

See related categories

Access for Advanced Users

£ 949 VAT exempt

The best Access courses

See all

See all