Course 4100: Core Training for Microsoft Office Access 2003
Release date: Apr 2007, Part #: 839667
Subject: ACCESS 2003
|
![[Cover]](/covers/P6/839/839667.jpg)
|
| Price: |
£ 17.99 (inc. VAT)
Ex VAT Price: 15.31
RRP: 19.99
You Save 10%
|
|
|
 |
Description / general overview :
This course introduces the basic features and tools of Microsoft Office Access 2003, including the following: getting to know Access, creating a new database, importing and exporting information, simplifying data entry with forms, locating specific information, keeping information accurate, working with reports, making it easy for others to use the database, and keeping information secured.
This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.
This course is 6.5 hours long.
System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.
Subscription: 1 year
Contents :
Modules & Lessons
Core Training for Microsoft Office Access 2003
Pre-Assessment
Pre-Assessment
Getting to Know Access
Lesson Introduction
Exploring Access and Database Objects
Exploring Queries
Exploring Forms and Reports
Creating a New Database
Lesson Introduction
Creating New Databases
Exploring a Database
Editing Data
Creating Tables the Simple Way
Exploring Tables in Design View
Exploring Tables in Datasheet View
Importing and Exporting Information
Lesson Introduction
Importing Information from a Spreadsheet
Importing Information from a Text File
Importing Information from a Database
Importing Information from HTML and XML Documents
Exporting Information to Other Programs
Sharing Information
Simplifying Data Entry with Forms
Lesson Introduction
Creating and Exploring Forms
Creating a Form Using AutoForm
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Adding a Subform to a Form
Locating Specific Information
Lesson Introduction
Sorting Information
Filtering Information in Tables and Forms
Using Complex Expressions
Creating Queries in Design View
Creating and Exploring Queries
Performing Calculations in a Query
Keeping Information Accurate
Lesson Introduction
Using Data Type Settings to Restrict Data
Using Input Masks to Restrict Data
Using Validation Rules to Restrict Data
Using Lookup Lists to Restrict Data
Updating Information in a Table
Deleting Information from a Table
Working with Reports
Lesson Introduction
Creating and Exploring Reports
Modifying a Report
Creating and Modifying a Report in Design View
Adding Calculated Controls to Reports
Making It Easy for Others to Use the Database
Lesson Introduction
Creating a Switchboard
Creating a Splash Screen
Setting Startup Options
Keeping Information Secured
Lesson Introduction
Securing a Database
Protecting a Database Using a Password
Sharing a Database
Replicating a Database
Setting Up a Workgroup
Maintaining a Workgroup
Post Assessment
Post Assessment
Reference and Glossary
Quick Reference
Glossary
|
|
