The Visibooks Guide To Access 2003.pdf

Table of Contents

Database Basics ............................................. 1

Create a new database ..........................................................................2

Create tables ........................................................................................13

Create records......................................................................................21

Create forms .........................................................................................28

Create queries ......................................................................................40

Create reports ......................................................................................47

Working with Tables ..................................... 63

Modify tables ........................................................................................64

Create new tables.................................................................................82

Specify data types................................................................................86

Specify field properties .....................................................................101

Edit records ........................................................................................104

Find records .......................................................................................108

Sort and filter records........................................................................113

Create table relationships .................................................................119

TABLE OF CONTENTS

Working with Forms ....................................131

Modify forms ...................................................................................... 132

Add/delete records ............................................................................ 146

Edit records........................................................................................ 150

Find records ....................................................................................... 153

Filter records...................................................................................... 156

Working with Queries ..................................161

Create queries.................................................................................... 162

Sort results......................................................................................... 169

Add criteria......................................................................................... 172

Employ Boolean operators ............................................................... 175

Find duplicate records ...................................................................... 181

Create Update queries....................................................................... 189

Create Delete queries ........................................................................ 197

Working with Reports..................................207

Format reports ................................................................................... 208

Create mailing labels......................................................................... 225

TABLE OF CONTENTS

Database Basics

In this section, you’ll learn how to:

•

Create a new database

•

Create tables

•

Create records

•

Create forms

•

Create queries

•

Create reports

DATABASE BASICS

Create a new database

1. Start Microsoft Access 2003.

Your screen should look like this:

DATABASE BASICS

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: