Self Study Store / Training Catalog / Desktop Training

Online Microsoft Access 2007 Training Video Course

 

 
Online Microsoft Access 2007 Training Video Course
       
Single User Price:
12 Months
$99.00
 
Microsoft Office 2007 Training:
12 Months
$199.00
 
Unlimited Desktop Library:
12 Months
$299.00
       

Knowing how to successfully work with Microsoft Access is highly sought after by many organizations and companies, which is why it is important to know how to master such a commonly used program. Enhance your computer programs knowledge by taking our self-study Microsoft Office Access 2007 online training, where you will learn everything there is to know about the program from certified instructors who have years of experience in the IT industry.

Microsoft Office Access 2007 helps information workers quickly track and report information with ease due in part to the Microsoft Office Fluent user interface and interactive design capabilities that do not really require extensive database knowledge. You can even share information on the Web on Microsoft Office SharePoint Server 2007 lists where it can be audited and back up. Our online Access 2007 training videos will teach you how to effectively use the tutorial program as it was designed to be used.

Our instructor will teach how to efficiently use the new user interface to make more informed decisions; create multiple reports with different views of the same information for various views for different audiences; use prebuilt solutions to get you working with the program immediately since the online computer training includes forms and reports that are already build for your convenience, but can still customize them to your needs; create tables quickly without working about database complexity and even paste and entire Excel table into Access 2007; efficiently work with the new field types, such as attachments and multivalue fields for even richer scenarios; and collect and update your information directly from the source then and send the form to co-workers or teammates via e-mail and use their responses to populate and update your tables, eliminating the need to retype any information.

If you take our online Access 2007 training, you will also learn how to share your information with Microsoft Windows SharePoint Services, so that your teammates can access and edit the data and view real-time reports directly through a Web interface; use Access 2007 as your rich client interface to analyze and create reports from Windows SharePoint Services lists and move data to SharePoint for better manageability; and access and use information from multiple sources to base your decisions on a more comprehensive set of information.

The best thing about the online Microsoft Access 2007 training is that you can learn on your own time without having to follow the schedule of some instructor 's as you would an offsite course. Since the Microsoft Office Access 2007 web based training videos are self-paced and self-guided, you learn at your own convenience. Simply login online with your PC or laptop and begin your learning journey. And, since everything you need to successfully learn is included within the training videos, you never need any additional materials, making the course the most cost-effective choice for learning!

Outline:

Microsoft Access 2007 Basic

1.0 Explore the Access 2007 Environment
1.1 Open Access 2007
1.2 Getting Started with Access 2007
1.3 Use a Database Template
1.4 Overview the User Interface
1.5 Navigating in the Database

2.0 Build a Database
2.1 Create a New Database
2.2 Create a Table
2.3 Manage Tables
2.4 Overview Table Relationships

3.0 Manage Data in a Table
3.1 Add Table Data
3.2 Modify Table Data
3.3 Sort Records
3.4 Filter Records

4.0 Working with Queries
4.1 Create a Query
4.2 Add Criteria to a Query
4.3 Sorting a Query Using Multiple Fields
4.4 Using AND and OR Operators

5.0 Design Forms
5.1 Create a Form
5.2 View Data Using an Access Form
5.3 Create a Form Using the Form Wizard
5.4 Modify the Design of a Form
5.5 Format the Controls in a Form

6.0 Generate Reports
6.1 View an Access Report
6.2 Create a Report
6.3 Create a Report Using the Report Wizard
6.4 Apply an AutoFormat to a Report
6.5 Prepare a Report for Print

Microsoft Access 2007 Intermediate

1.0 Working with Field Properties
1.1 Add a Primary Key to a Table
1.2 Insert, Delete, and Reorder Fields
1.3 Change a Field's Data Type
1.4 Change the Field Size
1.5 Adding a Caption
1.6 Create a List of Values for a Field

2.0 Creating Relational Databases
2.1 Understanding Table Relationships
2.2 Creating Relationships Between Tables
2.3 Enforcing Referential Integrity
2.4 Printing and Deleting Table Relationships
2.5 Overview Relationship Types

3.0 More on Queries
3.1 Create Query Joins
3.2 Relate Data Within a Table
3.3 Set Query Properties
3.4 Create a Calculated Field

4.0 Enhancing Forms
4.1 Design a Form Layout
4.2 Improve the Appearance of a Form
4.3 Add a Command Button to a Form
4.4 Create a Subform

5.0 Customizing Reports
5.1 Organize Report Information
5.2 Format the Report
5.3 Set Report Control Properties
5.4 Control Report Pagination
5.5 Summarize Report Information

6.0 Integrate Data With Other Applications
6.1 Import Data into Access
6.2 Export Data
6.3 Analyze Access Data in Excel
6.4 Export Data to a Text File
6.5 Merge Access Data with a Word Document

Microsoft Access 2007 Advanced

1.0 Database Management
1.1 Compact and Repair a Database
1.2 Backing up Your Database
1.3 Editing Database Properties

2.0 Writing Advanced Queries
2.1 Create Unmatched and Duplicate Queries
2.2 Group and Summarize Records Using Criteria
2.3 Summarize Data Using a Crosstab Query
2.4 Create a PivotTable and a PivotChart

3.0 Simplifying Tasks with Macros
3.1 Create a Macro
3.2 Attach a Macro
3.3 Restrict Records Using a Condition
3.4 Validate Data Using a Macro
3.5 Automate Data Entry Using a Macro

4.0 Making Effective Use of Forms
4.1 Display a Calendar on a Form
4.2 Organize Information with Tab Pages

5.0 Making Reports More Effective
5.1 Include a Chart in a Report
5.2 Print Data in Columns
5.3 Cancel Printing of a Blank Report
5.4 Create a Report Snapshot

6.0 Maintaining an Access Database
6.1 Link Tables to External Data Sources
6.2 Determine Object Dependencies
6.3 Document a Database
6.4 Analyze the Performance of a Database