Learn the operations of Access 2007 to perform day-to-day SQL programming, form design & reporting responsibilities; understand the advantages of using relational database software and what it means to personal productivity and department level business processes.

The course starts with designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing forms & reports based on the information in the database.

You'll experience in-depth coverage of maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. Learn to build performance indexes and design crosstab queries for powerful summary reports. Learn combo box design as well as adding title, logo, datestamp and images to report. Explore importing data and linking to SQL Server.

The course also provides the fundamental knowledge and techniques needed to advance to more complex Access 2007 responsibilities such as maintaining databases and using programming techniques that enhance Access 2007 applications.

CD-ROM 1 - PERSONAL DB TOOL (2 hours 46 minutes)
1. Relational & Access Database Terminology
2. Objects: Tables, Queries, Forms & Reports
3. Designing Reports, Queries, Tables & Forms
4. Menus, Navigation Pane, Toolbar & Ribbon
5. Exploring Access 2007: Northwind Sample Database
6. Local Templates: Contacts, Projects, Tasks & more
7. Business, Education, Personal & Non-profit Templates
8. Creating DB & Tables Manually or from Template
9. Primary & Foreign Keys, Table Relationships
10. Copying, Moving, Migrating & Populating Tables
11. 3NF DB Design, Indexing Columns for Speed
12. Enforcing DB Integrity and Business Rules
13. SQL Query: Data Retrieval from Related Tables
14. Visual SQL Query Designer & Query Wizard
15. INNER JOIN, LEFT JOIN & RIGHT JOIN Operations
16. Logical, Math, Range & String Operators

CD-ROM 2 -ACCESS BASICS (2 hours 49 minutes)
1. Navigating & Managing Datasheet Views
2. Configuring Record Display in a Datasheet
3. Filtering, Sorting & Printing Records
4. Data Entry: Creating Forms with the Form Wizard
5. Configuring Controls for Forms
6. Working with Property Sheets & Getting HELP
7. Form Data Update: Pictures & OLE Objects
8. Combo Boxes and List Boxes
9. Preparing Form Headers & Footers
10. Architecting New Reports with Report Wizard
11. Creating a New Report in the Report Designer
12. Building Expressions for Dynamic Reports
13. Saving, Distributing and Printing Reports
14. Extending Access: Visual Basic for Applications
15. Designing Tables with Performance Indexes
16. The Simple & Crosstab Query Wizards

CD-ROM 3 - COMPLEX QUERIES (2 hours 47 minutes)
1. Performing Calculations : Percentages
2. The COUNT, AVG, SUM and TOP n Functions
3. Hiding Fields & Columns, Restricting Data
4. Renaming Fields in Queries, the Lookup Wizard
5. The PivotTable and PivotChart Views
6. Subtotal, Total & Grand Total Calculations
7. Aggregate Queries in Design View
8. Building Multi-Dimensional Crosstab Queries
9. Inserting (Appending) Information into a Table
10. Updating Information in a Table
11. Deleting Information from a Table
12. Find Duplicate & Unmatched Query Wizards
13. UNION, Pass-Through & DDL Queries
14. SQL Subqueries in an Access Query
15. Creating & Troubleshooting Action Queries
16. Top 10 Query Design Tips

CD-ROM 4 - COMPLEX FORMS (2 hours 54 minutes)
1. Setting & Managing Control Properties
2. Architecting & Integrating Subforms
3. Tab Stops, Option Groups & Check Boxes
4. Split Form and Multiple Items Form
5. Creating PivotChart Form, Sorting & Filtering
6. Arrange Tab - Anchoring & Autoformat Wizard
7. Combo Box Advanced Settings
8. Title, Logo and Datestamp Control
9. Image Control, Background Pictures & Animation
10. Form Tabbing, Input Masks & Fill/Back Color
11. Dialog Box for Options Collection & Gridlines
12. Composing SQL Statement & View Code
13. Adding Command, Cancel & Default Buttons
14. Designing Forms for Multi-Table Operations
15. Architecting Powerful Forms with Tab Control
16. Hyperlink, Rectangle, Line and Font Controls

CD-ROM 5 - COMPLEX REPORTS (2 hours 56 minutes)
1. The Report Wizard & the Label Wizard
2. Creating Blank Report in Layout View
3. Grouping Alphabetically & by Date Intervals
4. Line Numbering & Hiding Repeating Information
5. Apply AutoFormat Style and Date Formatting
6. Adding Totals and % Totals of Grand Total
7. Configuring Multi-Level Totals & Averages
8. Arrange Tab - Control Layout & Alignment
9. Applying Text, Number and Date Filters
10. Page Layout - Page Setup Dialog Box
11. Conditional Formatting of a Text Box
12. Show/Hide Options, Centering and Print Preview
13. Designing Reports with Multi-Table Sources
14. Data Visualization with Charts
15. Adding Subreport & Object Frame to Report
16. Logo, Image, Hyperlink & Attachment

CD-ROM 6 - DATA EXCHANGE (2 hours 40 minutes)
1. Opening Older Databases with Access 2007
2. Linking to SQL Server Databases
3. Linking to ODBC Data Sources & Excel
4. Integrate with Windows SharePoint Services
5. Importing Data from another Access DB
6. Importing Excel /CSV/Text Data
7. Importing from XML /HTML Files
8. Exporting to Other Access Databases
9. Exporting to Excel/CSV/Text Files
10. Exporting to SQL Server Databases
11. Merge Access Data with Word Document
12. Exporting to XML /HTML Files, Sharepoint List
13. Copying Charts to Other Office Programs
14. Introducing Parameters into Queries
15. Creating Reports with Parameters
16. Architecting Drill-Through Reports

CD-ROM 7 - ADVANCED ACCESS (3 hours 3 minutes)
1. Troubleshooting, Handling Errors & Exceptions
2. Distributing accdb, accde Files & Applications
3. Combo Box Based on Linked SQL Server Tables
4. Updating Linked SQL Server Tables
5. Queries on Linked SQL Server Tables
6. Reports on Linked SQL Server Tables
7. DB Documenter, Performance & Table Analyzer
8. Delivering Business Intelligence through Charts
9. Access Security and Privacy, Trust Center
10. Backup Database & Encrypting/Decrypting
11. Designing Custom Switchboards
12. Configuring Access Options, Macros & Modules
13. Database Relationships & Object Dependencies
14. Upsizing to SQL Server, Database Splitting
15. Business Intelligence Delivery via PivotTables
16. Top 10 Access 2007 Success Secrets