|
|
Overview
Microsoft Office Access 2007 is the newest version of Microsoft's popular database program. This four-level course explores nearly all of Access' many features. Whether you're using Access for the first time, or have been using it for years, this course will help you make the most of Access 2007's new features and interface.
Highlights of the course include complete coverage of the new interface, details on how to plan and design a database, and an introduction to SQL.
Outline
Getting Started
To begin, participants will learn the basics of Access: how to open and close it, how to use the Getting Started Window, how to set Trust Center options, and how to get help.
The New Interface
Next, participants will closely examine the new interface, including the Quick Access Toolbar and each of the default tabs.
Creating a Database
First, we will discuss some things to consider when planning your database. Then, we will begin to create a database (using blank databases and templates) by adding tables and records.
Doing More with your Database
Next, participants will look at the basics of forms, queries, and reports, including how to sort and filter data, ways to view data, and how to print database objects.
Advanced File Tasks
Participants will learn various file management tasks in this section, including how to use My Computer within Access and various ways to save and export their database. Participants will also learn how to link files, compact and repair a database, and back up a database.
Working with Tables
This section will focus on Access' tables, including how to customize and format them and how to control and manage data entry.
Working with Forms
Next, we will examine forms, including adding all types of controls, formatting the form and its controls, and formatting records.
Working with Reports
This section will discuss reports, including ways to organize report data, formatting tools, and common tasks (such as adding a logo and page numbers).
Working with Queries
This section will focus on creating and managing queries. Types of queries covered include basic, multiple table, make table, summary, parameter, crosstab, append, delete, and update.
Advanced Data Management
Participants will learn how to establish referential integrity, how to manage table relationships, how to create and use switchboards, and how to create modal dialog boxes.
Advanced Form Tasks
This section will examine subforms, limiting user access, customizing error messages, creating event procedures, and exporting the form. Participants will also learn how to create an RSS feed for Outlook, how to import Outlook contacts, and how to use SharePoint Server and other servers with Access.
Pivoting Data
Participants will learn all about PivotTables and PivotCharts in this section.
Access and Windows
Participants will learn how to use Office diagnostics and the Access Viewer. Participants will also receive an introduction to SQL.
Add-ons to Access
This section will examine COM Add-Ins, Digital Signatures, Smart Tags, and Access options. Participants will also learn how to analyze performance, view object dependencies, replicate a database, and split a database.
Using Scripts in Access
Participants will learn how to create and use macros and macro groups in this section.
Using Access to Collaborate
This section will cover using SharePoint Server and Access.
SQL and Microsoft Access
To complete the course, participants will learn about SQL, including basic SQL conventions and how to use the SELECT statement, subqueries, and SQL joins.
|
