Log On/Register  

855.838.5028

Access 2007

Duration: 4 Days, 8 Modules
Module Price: $130

Access provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data. This is often the next step in data management after Excel has maximized its potential to connect information. While the entire first day of Access focuses on tables, or how the data is stored, the introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up. During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved. This course is recommended for anyone new to Microsoft Access.

Day 1:

MODULE 1: Introduction to Access & Creating Tables

Introduction to database design concepts & terminology
Open and examine and existing Access database
Working with Tables and data records
Find, sort and filter records in a table
Create tables using the design view
Create tables with the Table Wizard
Introduction to table field properties
Become familiar with the Access 2007 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips

 

MODULE 2: Working with Relationships & Tables

Relational database design concepts
Create table relationships
Explore relationship types
Define referential integrity
How to “Normalize” databases
Additional table field properties
Create a lookup list
Display object dependencies

Day 2:

MODULE 3: Queries

Create select queries
Use criteria to refine query results
Create multi-table queries
Create query joins
Implement query parameters
Performing calculations in a query

 

MODULE 4: Additional Queries, & Importing/Exporting Objects & Data

Create a totals queries
Create crosstab queries
Create Action Queries
Import/export data
Linking tables from one database to another
Use MS OfficeLinks
Overview of importing data from Microsoft Outlook
Overview of the collecting data via email feature

Day 3:

MODULE 5: Creating Forms

Creating an AutoForm
Using the Form Wizard to design new forms
Add and modify form controls
Work with control properties
Adding images and titles
Create calculated controls
Create forms in design view
Creating Forms with Sub-forms
Create tabbed forms

 

MODULE 6: Creating Reports

Using the Report Wizard to create new Reports
Modify report's page setup settings
Modify report design and layout
Work with report sections
Create summary functions
Create reports in design view
Use the Mailing Labels Wizard

Day 4:

MODULE 7: Automating Access Databases

Create macros
Implement and run macros
Event driven macros
Setting database startup options
Introduction to VBA concepts and terminology

 

MODULE 8: DB Maintenance and Deployment

Create switchboards
Discuss deploying Access databases in a multi-user environment
Explore Microsoft Access security features
Compact and repair databases
Using hyperlinks in an Access database

Access provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data. This is often the next step in data management after Excel has maximized its potential to connect information. While the entire first day of Access focuses on tables, or how the data is stored, the introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up. During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved. This course is recommended for anyone new to Microsoft Access.

Day 1:

MODULE 1: Introduction to Access & Creating Tables

Introduction to database design concepts & terminology
Open and examine and existing Access database
Working with Tables and data records
Find, sort and filter records in a table
Create tables using the design view
Create tables with the Table Wizard
Introduction to table field properties
Become familiar with the Access 2007 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips

 

MODULE 2: Working with Relationships & Tables

Relational database design concepts
Create table relationships
Explore relationship types
Define referential integrity
How to “Normalize” databases
Additional table field properties
Create a lookup list
Display object dependencies

Day 2:

MODULE 3: Queries

Create select queries
Use criteria to refine query results
Create multi-table queries
Create query joins
Implement query parameters
Performing calculations in a query

 

MODULE 4: Additional Queries, & Importing/Exporting Objects & Data

Create a totals queries
Create crosstab queries
Create Action Queries
Import/export data
Linking tables from one database to another
Use MS OfficeLinks
Overview of importing data from Microsoft Outlook
Overview of the collecting data via email feature

Day 3:

MODULE 5: Creating Forms

Creating an AutoForm
Using the Form Wizard to design new forms
Add and modify form controls
Work with control properties
Adding images and titles
Create calculated controls
Create forms in design view
Creating Forms with Sub-forms
Create tabbed forms

 

MODULE 6: Creating Reports

Using the Report Wizard to create new Reports
Modify report's page setup settings
Modify report design and layout
Work with report sections
Create summary functions
Create reports in design view
Use the Mailing Labels Wizard

Day 4:

MODULE 7: Automating Access Databases

Create macros
Implement and run macros
Event driven macros
Setting database startup options
Introduction to VBA concepts and terminology

 

MODULE 8: DB Maintenance and Deployment

Create switchboards
Discuss deploying Access databases in a multi-user environment
Explore Microsoft Access security features
Compact and repair databases
Using hyperlinks in an Access database

Prerequisites

 

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):