Course Catalog > Advanced Microsoft Access 2007 Part 1
Advanced Microsoft Access 2007 Part 1
Advanced Microsoft Access 2007 Part 1 (1 Day)
Our Access 2003 relational database training courses will help you learn how to build, maintain, and implement relational databases.
Whether you are new to Microsoft Access or an advanced user, Current Technologie's Microsoft Certified Trainers will make you a Microsoft Access guru.
Advanced Microsoft Access 2007 is for those who want to expand their knowledge and abilities with Access into some of the more specialized and advanced capabilities, such as working with improperly structured data (normalization), perform summary operations on data, create macros to automate tasks, enhance forms & reports, and use Access in other Microsoft Office applications.
Come Experience the Current Technologies Computer Learning Center Way of Training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Intended 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 take more advanced courses in Microsoft® Office Access 2007.
Course Objectives
Upon successful completion of this course, students will be able to:
- Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
- Write advanced queries to analyze and summarize data.
- Create and revise Microsoft Office Access 2007 macros.
- Display data more effectively in a form.
- Customize reports by using various Microsoft Office Access 2007 features, making them more effective.
- Maintain your database using tools provided by Microsoft Office Access 2007.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Advanced Microsoft Access 2007 Part 1 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Advanced Microsoft Access 2007 Part 1 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Advanced Microsoft Access 2007
Module 1: Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Module 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
Module 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
Module 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
Module 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
Module 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
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Certified Application Specialist (MCAS) - Access | ||
For More Information About Advanced Microsoft Access 2007 Part 1 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800