Getting Started With Access (v. 2)




This document gives an introduction to Microsoft Access - the Relational Database Management System.

Copyright
This document is copyright University of Leeds. Permission to use material in this document is given for non-commercial academic use provided this copyright statement is included.

Format Conventions

In this document the following format conventions are used:

References are given in bold and enclosed in square brackets

[Rock-Evans]

Terms which are defined for the first time are given are given in bold

field

Field names are given in bold italic

Author

Contents

Introduction

Fundamentals

System Requirements

Data Types Supported by Access

Restrictions imposed by Access

Running Access

Help

Creating a New Database

Opening an Existing Database

Creating Tables within a Database

Field properties

Indexes

Table Properties

Saving and Naming a Table

Modifying the structure of a table

Viewing Data

Sorting

Finding a record in a table

Special Characters (Wild cards)

Inserting, Deleting and Modifying Data

Using Existing Data

Exporting to Other Systems

Queries

Displaying Wanted Data from a Single Table

Editing Through a Query

Sorting Information

Operators

AND, OR and NOT

Expressions

Groups and Summary Statistics

Joining Information

Query Properties

Field Properties

Parameters

Global Editing

Relationships

Forms

Creating a Form for a Single Table

Anatomy of a Form

Form Attributes

Controls

Altering the Design of a Form

Filters

Sorting

Creating a Form for Related (Master Detail) Tables

Expressions and Totals

Reports

Creating a Report

Expressions and Totals

Macros

Modules

Concurrent Access to Data

Security

Locked Records

Deleting Database Objects

Renaming Database Objects

Options - Changing Access's Behaviour

Converting from Access 1

Documentation

Appendix 1 Example Database

 



Oregon State University, College of Forestry, Forestry Community, Forestry Search, Network Support
OSU | CoF | Community | Search | Forestry Computing Helpdesk

You may direct comments to Websupport
Disclaimer
Last Updated Tuesday, 15-Sep-1998 09:19:06 PDT