Quick Course in Microsoft Access 2002: Fast-Track Training Books for Busy People

by Online Training Solutions Inc.

ISBN13: 9781582780702

ISBN10: 1582780706

Format: Paperback

Pub. Date: 2002-03-01

Publisher(s): Online Training Solutions Inc

Availability: This title is currently not available.

Other versions by this Author

This Item Qualifies for Free Shipping!*

*Excludes marketplace orders.

List Price: ~~$17.95~~

Rent Book

Select for Price

Add to Cart

There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

Learn how to build powerful relational databases!Quick Course in Microsoft Access 2002 provides clear, concise instruction and hands-on practice to enable you to start using this best-selling database program. Ideal for beginning to intermediate users, this course teaches the basics and then helps you build proficiency.

Introduction

PART ONE: LEARNING THE BASICS

Getting Started

Understanding Database Concepts

(2)

Working with Databases

(16)

Starting Access

(1)

Opening an Existing Database

(2)

Opening an Existing Table

(2)

Moving Around a Table

(1)

Moving Fields

(2)

Sorting Records

(1)

Opening an Existing Form

(2)

Opening an Existing Query

(4)

Opening an Existing Report

(2)

Closing an Open Database

(1)

Giving Commands

(3)

Using Menu Commands

(1)

Using the Toolbars

(1)

Using the Task Pane

(1)

Getting Help

(4)

Using the Office Assistant

(1)

Asking Questions

(1)

Using the Help Index

(2)

Ending an Access Session

(1)

Creating and Editing Tables

(36)

Creating a New Database

(2)

Creating a Database with a Wizard

(2)

Creating Tables

(7)

Creating a Table with the Table Wizard

(3)

Creating a Table in Design View

(1)

Creating a Table with the Lookup Wizard

(2)

Creating a Table by Entering Data

(1)

Adding and Updating Records

(5)

Creating a Record

(2)

Duplicating a Field

(1)

Copying and Pasting a Field

(1)

Undoing an Edit

(1)

Adding a Record

(1)

Deleting a Record

(1)

Changing a Table's Appearance

(3)

Sizing Windows, Columns, and Rows

(1)

Changing the Width of Multiple Fields

(1)

Restoring Original Row Height

(1)

Setting Options

(1)

Changing the Font

(1)

Changing a Table's Structure

(5)

Exploring Data Types

(3)

Setting the Field Size

(1)

Assigning a Caption

(1)

Setting a Default Value

(1)

Requiring an Entry

(1)

Exploring Other Properties

(1)

Controlling the Appearance of Data

(3)

Creating a Custom Number Format

(2)

Creating a Custom Text Format

(1)

Restricting Data Entry

(6)

Specifying an Input Mask

(1)

Using the Input Mask Wizard

(2)

Creating an Input Mask for Text

(1)

Creating a Phone Number Input Mask

(1)

Testing Your Input Masks

(1)

Printing Tables

(3)

Checking Page Layout

(1)

Adjusting Page Layout

(1)

Choosing Print Options

(2)

Creating and Customizing Forms and Data Access Pages

(22)

Creating Forms

(5)

Creating a Form Using Auto Form

(1)

Creating a Form with the Form Wizard

(4)

Customizing Forms

(9)

Exploring the Form Window

(1)

Moving Controls and Labels

(1)

Sizing Controls and Labels

(1)

Making Information Stand Out

(1)

Changing Formats

(1)

Deleting and Adding Controls

(1)

Adding a Title

(2)

Setting the Input Order

(1)

Entering Records

(1)

Creating and Modifying Data Access Pages

(6)

Converting a Table to a Data Access Page

(1)

Viewing a Page in Access

(1)

Protecting Fields on a Page

(1)

Removing Navigation Buttons

(1)

Viewing a Page in Internet Explorer

(1)

Sorting and Filtering in a Data Access Page

(1)

Creating Simple Queries and Reports

(32)

Using Find and Filters

(1)

Finding a Field Value

(1)

Finding Part of a Field Value

(1)

Filtering by Selection

(1)

Creating Queries

