Course Introduction
Schedule our instructor led classroom training 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.
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 pre-built 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 Share Point Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.
Package Includes:
Course syllabus:
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
.jpg)
