Mastering Access 2007`

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Put Microsoft Office 2007 to work for you in a 8 hours!

Get to know the new interface and new features of New Microsoft Office 2007
Learn to create a sample Access database within 24 hours (student database)
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

Course Content

Expand All

1 – Getting Started with Microsoft Access 2007 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

1.1 – Introduction to Microsoft Access

1.2 – Opening up Access 2007

1.3 – Getting Started with Access Options and Toolbar

1.4 – Getting Started with Access Templates

1.5 – Getting Started with New Blank Database and Recent Database

1.6 – The Function Area

1.7 – The Navigation Pane

1.8 – Tabbed Documents

1.9 – The Status Bar

2 – Design and Creation of a Database: Student 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

2.1 – Introduction to Access database

2.2 – Design a Database: Student

2.3 – Create a Database: Student

2.4 – Create Datasheet Relationships

2.5 – Create Indexes

2.6 – Edit Field Types

2.7 – Edit Table Structure

2.8 – Format Datasheets

3 – Various Types of Queries 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

3.1 – Introduction to Query

3.2 – Creating a Select Query

3.3 – Creating a Parameter Query

3.4 – Creating a Crosstab Query

3.5 – Creating a Criteria Query

3.6 – Performing Calculations Using a Query

3.7 – Creating a Operation Query

3.8 – Creating an SQL Query

4 – Forms 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

4.1 – Introduction to Forms

4.2 – Command Buttons Used to Create Forms

4.3 – Creating a Form Using The Form Wizard

4.4 – Creating Forms Using The Form Tool

4.5 – Creating a Split Form

4.6 – Using Form Design View To Create And Edit A Form

4.7 – Applying Controls In The Form Design View

4.8 – Creating Command Buttons In The Form Design View

4.9 – Creating a Switchboard Form

5 – Reports 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

5.1 – Introduction to Report

5.2 – Using the Report Tool to Create a Report

5.3 – Using the Report Wizard to Create a Report

5.4 – Using the Label Wizard to Create Labels

5.5 – Creating a Report Using Design View

5.6 – Editing a Report

5.7 – Sorting and Grouping In A Report

5.8 – Calculations In a Report

5.9 – Printing Reports

6 – Importing and Exporting Data 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

6.1 – Introduction to importing and Exporting Data

6.2 – Importing Access Files

6.3 – Importing Excel Files

6.4 – Importing Sharepoint Files

6.5 – Importing Text Files

6.6 – Importing XML Files

6.7 – Linking to Access Files

6.8 – Linking to Excel Files

6.9 – Exporting a Table as an Excel Worksheet

6.10 – Exporting to a Sharepoint Site

6.11 – Exporting as a PDF or Other Type Of File

7 – Use of Macros to Automate Tasks 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

7.1 – Introduction to Macros

7.2 – Creating a Macro 1st Method

7.3 – Creating a Macro 2nd Method

7.4 – Editing a Macro

7.5 – Creating a Macro Group

7.6 – Creating a Conditional Macro

8 – Use of VBA and Modules 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

8.1 – Introduction to Module

8.2 – Creating a Class Module

8.3 – Creating a Standard Module

8.4 – Creating and Debugging Procedures

8.5 – Editing a Module

9 – Database Management and Security 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

9.1 – Introduction to Database Management

9.2 – Backup a Database

9.3 – Compacting and Repairing a Database

9.4 – Data Analysis

9.5 – Setup Passwords

9.6 – The Trust Center

9.7 – Save as an accede File (Execute-only Database)