Microsoft Access 2000 Tutorial

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Microsoft Access 2000 Tutorial
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Microsoft Access 2000 Tutorial
     Copyright © Florida Gulf Coast University



A Few Terms

These words are used often in Access so you will want to become familiar with them before using the program and this tutorial.

  • A database is a collection of related information.
  • An object is a competition in the database such as a table, query, form, or macro.
  • A table is a grouping of related data organized in fields (columns) and records (rows) on a datasheet. By using a common field in two tables, the data can be combined. Many tables can be stored in a single database.
  • A field is a column on a datasheet and defines a data type for a set of values in a table. For a mailing list table might include fields for first name, last name, address, city, state, zip code, and telephone number.
  • A record in a row on a datasheet and is a set of values defined by fields. In a mailing list table, each record would contain the data for one person as specified by the intersecting fields.
  • Design View provides the tools for creating fields in a table.
  • Datasheet View allows you to update, edit, and delete in formation from a table.

Getting Started

After opening Access, you will be presented with the window shown below. Select one of the first two options if you are creating a new database, or the third if you want to edit an existing database. All three choices are explained in detail below.

[Access startup window]

Blank Access Database

  1. Unlike Word documents, Excel worksheets, and Power Point presentations, you must save an Access database before you start working on it. After selecting "Blank Access database", you will first be prompted to specify a location and name for the database.
    [File New Database]
  2. Find the folder where the database should reside in the Save in drop-down menu.
  3. Type the name of the database in the File name line and click the Create button.