(8)

Selecting Specific Fields

(2)

Selecting Specific Records

(2)

Using Wildcards

(2)

Editing Query Datasheets

(1)

Sorting Using Queries

(1)

Using Mathematical and Logical Operators

(4)

Using Mathematical Operators

100

(1)

Using the AND Operator

100

(1)

Using the OR Operator

101

(1)

Using the NOT and NULL Operators

102

(1)

Creating and Printing Reports

103

(5)

Creating an Auto Report

103

(1)

Creating a Report with the Report Wizard

104

(3)

Printing a Report

107

(1)

Modifying Reports

108

(6)

Deleting Report Controls

108

(2)

Aligning Report Controls

110

(1)

Improving the Report's Appearance

111

(1)

Adding Lines to a Report

112

(2)

Creating and Printing Mailing Labels

114

(6)

Using the Label Wizard

114

(6)

PART TWO: BUILDING PROFICIENCY

Designing Effective Databases

120

(30)

Applying Database Design Rules

122

(6)

Rule 1: Keeping Information Compartmentalized

123

(1)

Rule 2: Separating Information Using Determinants

123

(2)

Rule 3: Moving Partial Dependencies to a Linked Table

125

(3)

Establishing Relationships

128

(1)

Creating a One-to-Many Relationship

128

(16)

Testing Referential Integrity

131

(1)

Creating a Many-to-Many Relationship

132

(3)

Creating a Relationship with the Lookup Wizard

135

(3)

Making Entries in a Related Lookup Table

138

(2)

Viewing and Editing Related Data

140

(1)

Using Sub-Sub datasheets

141

(3)

Reducing Database Errors

144

(4)

Using Formulas as Default Values

144

(2)

Using Validation Rules

146

(2)

Protecting Data

148

(2)

Locking Records

148

(2)

Creating Sophisticated Forms and Queries

150

(28)

Creating Flat Multi-Table Forms

152

(3)

Creating a Multi-Table Form with a Wizard

152

(1)

Protecting Data in a Multi-Table Form

153

(2)

Creating Hierarchical Multi-Table Forms

155

(5)

Creating a Subform

155

(1)

Adding a Subform to a Form

156

(4)

Adding Controls to Forms

160

(4)

Adding a Command Button

160

(3)

Adding a Date Control

163

(1)

Using Queries and Forms Together

164

(3)

Creating a Parameter Query

164

(1)

Creating a Form Based on a Parameter Query

165

(2)

Using Formulas in Queries and Forms

167

(11)

Creating a Calculated Query

167

(1)

Adding Unbound Controls to a Form

168

(2)

Building an Expression

170

(3)

Using the Total Row in Queries

173

(1)

Using an Expression to Group Results in a Query

174

(1)

Using a Chart in a Form

175

(3)

Managing and Maintaining Your Database

178

(38)

Using Switchboards

180

(5)

Creating a Simple Switchboard

180

(1)

Displaying a Switchboard

181

(1)

Customizing a Switchboard

182

(1)

Creating a Second-Level Switchboard

183

(1)

Linking and Testing Switchboards

184

(1)

Adding a Return Button

185

(1)

Working with Multiple Records

185

(10)

Converting Query Results to a Table

185

(3)

Using a Query to Update Records

188

(1)

Moving Records with a Query

189

(3)

Deleting Records with a Query

192

(3)

Securing Databases Accessed by Multiple Users

195

(12)

Protecting a Database with a Password

195

(1)

Setting Security for Multiple Users

196

(1)

Creating a Secure Workgroup

197

(2)

Creating User Accounts

199

(2)

Creating a Secure Database

201

(3)

Creating a Group and Adding Users

204

(1)

Setting Group Permissions

204

(2)

Removing Security Settings

206

(1)

Sharing Information

207

(7)

Exporting Data to Excel

208

(1)

Exporting Data as HTML

209

(1)

Importing from Another Access Database

210

(1)

Importing Data from Excel

211

(3)

Performing Preventive Maintenance

214

(2)

Compacting and Repairing a Database

214

(2)

Index

216