call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Save up to 30%
Off Publishers Retail Prices

courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted




Access 2007

 
Bookmark and Share
Microsoft Access 2007 Training CDs
CareerAcademy
Save an Extra 20%
Use Promotion Code: CAAUGPR4 when you Checkout.

Limited Time Offer
Access 2007
DVD Course £117.00  £58.00 + VAT
Buy Now
Online Course £117.00  £58.00 + VAT
Buy Now
Multi User DVD Course £234.00  £117.00 + VAT
Buy Now
 

More on Single User, Multi User & Network Licences

More on Online Training

 

PACKAGE INCLUDES

 •  3 DVDs featuring live instructor-led classroom sessions with full audio,
        video and demonstration components
 •  Hands-on Lab Simulations with detailed instructions
 •  Testing Modules to insure that you fully understand the subject matter.


COURSE INTRODUCTION

Schedule our instructor led classroom training course for the Access 2007 at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.

In this training course, discover how with its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access 2007 helps you track and report information with ease. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.

Microsoft Access 2007 Launch Video Demo



SPECIAL FEATURES OF OUR TRAINING COURSES


Comprehensive Menu Structure 
Move through hours of in-depth content - quickly and easily with the time saving Main Menu and Sub-Menu structure. Search for a specific topic or go through the course step by step. The choice is yours.   


Player Controls
Move forward or back in the training course, repeat entire topics or just a section. A progress bar illuminates as you advance through the video tutorials and exercises. Play, pause rewind, fast forward or stop at any time


Continue Where You Left Off 
All training courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you were.


Full Motion Video and Audio 
All training courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.


Review Exercises
Each training section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.


Live Demonstrations
Demonstrations in the training  course are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.


Interactive Labs
This training course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software without the need for purchasing it or having it installed on your computer.


PowerPoint Presentations 
Utilizing PowerPoint presentations in the training course enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...


Multi-User Licencing 
All of our training courses can be purchased with a standard Single User Licence, Multi User Library Licence or a Network Licence. Please contact us for more information and prices.


Certificate of Completion 
Our Training Courses are recognized worldwide for their technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a CareerVision Distance Education Certificate of Completion.



View CareerAcademy Demo Videos

COURSE OUTLINE

MS Access 2007 Level One

Lesson 1 - Exploring the Access Environment
Exploring the Access Environment
Database
Database Terminology
Relational Databases
Getting Started With Microsoft Office Access Window
The Microsoft Office Button
The Ribbon
ScreenTips
The Quick Access Toolbar
The Navigation Pane
The Tabbed Document Window Viewing Feature
The Microsoft Office Window Frame
The Home Tab
The Create Tab
The External Data Tab
The Database Tools Tab
Contextual Tabs
Dialog Box Launchers
Galleries
The Access Options Dialog Box
Customize Options
Access Help 2007
Access Help Toolbar Options
Table
Query
Recordset
Form
Report
Demo - Navigation
Demo - Customize Access
Demo - Help
Lesson 1 Review

Lesson 2 - Designing a Database
Designing a Database
The Relational Database Design Process
Statement of Purpose-Example
Statement of Purpose-Non-Example
Existing Data-Paper Format
Existing Data-Electronic Format
How to determine Additional Fields
Field and Table Names
How to Group Fields into Tables
Normalization
Denormalization
Primary Keys-Example
Primary Keys-Non-Example
Composite Keys
Foreign Keys
Table Relationships
One-to-One Relationship
One-to-Many Relationship
Lesson 2 Review

Lesson 3 - Building a Database
Building a Database
Access Database Templates
Table Views
The Field Insertion Feature
Field Templates Task Pane
Data Types
Rich Text Memo Field
Auto Calendar
Multi-valued Fields
File Types
Table Properties
Table Design Options
Referential Integrity
The Relationships Window
The Edit Relationships Dialog Box
Relationship Report
Demo - Create Database
Demo - Create Table
Demo - Manage Table and Relationship
Lesson 3 Review

Lesson 4 - Managing Data in a Table
Managing Data in a Table
The Search and Replace Commands
The Totals Feature
Records Sorting
Subdatasheet
Subdatasheets
Demo - Managing Data
Demo - Sorting
Lesson 4 Review

Lesson 5 - Querying a Database
Querying a Database
Filter Data
Simple Queries - The Query Wizard
The Query Wizard
The Query Design Feature
Query Criteria
Comparison Operators
Conditional Operators
Arithmetic Operators
Expressions
The Expression Builder
The Zoom Dialog Box
The Property Sheet Pane
Demo -filter
Demo - Create Query
Demo - Calculations
Lesson 5 Review

Lesson 6 - Designing Forms
Designing Forms
Form Sections
The Record Navigation Bar
The Form Wizard
Controls
Demo - Use Form
Demo - Create a Form
Demo - Modify Forms
Lesson 6 Review

