Microsoft Access Tutorials Table of Contents

Short Description
Access Tutorial 1: Introduction to Microsoft Access. The purpose of these tutorials is not to teach you. Microsoft Access, but rather to teach you some …

Website: www.cob.ohio-state.edu | Filesize: 1796kb

Content
. Michael Brydon (brydon@unixg.ubc.ca)
Last update: 25-Aug-1997 Home Previous 1 o f 8 Next
Microsoft Access Tutorials: Table of Contents
1. Introduction to Microsoft Access
1.1 Introduction: What is Access? 1
1.1.1 The many faces of Access 1
1.1.2 What is in an Access database file? 3
1.2 Learning objectives 3
1.3 Tutorial exercises 4
1.3.1 Starting Access 4
1.3.2 Creating a new database 4
1.3.3 Opening an existing database 6
1.3.4 Importing data from other applications 6
1.3.5 Getting help 9
1.3.6 Compacting your database 9
1.4 Discussion 14
1.4.1 The database file in Access 14
1.4.2 Compacting a database 14
1.4.3 Renaming a database 14
1.4.4 Developing applications in Access 15
1.4.5 Use of linked tables 16
1.5 Application to the assignment 16
2. Tables
2.1 Introduction: The importance of good table
design 1
2.2 Learning objectives 1
2.3 Tutorial exercises 1
2.3.1 Datasheet basics 2
2.3.2 Creating a new table 2
2.3.3 Specifying the primary key 7
2.3.4 Setting field properties 7
2.3.5 Using the input mask wizard 9
2.4 Discussion 9
2.4.1 Key terminology 9
2.4.2 Fields and field properties 13
2.4.2.1 Field names 13
2.4.2.2 Data types 13
2.4.2.3…