Introduction to Microsoft Access

Peter Kitson

ISBN : -

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

Cover Design - Introduction to Microsoft Access

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)

Sample Chapter From Introduction to Microsoft Access
Copyright © Univessity of Kansas

Introduction

The Access database program allows for the creation, organization and manipulation of large quantities of data. The basic building block of any database is the table, built of distinct and unique rows of information (called records), each of which are broken down into one or more columns (or fields) of predetermined and consistent size and type of data. As a relational database, an Access database can contain many tables, where the records in one table may be related to records in other tables.

Planning for a Relational Database

Because Access is a relational database management system, the database table and relationship structure should be planned out before creating the actual physical model. The Database Design workshop introduces the fundamental principles of database design and is a prerequisite to this workshop.

Creating a Table

In Access, tables are what store our information or raw data. Before you can input the information, you must first create tables. There are quite a few ways to create Access tables. You can create a table in design view (this is the most common way of table creation), create a table using the table wizard, create a table by entering data, import tables from other types of files, and link tables of other file types as well.