This 1-day Microsoft Access training course is delivered onsite and off-site at locations across the UK.
This one-day course builds on the skills and concepts
taught in Access 2010: 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 2010 to update data.
Course objectives
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 summarize
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.
Create data validation and data-entry macros, create
macros that run parameter queries, create the AutoKeys
and AutoExec macros, and create macros to import and
export database objects.
Save to previous versions.
Split, compact, repair, and back up a database. Encrypt
and password-protect database files. Configure Access
Options and populate database file properties.
Create, populate, and modify a hyperlink field. Collect
data via e-mail by using Outlook 2010.
Querying with SQL • SQL and Access
• Writing SQL statements • Attaching SQL queries to
controls
Advanced queries • Creating crosstab
queries • Creating parameter queries • Using action
queries
Macros • Creating, running, and modifying
macros • Attaching macros to the events of database
objects
Advanced macros • Creating macros to provide
user interaction • Creating macros that require user
input • Creating the AutoKeys and AutoExec macros •
Creating macros for data transfer
Importing,
exporting, and linking • Importing objects • Exporting
objects • Interacting with XML documents • Linking
Access objects • Working with Windows SharePoint
Services
Database management • Optimizing resources
• Protecting databases • Setting options and properties
Internet integration • Hyperlink fields • Working
with Outlook 2010
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 2010: Basic and Access
2010: Intermediate.
Youshould be comfortable using a personal computer and Microsoft Windows. You
should also have some experience using Access 2010. 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
2010: Basic, Access 2010: Intermediate, and Access 2010:
Advanced