CPATrainingCenter.com offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description
Title:

Microsoft Access 2007

SKU:PA-1005414
Format: Self-Study Course
Order:Qty:
Description:

Knowing how to work Access 2007 is a valuable skill that most companies look for when hiring new staff, which is why you should take our Access 2007 training course if you want to stay competitive in the workforce.

Learn from some of the industry's best instructors when signing up for our dynamic course that features tons of multimedia components that enhance your learning experience. . Learn all these new features in our course that will teach you how to master the ins and outs to this version of the popular database program.

Basic Course Outline

1.0 Exploring the Access Environment

1.1 Opening Access 2007
1.2 Getting Started with Access
1.3 Using a Database Template
1.4 Overview of the User Interface
1.5 Navigating in the Database
Lab


2.0 Building a Database

2.1 Creating a New Database
2.2 Creating a Table
2.3 Managing a Table
2.4 Using a Table Template
Lab


3.0 Managing Data in a Table

3.1 Adding Table Data
3.2 Modifying Table Data
3.3 Sorting Records
3.4 Filtering Records
Lab


4.0 Working with Queries

4.1 Viewing an Access Query
4.2 Creating a Query
4.3 Adding Criteria to a Query
4.4 Creating a Query Using the Query Wizard
Lab


5.0 Designing Forms

5.1 Viewing Data Using an Access Form
5.2 Creating a Form
5.3 Creating a Form Using the Form Wizard
5.4 Modifying the Design of a Form


6.0 Generating Reports

6.1 Viewing an Access Report
6.2 Creating a Report
6.3 Creating a Report Using the Report Wizard
6.4 Applying an AutoFormat to a Report
6.5 Preparing a Report for Print
Lab

Intermediate Course Outline

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
Lab


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
Lab


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
Lab


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
Lab


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
Lab


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
Lab

Advanced Course Outline

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

Microsoft Access 2007 CBT Training

This dynamic Access 2007 training CD program is taken right from your computer so you never have to step foot at an offsite location. The self-paced Access 2007 computer based training videos features tons of interactive learning strategies, such as demos, discussions and much more! With our computer based training course, you get to be the boss and learn on your own terms.

About The Provider: K Alliance provides computer based training (CBT) and online computer training videos.

We offer a complete e-learning solution in the form of either dvd, CD, intranet, or online training video courseware.

Our self-paced computer training videos include hundreds of choices in topics such as IT Training, Certification Training, Desktop Office and Soft Skills. No matter which method you prefer, K Alliance has courses to help you achieve your elearning goals.
Price: $149.00
More Info: Contact Us For More Information
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Sales &Use Tax Workshop
Sales &Use Tax Workshop

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors

Project Management Workshop
Project Management Workshop

The Controller′s Workshop
The Controller′s Workshop

How To Use QuickBooks
How To Use QuickBooks

Peachtree Seminars
Peachtree Seminars

Series 6 - Live &OnDemand Online Course
Series 6 - Live &OnDemand Online Course

Certified Tax Specialist  (CTS™)
Certified Tax Specialist (CTS™)

Certified Payroll Administrator
Certified Payroll Administrator

Payroll Records: What To Keep, What To Toss
Payroll Records: What To Keep, What To Toss

FMLA Training &Certification Program
FMLA Training &Certification Program

Become an ′America First′ Certified Business
Become an ′America First′ Certified Business

How To Do A Payroll Audit - Former Auditor′s Expert Advice
How To Do A Payroll Audit - Former Auditor′s Expert Advice

Multi-State Payroll Tax Compliance
Multi-State Payroll Tax Compliance

Guidelines For Taxing Gifts, Awards, &Other Fringe Benefits
Guidelines For Taxing Gifts, Awards, &Other Fringe Benefits

Google+CPATrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9941 | support@CPATrainingCenter.com
Copyright CPATrainingCenter.com 2017 | Web Site Development by OTAU
Facebook