Microsoft Access 2007 : Level 1 Training


Untitled Document

Package Includes:
  • 1 DVD-ROM featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Step-by-step hands-on-labs
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy
OURexpertText
Sandra Batakis

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)
Course Outline TXT
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



Price: $79.00
Buy Product Online | Visit Store Home
   

  Related Products


  Office 2003 MOUS Training - 


 Other Items from Office Users

  Office 2003 MOUS Training - 
  Microsoft Publisher 2003 Training - 
  Microsoft FrontPage 2003 Training - 
  Microsoft Word 2007 : Level 1 Training - 
  Microsoft Word 2007 : Level 2 Training - 
  Microsoft Excel 2007 : Level 1 Training - 
  Microsoft Excel 2007 : Level 2 Training - 
  Microsoft Word 2007 Training - 
  Microsoft Excel 2007 Training - 
  Microsoft Access 2007 : Level 1 Training - 
  Microsoft Access 2007 : Level 2 Training - 

 

  Return To MCSE Training MCITP A+ Certification CCNA CEH Training IT Computer Training, Online, eLearning, Videos and CBT

 

 

powered by MonsterCommerce shopping cart
E-commerce powered by MonsterCommerce shopping cart.