|
Course ID: 14434
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
Access 2007 - Level 2 Training Class
Course ID: 14434
|
|
| |
|
|
| |
|
|
| |
Access 2007 - Level 2 Training Seminar
In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance. (Second Edition)
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Structuring Existing Data Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 2: Writing Advanced Queries Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 4: Making Effective Use of Forms Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form
Lesson 5: Making Reports More Effective Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot
Lesson 6: Maintaining an Access Database Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
|
|
| |
|
|
|
| |
|
|
| |
Audience |
|
| |
This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft?? Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to taking more advanced courses in Microsoft Office Access 2007.
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Access 2007 Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Access 2007 - Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 14434
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|