Microsoft Access 2013 Advanced Training Course

This Microsoft Access 2013 Advanced Training Course
one-day course builds on the skills and concepts taught
in Access 2013: Intermediate. Students will learn how to
query with SQL; create crosstab, parameter, and action
queries; create macros; import, export, and link
database objects; work with XML documents; work with
Windows SharePoint Services; optimize databases;
password-protect and encrypt databases; set Access
options and properties; create hyperlink fields; and use
Outlook 2013 to update data.

Course
objectives

After completing this course, students will know how
to:

Use SQL statements and examine them in
Access, create aliases for fields, write SQL statements
to create queries, and attach an SQL statement to a
command button.

Create crosstab queries to summarise
grouped data, create parameter queries to view results
based on specified criteria, and create action queries
to add, delete, and modify data in tables and to make
new tables.

Create and run macros to automate tasks
and attach macros to the events of database objects.

Prerequisites

Before taking this course, you
should be familiar with personal computers and the use
of a keyboard and a mouse. Furthermore, this course
assumes that you've completed the following courses or
have equivalent experience: Windows : Basic and Access 2013: Basic and Access
2013: Intermediate.

Target Audience

Youshould be comfortable using a personal computer and Microsoft Windows. You
should also have some experience using Access 2013. You
will get the most out of this course if your goal is to
become proficient using more advanced Access features
and functions, such as querying with SQL, using
crosstab, parameter, and action queries, creating and
running macros, importing, exporting, and linking
database objects, optimizing a database, and basic
database security.

Certification Track

For comprehensive training,
you should complete all of the following courses: Access
2013: Basic, Access 2013: Intermediate, and Access 2013:
Advanced

Delivering courses on your
premises is a highly effective and
cost-effective way to provide the
training you require. Course prices are
lower than offsite and an expert
instructor comes to you at no additional
cost - you pay only the course fee.
click here to see further details

+-

Bespoke courses

In addition to our superb standard training courses we develop custom solutions, tailor courses to suit your needs and
provide consultancy services at all levels for all disciplines in all sectors.

+-

Fast-track and other training
styles

Fast track training sessions are highly-focussed intensive
training sessions delivered in short bursts to give busy people the
essential skills they need in the shortest possible time.

This type of training is different from our comprehensive,
standard, instructor-led training
course format: fast track training is dynamic, it is suitable for
people with excellent learning abilities and is typically carried out without
manuals or formal exercises but is designed and delivered by an
expert instructor to ensure that the essential skills required are
transferred very effectively and efficiently. Post-course support is
also included in the price.

+-

Pre-course assistance

Matching skill gaps and business needs to the most suitable courses
with this service will save time, effort and expense.

Pre-course assistance and advice from an expert instructor / consultant is provided and courses are designed to your business needs and staff training requirements.

+-

Post-course support

Our prices include post-course support for delegates requiring
assistance after a training course.

+-

Top-quality Manuals

Our training course manuals include notes, exercises and files that are excellent for post-course reference and further study.

+-

Training Needs Analysis

Our Training Needs Analysis (TNA) service will help training bookers,
administrators and HR professionals get the very best from their
training budget by identifying skill gaps, matching them to
top-quality courses and deliver the most effective training
possible.