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.
After completing this course, students will know how to:
Querying with SQL
Topic A: SQL
and Access
Topic B: Writing SQL statements
Topic
C: Attaching SQL queries to controls
Advanced queries
Topic A:
Creating crosstab queries
Topic B: Creating
parameter queries
Topic C: Using action queries
Macros
Topic A: Creating,
running, and modifying macros
Topic B: Attaching
macros to the events of database objects
Advanced macros
Topic A:
Creating macros to provide user interaction
Topic B:
Creating macros that require user input
Topic C:
Creating AutoKeys and AutoExec macros
Topic D:
Creating macros for data transfer
Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting
objects
Topic C: Working with XML documents
Topic D: Linking Access objects
Topic E: Using
hyperlink fields
Database management
Topic A:
Optimising resources
Topic B: Protecting databases
Topic C: Setting options and properties
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.
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.
For comprehensive training, you should complete all of the following courses: Access 2013: Basic, Access 2013: Intermediate, and Access 2013: Advanced