|
Other Courses |
| Office 2007 New Features |
| Access 2007 Intro |
| Access 2007 Intermediate |
| Access 2007 Advanced |
| Excel 2007 Intro |
| Excel 2007 Intermediate |
| Excel 2007 Advanced |
| PowerPoint 2007 Introduction |
| PowerPoint 2007 Intermediate |
| PowerPoint 2007 Advanced |
| Word 2007 Introduction |
| Word 2007 Intermediate |
| Word 2007 Advanced |
| Project 2007 Introduction |
| Project 2007 Advanced |
| Project 2007 Essentials |
| Outlook 2007 Introduction |
| Outlook 2007 Advanced |
| Publisher 2007 Introduction |
| Publisher 2007 Advanced |
| Visio 2007 Introduction |
| Access 2003 Intro |
| Access 2003 Intermediate |
| Access 2003 Advanced |
| Excel 2003 Intro |
| Excel 2003 Intermediate |
| Excel 2003 Advanced |
| PowerPoint 2003 Introduction |
| PowerPoint 2003 Intermediate |
| PowerPoint 2003 Advanced |
| Word 2003 Introduction |
| Word 2003 Intermediate |
| Word 2003 Advanced |
| Project 2003 Introduction |
| Project 2003 Advanced |
| Project 2003 Essentials |
| Outlook 2003 Introduction |
| Outlook 2003 Advanced |
| Publisher 2003 Introduction |
| Publisher 2003 Advanced |
| Visio 2003 Introduction |
| Visio 2003 Advanced |
|
|
[Legal Policy] | [ Privacy Policy] [Top]
|
|
Overview and objectives
This one-day Microsoft Access 2007 Training course builds on the skills
and concepts taught in Access 2007: 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 2007 to update
data.
Target audience
You should be comfortable using a personal computer and Microsoft
Windows XP or later. You should also have some experience using Access
2007. 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.
Course 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 XP: Basic, or Windows Vista: Basic and
Access 2007: Basic and Access 2007: Intermediate.
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 2007.
Course contents
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 2007