Lesson 7 - Generating Reports
Generating Reports
Report Sections
The Report Wizard
Summary Options
Control Properties
AutoFormat
Page Setup Options
Print Preview
Proofing Options
Demo - Create Reports
Demo - Modify Reports and Math
Lesson 7 Review
Course Closure

MS Access Level Two

Lesson 1 - Controlling Data Entry
Controlling Data Entry
Field Properties
Input Masks
Input Mask Wizard
Lookup List Fields
Lookup Wizard
Demo - Field Properties
Demo - Input Mask
Demo - Lookup Fields
Lesson 1 Review

Lesson 2 - Joining Tables
Joining Tables
Query Joins
Inner Join
Left Outer Join
Right Outer Join
The Join Properties Dialog Box
Self Joins
The Alias Property
Demo - Inner and Outer join
Demo - Join
Lesson 2 Review

Lesson 3 - Creating Flexible Queries
Creating Flexible Queries
Select Query Properties
Parameter Queries
The Like Operator and Wildcards
Common Wildcards
Other wildcards
Append Query
Action Queries
Update Query
Delete Query
Make Table Query
Demo - Query Properties
Demo - Parameter Queries
Demo - Action Query
Lesson 3 Review

Lesson 4 - Improving Forms
Improving Forms
Design Tools
Layouts
Types of Layouts
Control Padding - Narrow, Medium or Wide
Sort Data Within Forms
Anchor & Form Controls
Control Grouping and Ungrouping
Conditional Formatting
Control Wizards
Combo Box Control
List Box Control
Option Group Control
Command Buttons
Subforms
Demo - Modify Form
Demo - Sorting and Filtering
Demo - Format Form
Demo - Option Buttons
Demo - Subforms
Lesson 4 Review

Lesson 5 - Customizing Reports
Customizing Reports
Report Design
The Group, Sort and Total Pane
The Totals Feature
The Field List Pane
The Rich Text Support Feature
Report Pagination
Summarize Report Information
Subreports
Demo - Create a Report
Demo - Group Sort
Demo - Format Report
Demo - Pagination
Demo - Subreports
Lesson 5 Review

Lesson 6 - Sharing Data Across Applications
Sharing Data Across Applications
Options for Importing Data
Delimiters
Exporting Data
Mail Merge Task Pane
Demo - Import Excel
Demo - Import Export CSV File
Lesson 6 Review
Course Closure

MS Access Level Three

Lesson 1 - Structure Existing Data
Structure Existing Data
First Normal Form
Demo - Table Analyzer
Second Normal Form
Functional Dependency
Third Normal Form
Transitive Dependency
Many-to-Many Relationships
Junction Tables
Demo - Junction Table
Demo - Modify Tables
Lesson 1 Review

Lesson 2 - Writing Advanced Queries
Writing Advanced Queries
Subqueries
Subqueries: Process
Demo - Subquery
SQL
Steps: Create a Subquery in SQL view
Unmatched Queries
Steps: Unmatched Queries
Find Duplicates Queries
Steps: Duplicate Query
Demo - Unmatched and Find Duplicates
Summarize Records using Criteria
Demo - Summarizing Records
Crosstab Query
Demo - Crosstab
PivotTable and PivotChart
PivotChart
Demo - PivotChart
Lesson 2 Review

Lesson 3 - Simplifying Tasks with Macros
Simplifying Tasks with Macros
Macro
Macros
Demo - Macro Form
The Macro Builder Window
Macro Actions
Action Arguments
Demo - Command Buttons and Expressions
Object Events
Macro Conditions
Steps: Restrict Records Using a Condition
Plan a Macro
Embedded Macros
Demo - Mandatory Data Entry and Message Box
Demo - Automate Data Entry
Lesson 3 Review

Lesson 4 - Making Effective Use of Forms
Making Effective Use of Forms
Active X Controls
Form Format Properties
Demo - Calendar Form
Tab Control
Demo - Tab Control
Demo - Pivot
Lesson 4 Review

Lesson 5 - Making Reports More Effective
Making Reports More Effective
Chart
Chart Types
Demo - Chart in Report
Demo - Column Report
Demo - Cancel Printing
Report Snapshot
Demo - Snapshot
Lesson 5 Review

Lesson 6 - Maintaining an Access Database
Maintaining an Access Database
Links to External Data Sources
Linked Table Manager
Demo - Link Tables
Managing a Database
Object Dependencies Task Pane
Demo - Compact and Repair Object Dependencies
Database Documenter
Performance Analyzer
Demo - Performance
Lesson 6 Review
Course Closure

 

 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk


red arrow Website design by Aimpro UK red arrow Terms