Microsoft Access 2007 : Level 3 Training


Untitled Document

Package Includes:
  • 2 CD-Roms 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 10 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 and the new Exchange 2007. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:
  • Main Menu
    Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
  • PowerPoint
    Utilizing PowerPoint presentations 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...
  • Controls
    Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.

  • Full Motion Video
    All 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 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.
  • Resume
    All 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 where.
  • Labs
    This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
  • Certificate of Completion
    Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Distance Education Certificate of Completion.
Course Outline TXT
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



Price: $99.00
Buy Product Online | Visit Store Home
   


 Other Items from Office Users

  Discoverware Word XP - 
  Discoverware Word XP Proficient - 
  Discoverware Word XP Expert - 
  Internet Explorer and Email Basics - 
  PC Security Virus and Spam protection - 
  Discoverware PC Fundamentals - 
  Discoverware Windows XP - 
  Microsoft Office XP Training - 
  Discoverware Access 2003 - 
  Discoverware Excel 2003 - 
  Discoverware Excel XP - 

 

  Return To MCSE Training A+ Certification CCNA CISSP CEH Training Microsoft eLearning MCSD Computer Training videos and CBT

 

 

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