MCSE Training Course Tutorial MCSE Certification course A+ Network + .NET CCNA Tutorials

CertCBT

Home of IT Certification Training - CBT

Home : Member Login: Demos: Courses: Subscriptions: FAQ/Guarantees: Testimonials: Terms: About Us: Contact Us

Subscription based memberships

Video courseware included

Audio exam series included

E-Books included

Practice Exams included

Access to all Latest Material

SSL Secure Ordering

24*7 Helpful Support

Server 2008 Administrator
Server 2008 Enterprise Admin
MCSA 2003 to 2008 Upgrade
MCSE 2003 to 2008 Upgrade
2008 Active Directory
2008 Network Infrastructure
2008 Apps Infrastructure

(Cisco)
Cisco CCNA Training
CCNA Security Training
Cisco CCNP Training
CCNP BSCI Training
CCNP BCMSN Training
CCNP ISCW Training
CCNP ONT Training

(CompTIA)
CompTIA A+
CompTIA Network+ 2005
CompTIA Security+
CompTIA Server+
CompTIA Linux+

(Other Training)
CISSP Training
CWNA Training
ISACA Training
PMI Training

Microsoft® Certifications Computer Based Training

Back

77-605 - MCAS® Series: Microsoft® Office Access® 2007

Session 1
Section A: Understanding Access

• What Is Access?
• Access vs. Excel
• Components, Objects, and Terms
• Changes In 2007

Section B: Getting Started

• Application Overview
• Using Templates
• Using the Ribbon
• The Navigation Pane
• Shortcut to Forms
• Finding Help

Section C: Using the Navigation Pane Effectively

• Group View Options
• Item View Options
• Organizing Items
• Navigation Options
• Table Views
• Query and Form Views
• Report and Macro Views

Section D: Data Entry

• Working with Records
• Entering and Editing Records Data
• Deleting Records
• Sorting Data In Records
• Finding Data in Records
• Entering Data In Forms

Section E: Database Design

• Design Steps
• Purpose
• Tables
• Fields
• Relationships
• Primary Key
• Making the Relationship
• Naming Conventions
• Design Cleanup
• Example: Purpose and Tables
• Example: Primary Key and Relationships

Section F: Creating Databases and Tables

• Create Blank Database
• Datasheet View
• Saving Tables
• Table Templates

Session 2
Section A: Working with Tables

• Design View
• Text and Memo Data Types
• Number Data Types
• AutoNumber Data Types
• Yes/No Data Types
• Data Beyond the Database
• Creating Tables
• Setting Primary Keys

Section B: Field Properties

• Field Properties Overview
• Modifying Fields
• Text Field Properties
• Number Field Properties
• Validation Rules
• Arranging and Deleting Fields
• Viewing Changes
• Validation Text
• More Field Properties
• Memo Fields
• Attachment Fields
• Input Masks

Section C: Lookup Fields

• Creating Lookups
• Design View Lookups
• Lookup Properties

Section D: Relationship Theory

• Relationship Basics
• Beyond Relationship Basics
• Relationship Types
• Putting Relationship Theory Together

Section E: Creating Relationships

• Viewing Relationships
• Building and Modifying Relationships
• Relationship Reports
• Joining Table Properties

Section F: Analyzing Design

• Cleaning Up
• Formatting Datasheets
• Hiding Columns
• Rearranging Fields
• Performance Analyzer

Section G: Subdatasheets and Filters

• Adding Subdatasheets
• Subdatasheet Display
• Removing Subdatasheets
• Filtering by Selection
• Number Filtering
• Filtering by Form
• Advanced Filters
• Total Row Summaries

Session 3
Section A: Query Basics

• Query Wizard
• Selecting Data Sources
• Selecting Fields
• Sorting Fields
• Arranging Fields
• Criteria
• Comparison Criteria
• Range Criteria

Section B: Intermediate Queries

• Field Properties
• Query Properties
• Unique List
• Outputting All Fields
• Removing Tables
• Multiple Table Queries
• Query Relationships

Section C: Calculation in Queries

• Adding Fields
• Calculation Fields
• Null Values
• Totals
• Expression Builder

Section D: Special Queries

