Main Pages

Trainingwarehouse > Courseware > IT Series > Access > Access 2003 > Access 2003 MOS

Access 2003 MOS Student Manual Ref: CMAS23SP

Hours of training: 15+

Course Objective
The main objective of this courseware is to introduce you to the basic commands, functions, and capabilities of Microsoft Office Access 2003. It is designed for computer users who are new to Access, or who only plan to use Access occasionally.

Basic Skills Checklist
The following list summarizes skills that students should be comfortable with for this courseware.

moving around the screen
using the Start button
using the Control button
using the Minimize, Restore, and Close buttons
getting Help in Windows
moving around with the mouse and keyboard
accessing menus and making menu choices
using Windows programs
sizing and moving windows
using the scroll bars
managing documents
using the toolbar and ruler
running multiple programs
using the Clipboard
finding documents
navigating folders
creating, deleting, renaming, copying, and moving files and folders
working with the Explorer
emptying the Recycle Bin
preparing floppy disks
working with the Control Panel
using the Print Manager
using TrueType fonts
using the Accessories

System Requirements
According to the Microsoft Office Users Guide, you must have the following in place prior to using the program:

a personal computer with a Pentium III or higher processor
a hard disk drive with at least 245 Mb of free space, and a CD-ROM drive
a minimum of 64 Mb RAM (add 8 Mb RAM for each additional program you may open in addition to this one)
a monitor compatible with Windows and a SVGA graphics display adapter card or higher resolution capable of displaying minimum 256 colors installed
Microsoft Windows 2000 Service Pack 3 or higher, or Microsoft Windows XP (recommended)
a mouse or other pointing device compatible with Windows

Courseware Outline

About This Courseware
Courseware Conventions
        Basic Windows Skills Checklist
A Quick Review of Basics
        System Requirements
        Obtaining Support
        Starting Access
Moving Around
Getting Help
Exiting Access

Introducing Access
Overview
        What is a Database?
        What is Access?
Looking at the Screen
Creating a Database with the Wizard
        Using the Wizard Dialogs
        Using the Switchboard
Looking Around Access
        Using the Database Window
Planning a Database
        Determining the Scope of the Project
        Designing the Table Structure
        Determining Inputs and Outputs
Creating a Database Manually
        Creating a New Database

Creating & Modifying Tables
Creating Tables in Access
        New Table Dialog Box
Creating a Table Using the Wizard
Entering Data
Defining Data Types & Properties
        Changing Views
        Setting Data Types
        Setting Field Properties
        Date Formats
        Setting a Primary Key
Creating a Table Manually
        Creating a Table in Datasheet View
        Saving a Table
        Creating a Table in Design View
Moving Around in the Table
        Using the Mouse
        Using the Keyboard
        Using the Navigation Buttons
Restructuring Tables
        Adding a Field
        Modifying a Field
        Deleting a Field
        Changing the Field Order
Formatting Tables
        Changing the Column Order
        Freezing Columns
        Changing Column Widths
        Changing Fonts
        Changing Cell Formats
Printing and Distributing Tables
        Printing Records
        Saving a Table as a Web Page

Data Manipulation
Inserting & Deleting Records
Changing Data & Undoing Changes
        Editing Data in Datasheet View
        Undoing Changes
Importing & Exporting Data
        Importing Data from Other Applications
        Exporting Data to Other Applications
Finding Data
        Exact Matching
        Partial Matching
        Case Sensitive Searching
        Using Wildcard Characters
Replacing Data in Multiple Records
Sorting Records
        Sorting by a Single Field
        Sorting by More than One Field
Filtering Records
        Filter By Selection
        Filter Excluding Selection
        Filter For
        Filter By Form
        Advanced Filter/Sort

Simple Select Queries
What is a Query?
Creating a Simple Query
        Creating a Query using the Wizard
        Creating a Query from Scratch
        Saving Queries
        Selecting Specific Fields
Adjusting the Dynaset
        Sorting the Dynaset
        Deleting Fields
Selecting Records
        Using Simple Criteria
        Using Comparison Operators
        Using Wildcard Characters
        Excluding Fields from a Dynaset
Using Multiple Selection Criteria
        Using the AND Operator
        Using the OR Operator
        Using AND & OR Operators in the Same Field
Functions & Calculated Fields
        Using the Date Function
        Calculated Fields
Changing Field Properties

Relating Multiple Tables
Establishing Table Relationships
        Understanding Relationships
        Types of Relationships
        Prerequisites to Defining Relationships
        One-To-Many Relationships
        Viewing Related Tables
        One-To-One Relationships
        Many-To-Many Relationships
Enforcing Referential Integrity
Using the Table Analyzer
Database Maintenance
        Backing Up and Restoring a Database
        Compacting and Repairing a Database
        Object Dependencies

Forms and Reports
What is a Form or Report?
Creating a Form
        Creating an AutoForm
        Using the Form Wizard
        Switching Views
Using Forms
        Moving Within Records
        Moving Between Records
        Entering and Editing Data
Modifying a Form
        Moving and Resizing Fields
        Aligning, Sizing and Spacing Controls
        Using Drawing Tools
        Adding and Modifying Text
Calculated Fields
Creating a Report
        Creating an AutoReport
        Using the Report Wizard
Modifying Reports
Creating Mailing Labels
Printing Forms and Reports
        Printing Forms
        Printing Reports

Advanced Table Design
Advanced Field Properties
        Using Input Masks
        Using Validation Rules
        Default Values and Required Fields
        Indexed Fields
Using Lookup Fields
        Entering Lookup Data Manually
        Using the Lookup Wizard
Linking Tables

Advanced Queries
Select Queries from Multiple Tables
        Inner and Outer Joins
        Unmatched Queries
Specialized Select Queries
        Parameter Queries
        Unique Queries
        Duplicate Queries
Summary Queries
        Total Queries
        Crosstab Queries
Action Queries
        Make Table Queries
        Delete Queries
        Append Queries
        Update Queries
Queries from Filters

Advanced Forms, Reports and Pages
Features of Forms & Reports
        Working with Sections
Creating Forms & Reports from Scratch
        Creating a Form in Design View
        Creating a Report in Design View
Working with Properties
        Using the Property Sheet
        Format Tab
        Data Tab
        Other Tab
Using Unbound & Bound Controls
        Applying Images
        Using List Boxes and Combo Boxes
        Using Check Boxes
        Using Option Groups
Creating Subforms & Subreports
        Creating a Subform with the Form Wizard
        Using the Subform/Subreport Tool
        Dragging & Dropping Subforms
Publishing to the Web
        Exporting to HTML
        Data Access Pages

Appendices
Projects and Case Studies
Productivity Tools
Glossary of Terms
Answers to Review Questions
Index
Microsoft Office Specialist Skills Courseware Mapping

Access 2003 MOS Specialist Student Manual

Price: (4 or fewer items) £22.95 (Excluding VAT at 20%)
Price: (5 or more items) £19.95 (Excluding VAT at 20%)

Quantity:

Trainingwarehouse > Courseware > IT Series > Access > Access 2003 > Access 2003 MOS