COURSE SEARCH
 
   HOME > COURSES > MICROSOFT ACCESS XP 2002 LEVEL 1; INTRODUCTION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Access XP 2002 Level 1; Introduction




Course Aims
To give an introduction to database design concepts. This course offers a grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.
Assumed Knowledge
This course assumes no previous experience of database design. However, readers with some experience in database design will find this course beneficial if they do not know Access.
Course Audience
People who intend to design databases from scratch or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

This course can be found in the following categories:
Courses > Microsoft > Office XP
Courses > Databases > Access 2002 (XP)
Courses > Microsoft > Access
Courses > MOS

Table of Contents
Introduction To Databases
  		• Database Concepts
  		• Flat File Database Vs Relational Database
  		• Database Layout
  		• Launching Access
  		• The Access Menu System
  		• Dialog Boxes
  		• Getting Help
  		• Creating A New Database
  		• The Database Wizard Layout In Access Templates
  		• Closing A Database (Vs Exit Access)
  		• Opening A Database
  		• Exercise 1
     
    Tables
  		• Database Design
  		• Creating Tables Using The Table Wizard
  		• Exercise 1
  		• Creating Tables In The Datasheet View
  		• Data Entry
  		• Creating Tables In The Design View
  		• Data Types
  		• Setting A Single-Field Primary Key
  		• Field Properties
  		• Data Display Format Vs Input Mask
  		• The Input Mask
  		• Data Entry Problems
  		• Entering And Editing Data
  		• Selecting Records
  		• Deleting Records
  		• Moving And Copying Records
  		• Exercise 4
     
    Working With Tables
  		• Pasting Records
  		• Sorting The Table
  		• Deleting A Table
  		• Exercise 1
  		• Table Layout Changes
  		• Exercise 2
  		• Temporary Changes
  		• Freezing And Unfreezing Columns
  		• Modifying Table Structure (Fields)
  		• Exercise 3
  		• Find
  		• Replace
  		• Wildcards
  		• Exercise 4
  		• Modifying Table Data
     
    Queries
  		• Data Queries
  		• The Simple Query Wizard:
  		• Exercise 1
  		• The Design View
  		• Exercise 2
  		• Modifying The Query
  		• Exercise 3
  		• Using Basic Criteria
  		• Exercise 4
  		• Additional Criteria
  		• Exercise 5
  		• Parameters
  		• Exercise 6
  		• Exercise 7
  		• Exercise 8
  		• Exercise 9
  		• Multiple Object Queries
  		• Exercise 10
  		• Exercise 11
  		• Custom Calculations In A Query
  		• Exercise 12
  		• Grouping Fields
  		• Exercise 13
  		• Exercise 14
  		• Exercise 15
    Introduction To Reports
  		• The Report Wizard
  		• Exercise 1
     
    Appendix A: New Features In Access XP 2002
  		• The Office Task Panes
  		• Backwards Compatibility
  		• Outputting A Report To Snapshot File Format
  		• E-Mailing Database Information
  		• Improved Proofing Tools In XP
  		• Conditional Formatting In Forms
  		• Grouping Text Boxes And Other Controls
  		• Working With Data Access Pages
  		• Miscellaneous New Features In Access 2002
     
    Appendix B: New Features In Office XP
  		• What’S New In Office XP?
  		• New Office XP Features Common Across Applications
  		• Smart Tags
  		• Autocorrect Options
  		• Office XP Clipboard
  		• Office Email Introduction
  		• Other New Features In Office XP
  		• Document Recovery And Safer Shutdown
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Saturday 21st November 2009  © COPYRIGHT 2009 - VISUALSOFT