• Crosstab Queries
• Modifying Crosstab Queries
• Finding Duplicate Records
• Finding Unmatched Records
• Parameter Queries
• Range Parameters
• SQL View

Section E: Action Queries

• Updating Queries
• Creating Table Copies
• Creating Table Queries
• Saving Action Queries
• Archiving Records
• Deleting Queries
• Deleting Tables

Section F: Concatenation

• What is Concatenation?
• Concatenating Data
• Reviewing Concatenation
• Concatenation Examples

Session 4
Section A: Importing/Exporting Data

• Importing Data
• Importing Objects
• Importing from Excel
• Making Changes
• Exporting Data
• Add-Ins
• Save as PDF or XPS

Section B: Using Mail Merge

• Introduction
• Mail Merge Wizard
• Creating a Merge Letter
• Sharing Outlook Contacts
• Importing Outlook Folders
• Collaboration

Section C: Basic Forms

• Lookup Tables
• Form Wizard
• Form Tools
• Layout View

Section D: Form Controls

• Design View
• Controls
• Move Controls
• Selecting Multiple Controls
• Arranging Controls

Section E: Form Design

• Font Formatting
• Conditional Formatting
• Control Types
• Query by Form
• Check Boxes
• Bind Controls
• Properties

Section F: Special Forms

• Split Forms
• Subforms
• Subform Relationships
• Creating Subforms
• PivotTable Forms
• Calculations
• Filtering PivotTables

Section G: Reports

• AutoReports
• Report Wizard
• Grouping and Sorting
• Adding Pictures
• Page Breaks
• Label Wizard
• Charts

Session 5
Section A: Controlling Display and Data Entry

• Form Properties
• Display Options
• Data Entry Options
• Lock Controls
• Bang and Dot Operator
• Query Aliases
• Query Parameters
• Dynamic Reports

Section B: Access Automation

• Remove Grouping
• Control Wizard
• Switchboard Manager
• Edit Switchboard Pages
• Edit Main Switchboard
• Customize Switchboards

Section C: Custom Automation

• Overview
• Unbound Forms
• Add Record
• Message Box
• Close Form
• Close Database
• Modal Dialog Form

Section D: Working with the File

• Custom Navigation Pane
• Arranging Objects
• Database Properties
• Access Options
• Current Database Options
• Compact and Repair
• Back Up Database
• Database Splitter
• Linked Table Manager

Section E: Security

• Security Types
• Password Protection
• User-Level Permissions
• Creating User-Level Permissions
• Security Tips

Section F: Sharing Information

• Printing Tables
• Printing Forms
• Printing Reports
• Output as File
• Database Documenter
• Save as Previous Version

Video Computer Based Training

Our CBTs provide the feel of a classroom with experts you can relate to - experts who teach not just how, but why. You get engaging instruction in an interactive setting with real world solutions to real life situations.

Our training lives up to the rigorous learning standards set by Microsoft, who specifically recommends Approved Study Guide materials to prepare for any of their exams.

Proven Results!

99% Pass Rate!
Recent analysis of students enrolled in a self-paced MCTS training curriculum shows Our certification training courses produced a 94% pass rate on the first attempt!

Our easy-to-use format allows you to concentrate on the lesson at hand and not how to run the delivery software - saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format - allowing you to get the most out of your time.

Our courses incorporate audio, video, and text training and then the total experience is reinforced with exercises and practice tests to ensure that you have really grasped the material.

Computer System Requirements
- 90MHz Pentium® processor(CPU)
- DVD Drive
- 16MBytes or more of Computer memory
- 20MBytes or more of available hard disk space
- 800x600 Screen Resolution with High (16-bit) Color or higher
- Windows 95, XP or Vista Operating System, or higher.

Cisco®, Cisco Systems®, CCDA®, CCNA®, CCDP®, CCNP®, CCIE®, CCSI® are trademarks or registered trademarks of Cisco Systems, Inc in the United States and certain other countries. CertCBT is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Microsoft®, Novell®, Citrix®, and CompTIA® are trademarks of their respective owners.

All names mentioned on our web site are trademarks of their respective owners.
Send mail to webmaster@certcbt.com with questions or comments about this web site.
Copyright© 2008-2010 CertCBT.com All Rights Reserved.