Tài liệu THE VISIBOOKS GUIDE TO ACCESS 2003 pptx

TABLE OF CONTENTS i

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

ii 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

DATABASE BASICS 1

Database Basics

In this section, you’ll learn how to:

• Create a new database

• Create tables

• Create records

• Create forms

• Create queries

• Create reports

2 DATABASE BASICS

Create a new database

1. Start Microsoft Access 2003.

Your screen should look like this:

DATABASE BASICS 3

2. In the Getting Started pane, click Create a new file.

4 DATABASE BASICS

3. When the New File pane appears, click Blank Database.

DATABASE BASICS 5

4. When the File New Database window appears, create a new

folder in the My Documents folder called Practice Access

Files.

Tip: To create a new folder, double-click the My Documents

folder so it appears in the Save in drop-down list.

Then click the icon.

6 DATABASE BASICS

5. Double-click the Practice Access Files folder.

It should appear in the Save in box.

DATABASE BASICS 7

6. In the File name box, type:

Friends.mdb

Tip: The file extension for Access databases is .mdb.

Just like Word files are something.doc, and Web pages are

somethingelse.html, Access databases are database.mdb.

MDB stands for “Microsoft DataBase.”

8 DATABASE BASICS

7. Click the button.

The window for the Friends database should open:

DATABASE BASICS 9

Identify database elements

Elements of databases

A database stores information in an organized way, and makes it easy

to get information in and out.

Tables store data within the database.

Forms make it easy to put data into tables.

Queries pull out specific data.

Reports put data in an easily-read format.

Table

Query

Report

Form

Table

10 DATABASE BASICS

1. In the Objects list, click Tables.

2. Click Queries.

DATABASE BASICS 11

3. Click Forms.

4. Click Reports.

12 DATABASE BASICS

5. Click Tables.

6. Click the button.

The Friends database window should expand to fill the screen: