Microsoft Access 2007 Interactive Training CD Course

access-2007-cover.jpg
access-2007-cover.jpg

Microsoft Access 2007 Interactive Training CD Course

0.00

Product Details


Learn Microsoft Access 2007 is easy with step-by-step Training

 

 

 

Microsoft Access is a program that can perform wonders if you know how to work it. With Microsoft Access 2007 training, you can learn the major functions and features of this particular version and how to get the most out of your software investment. 

One of the best ways of learning this complex program is by getting your hands on it and doing the steps yourself. You can accomplish this by using a self-study Microsoft Access training CD. In fact, you don't even need to have a copy of Access installed on you computer. That's because our Access 2007 CBT comes with a simulated environment. You can perform actual steps and techniques from within our training software. 

To get started, simply install the self-study MS Access tutorial CD onto your desktop or notebook computer. You can study when time permits without worrying about attending classes. With computer based training, you get a completely interactive learning experience complete with animations, graphic demonstrations, narration, videos, hands-on exercises, and high-quality curriculums. 

Use the Access 2007 training cbt to learn about creating tables, forms, queries, relationships, reports, and more. Get up to speed by choosing a self-study MS Access 2007 tutorial CD from Amazing eLearning.  
 

  • Get to know the interface and features of Access 2007.
  • Learn to use Access 2007 so that you can design and create databases, queries, forms and more....
  • 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 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 Access 2007 and tutorial at the same time.

Outline

Training Level: Basic to Advance

Table of contents

Lesson 1: Getting Started with Office Access 2007

1.1 Opening up Access 2007

1.2 Getting started with access options and tools

1.3 Getting started with templates

1.4 Getting started with blank databases and recent databases

1.5 The Function Area

1.6 The Navigation pane

1.7 Tabbed documents

1.8 The status bar


Lesson 2: Design and Creation of a database: student

2.1 Design a database

2.2 Create a sample database: student

2.3 Create datasheet relationships

2.4 Create indexes

2.5 Edit field types

2.6 Edit table structure

2.7 Format datasheets


Lesson 3: Various Types of Queries

3.1 Create a select query

3.2 Create a parameter query

3.3 Create a cross tab query

3.4 Create a criteria query

3.5 Perform calculation using a query

3.6 Create an operation query

3.7 Create an SQL query


Lesson 4: Forms

4.1 Command button used to create form

4.2 Create a form using the Form Wizard

4.3 Create forms using the Form Tool

4.4 Create a split form

4.5 Use form design view to create and edit a form

4.6 Applying controls in the form design view

4.7 Create a switchboard form


Lesson 5: Reports

5.1 Use the Report Tool to create a report

5.2 Use the Report Wizard to create a report

5.3 Use the Label Wizard to create labels

5.4 Create a report using design view

5.5 Editing a report

5.6 Sorting and grouping in a report

5.7 Calculations in a report

5.8 Printing reports


Lesson 6: Importing and Exporting Data

6.1 Importing Access files

6.2 Importing Excel files

6.3 Importing SharePoint lists

6.4 Importing text files

6.5 Importing XML files

6.6 Linking to Access files

6.7 Linking to Excel files

6.8 Exporting a table as an Excel worksheet

6.9 Exporting to a SharePoint site

6.10 Exporting as .PDF or other type of file


Lesson 7: Use of Macros to automate tasks

7.1 Create a macro using 1st method

7.2 Create a macro using 2nd method

7.3 Editing a macro

7.4 Create a macro group

7.5 Create a conditional macro


Lesson 8: Use of VBA and Modules

8.1 Introduction to VBA and Modules

8.2 Create a class module

8.3 Create a standard module

8.4 Creating and debugging procedure

8.5 Editing a module


Lesson 9: Database Management and Security

9.1 Backup a database

9.2 Compacting and repairing a database

9.3 Data Analysis

9.4 Setup Passwords

9.5 The Trust Center

9.6 Saving as an .accde file (Execute-only Database)

Specs and Support


Total training time: ~21 hours
Content: CD-ROM disc (sealed in a DVD-case) 

System Requirements: 
Platform:  Windows 10, 8,  7 and Vista

Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X

 

Technical Support: support@computerlearning.com

Add To Cart