Quick, Simple Microsoft Access 2000 / Edition 1

Quick, Simple Microsoft Access 2000 / Edition 1

by Linda Ericksen
     
 

View All Available Formats & Editions

ISBN-10: 0130813206

ISBN-13: 9780130813206

Pub. Date: 07/06/1999

Publisher: Pearson

Product Details

ISBN-13:
9780130813206
Publisher:
Pearson
Publication date:
07/06/1999
Edition description:
SPIRAL
Pages:
248
Product dimensions:
8.27(w) x 10.87(h) x 4.33(d)

Table of Contents

Preface vii
UNIT 1 Getting Started 1(24)
Starting Microsoft Access 2000
2(4)
Relational Databases
3(1)
Starting Access 2000
4(2)
Becoming Familiar with the Access Interface
6(2)
Tables
7(1)
Becoming Familiar with Access Tables
8(5)
Becoming Familiar with Forms and Reports
13(2)
Forms
13(1)
Reports
14(1)
Saving Database Objects and Closing a Database
15(1)
Designing Database
16(3)
Determine All Fields
17(1)
Group Related Fields
17(1)
Create Tables
17(1)
Normalize the Data
17(1)
Define the Primary Key
18(1)
Review
19(6)
Summary
19(1)
Key Terms
19(1)
Test Your Skills
20(2)
Projects
22(3)
UNIT 2 Creating a Database 25(40)
Creating a Database
26(2)
Creating a Table Using Datasheet View
28(4)
Creating a Table in Design View
32(5)
Field Names
33(1)
Data Types
34(3)
Defining the Primary Key
37(2)
Switching Between Design and Datasheet View
39(1)
Set Field Properties
40(6)
Using the Input Mask Field Property
42(1)
Using the Validation Rule Field Property and the Validation Text Field Property
43(3)
Changing the Table Design
46(3)
Inserting a Field
46(1)
Deleting a Field
47(2)
Using the Table Wizard
49(5)
Adding Fields to Your Design
50(1)
Removing a Field
50(1)
Renaming a Field
50(1)
Naming the Table
51(1)
Relating the Table
52(2)
Documenting the Table
54(3)
Review
57(8)
Summary
57(1)
Key Terms
57(1)
Test Your Skills
57(2)
Projects
59(6)
Check Point for Units 1 - 2
61(4)
UNIT 3 Relating Tables and Working with Data 65(26)
Creating Relationships Between Tables in a Database
66(7)
Relational Design
66(1)
Creating a Relationship
67(6)
Adding Records to Tables
73(2)
Using the Lookup Wizard
75(2)
Editing Record Contents
77(2)
Deleting a Record
79(1)
Finding a Record
80(2)
Find Options
81(1)
Replacing Field Contents
82(1)
Sorting the Table
83(2)
Moving and Copying Records to Another Table
85(1)
Review
86(5)
Summary
86(1)
Key Terms
87(1)
Test Your Skills
87(2)
Projects
89(2)
UNIT 4 Querying the Database 91(30)
Using Filter by Selection
92(2)
Using Filter by Form
94(3)
Using the Simple Query Wizard
97(3)
Editing a Query
100(5)
Adding a Field to the Query
100(1)
Deleting a Field from the Query
101(1)
Sorting Query Results
102(1)
Adding a Criteria
102(2)
Saving the Changes to a Query
104(1)
Creating a Query in Design View
105(7)
More Complex Criteria
107(5)
Using Linked Tables in a Query
112(3)
Review
115(6)
Summary
115(1)
Key Terms
115(1)
Test Your Skills
115(2)
Projects
117(4)
Check Point for Units 3 - 4
118(3)
UNIT 5 Creating Forms 121(24)
Using AutoForm to Create a Columnar Form
122(3)
Using AutoForm to Create a Tabular Form
125(2)
Using the Form Wizard to Create a Form
127(4)
Using a Form
131(2)
Editing a Form
133(8)
Adding a Label
135(3)
Adding Command Buttons to a Form
138(3)
Review
141(4)
Summary
141(1)
Key Terms
141(1)
Test Your Skills
142(1)
Projects
143(2)
UNIT 6 Creating Reports 145(24)
Using AutoReport to Create a Columnar Report
146(2)
Using AutoReport to Create a Tabular Report
148(2)
Creating a Report Based on a Query
150(2)
Using the Report Wizard to Create a Report
152(5)
Using the Label Wizard
157(5)
Modifying a Report
162(3)
Review
165(4)
Summary
165(1)
Key Terms
165(1)
Test Your Skills
165(2)
Projects
167(2)
Check Point for Units 5 - 6
168(1)
UNIT 7 Expanding Database Reports and Forms 169(22)
Creating Grouped and Summary Reports
170(4)
Learning More About Relationships
174(5)
Types of Relationships
175(1)
Analyzing a Database
175(2)
Editing a Relationship
177(2)
Using Related Tables in Forms and Subforms
179(5)
Using Related Tables in Reports
184(4)
Review
188(3)
Summary
188(1)
Key Terms
188(1)
Test Your Skills
188(2)
Projects
190(1)
UNIT 8 Using Access with the Internet and Other Programs 191(28)
Adding Hyperlinks to a Table
192(4)
Defining a Field as a Hyperlink Field
192(1)
Adding a Hyperlink
193(2)
Editing a Hyperlink
195(1)
Creating a Columnar Data Access Page
196(5)
Using the Page Wizard to Create a Data Access Page
201(4)
Using Access with Microsoft Word
205(3)
Using Access with Microsoft Excel
208(4)
Review
212(7)
Summary
212(1)
Key Terms
212(1)
Test Your Skills
212(2)
Projects
214(5)
Check Point for Units 7 - 8
215(2)
Wrap - Up
217(2)
Appendix A Alphabetized List of Tasks 219(2)
Appendix B Toolbars and Buttons 221(3)
Glossary 224(3)
Index 227

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >