COURSE SEARCH
 
   HOME > COURSE > MICROSOFT ACCESS 2000 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 2000 Level 1; Introduction



Course Aims
To give an introduction to database design concepts using Access 2000. 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 or Access 2000. 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:
Course Library > Databases > Access 2000
Course Library > Microsoft > Office 2000
Course Library > Microsoft > Access
Course Library > MOS

Table of Contents
Introduction to Databases
  • Database Concepts
  • Database Layout
  • Access Objects
  • Launching Access
  • Working With A Window
  • The Access Menu System
  • Getting Help
  • Creating A New Database
  • Closing A Database vs Exit Access
  • Opening A Database
     
    Tables
  • Database Design
  • Creating Tables Using The Table Wizard
  • Creating Tables In The Datasheet View
  • Creating Tables In The Design View
  • Data Types
  • Field Properties
  • Data Display Format Vs Input Mask
  • The Input Mask
  • Data Entry
     
    Working With Tables
  • Entering a New Record
  • Moving About The Table
  • Updating Field Contents
  • Selecting Records
  • Deleting Records
  • Moving And Copying Records
  • Sorting The Table
  • Deleting the Table
  • Table Layout Changes
  • Find
  • Replace
  • Wildcards
    Queries
  • The Simple Query Wizard
  • The Design View
  • Modifying the Query
  • Using Basic Criteria
  • Additional Criteria
  • Parameters
  • Multiple Object Queries
  • Custom Calculations in a Query
  • Grouping Fields
     
    Introduction to Reports
  • Reports
  • The Report Wizard
    TRY BEFORE YOU BUY BECOME A RESELLER
    Saturday 11th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft