Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS Access 2003 Fundamentals

Description:

Our MS Access 2003 Fundamentals test is part of our fundamentals line of business applications tests. These tests demonstrate that you have the skills necessary to proficiently use the most popular business applications at a user level. These tests are focused on the topics used daily by most professionals and do not include some of the advanced topics and skills found in our core business applications tests. The core test in this area is our MS Access 2003 test. Our MS Access 2003 Fundamentals test covers the following topics: Automation and Integration, Data Manipulation, Database Concepts, Database Planning & Design, Forms & Data Input, Multi-User Issues, Reports & Data Output, User Interface & Application Refinement, and VBA.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline


Automation and Integration
ASP Basics
Data Access Pages
Hyperlinks
MSDE
OLE Linking & Embedding
Optimization
Static HTML Export Page
Word Mail Merge
XML Export & Import
Data Manipulation
Access QBE Grid
Advanced Queries
Expressions
Join Types
Query Types
SQL
Database Concepts
Fields and Data Types
Relationships
Tables
Database Planning & Design
Data Integrity
Database Normalization
Database Structure
Database Templates
Logical Architecture
Physical Architecture
Forms & Data Input
Form Controls
Form Events
Forms
Sub-Data Sheets
SubForms
Multi-User Issues
Distribution
Maintenance
Replication
Security
Shared Access
Reports & Data Output
Data Exports
Pivot Tables
Report Controls
Report Events
Reports
SubReports
User Interface & Application Refinement
ActiveX Components
Basic Security
Compacting & Repairing
Converting Different Versions
Filters
KeyBoard Shortcuts
Macros
MDE Files
Object Dependency
Performance Analyzer Wizard
SwitchBoard
Toolbars & Menu bars
Wizards
VBA
Built-In Functions
Class Modules-OOP
Debugging
Defining and using Data Types
Error Handling
IDE
VBA-ADO
VBA-DAO