Microsoft Office Access 2007 Training CD Online Access
Lesson 1: Getting Started with Office Access 2007
Opening up Access 2007
Getting started with access options and tools
Getting started with templates
Getting started with blank databases and recent databases
The Function Area
The Navigation pane
Tabbed documents
The status bar
Lesson 2: Design and Creation of a database: student
Design a database
Create a sample database: student
Create datasheet relationships
Create indexes
Edit field types
Edit table structure
Format datasheets
Lesson 3: Various Types of Queries
Create a select query
Create a parameter query
Create a cross tab query
Create a criteria query
Perform calculation using a query
Create an operation query
Create an SQL query
Lesson 4: Forms
Command button used to create form
Create a form using the Form Wizard
Create forms using the Form Tool
Create a split form
Use form design view to create and edit a form
Applying controls in the form design view
Create a switchboard form
Lesson 5: Reports
Use the Report Tool to create a report
Use the Report Wizard to create a report
Use the Label Wizard to create labels
Create a report using design view
Editing a report
Sorting and grouping in a report
Calculations in a report
Printing reports
Lesson 6: Importing and Exporting Data
Importing Access files
Importing Excel files
Importing SharePoint lists
Importing text files
Importing XML files
Linking to Access files
Linking to Excel files
Exporting a table as an Excel worksheet
Exporting to a SharePoint site
Exporting as .PDF or other type of file
Lesson 7: Use of Macros to automate tasks
Create a macro using 1st method
Create a macro using 2nd method
Editing a macro
Create a macro group
Create a conditional macro
Lesson 8: Use of VBA and Modules
Introduction to VBA and Modules
Create a class module
Create a standard module
Creating and debugging procedure
Editing a module
Lesson 9: Database Management and Security
Backup a database
Compacting and repairing a database
Data Analysis
Setup Passwords
The Trust Center
Saving as an .accde file (Execute-only Database)
Appendix: Database Concept and definitions
Content:
1. CD-ROM sealed in a DVD-case
2. Free Online Access Click here to create an account and access to this course immediately .
Level: Beginner to Advanced
Course Outline:
Put the Access 2007 to work for you in a few hours!
Click here to see a demo (it will take a few minutes to download the actual lesson)
Get to know the interface and new features of Microsoft Office Access 2007
Learn to create a sample Access database within 24 hours
Lessons include text, voice, and mouse activities to accommodate the three basic learning styles: reading, hearing, and doing.
The best step-by-step tutorial using the latest eLearning technology
No prior knowledge of using Access nor Database is necessary
Why our amazing elearning technology allows you to learn Access 2007 in a few hours?
Each step comes with voice, text, hightlighted box, and mouse activity.
Crystal clear audio delivered by professional narrator.
Texts are written and edited by professional editor.
Mouse motion to draw your attention.
Highlighted box to show you exactly where to click.
Easy navigation to each topic.
Playback controller to move a slide forward, backward and stop.
Full-size screen display for maximum viewing (1024 x 768)
Side-by-side learning and doing - best for using the Excel 2007 and tutorial at the same time.
