Hands on Access 2000

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9781884133749 | 1884133746
Cover: Paperback
Copyright: 11/1/1999

Rent

(Recommended)

$36.20

Term

Due

Price

Semester

Aug 2

$36.20

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy New

Currently Available, Usually Ships in 24-48 Hours

$38.37

Provides useful examples and plain English explanations needed to effectively use Access 2000. Hands-on examples provide the real world grounding you need to make database skills practical and permanent. Softcover. CD-ROM included.

Getting Started with Access

(14)

Access Terminology

(4)

What Is a Database?

(1)

What Is a Table?

(2)

What Is a Query?

(1)

What Is a Form?

(1)

What Is a Record?

(1)

What Is a Field?

(1)

Using The Access Environment

(5)

The Database Window

(1)

Understanding Wizards

(1)

Getting Help

(1)

Looking at Possibilities

(2)

What Can You Do with a Database?

(1)

What Does Access Allow You to Do?

(1)

Exiting Access

(2)

Access in an Hour

(24)

Creating Your Own Database Name

(2)

Choosing a Database

(1)

Where Should You Store Your Database?

(1)

Creating a Table

(12)

Starting the Table Wizard

(1)

Picking a Table Category

(3)

Choosing Types of Information to Include

(3)

Naming Your Table

(1)

Understanding Keys

(1)

Defining a Key

(1)

Finishing Your Table

(2)

Entering Information in Your Table

(3)

Moving Around Your Table

(1)

Data Entry Shortcuts

(1)

Leaving the Datasheet

(1)

Changing Information in Your Table

(4)

Finding Informations

(2)

Replacing Information

(1)

Deleting Records

(1)

Saving Your Information

(2)

Taking a Closer Look

(16)

Modifying Your Table Design

(12)

Adding and Editing Fields

(2)

Changing the Information Type

(1)

Adding Layout Comments

(1)

Understanding Properties

(1)

Caption

(1)

Format

(4)

Input Mask

(1)

Validation Rule and Validation Text

(2)

Editing at a Table Level

(4)

Copying a Table

(1)

Renaming a Table

(1)

Deleting a Table

(2)

Creating Another Database

(18)

A Brand New Database

(2)

Creating a Table From Scratch

(10)

The Design Stage

(1)

A Table Design Form

(1)

Planning the Table Fields

(1)

Picking Data Types

(1)

Determining Field Lengths

(1)

Ordering Your Fields

(1)

The Layout Stage

(5)

Testing Your Layout

(6)

Sorting and Filtering Information

(10)

Sorting Your Data

(5)

Simple Sorting

(2)

Moving Columns

(1)

Complex Sorting

(3)

Filtering Your Data

(5)

Creating a Filter

(2)

Removing a Filter

(1)

Saving a Filter

(3)

Using Queries to Examine Your Data

(21)

Understanding Queries

(2)

Types of Queries

(1)

How Access Stores Queries

(1)

Using the Query Wizards

(11)

Creating a Simple Query

(2)

Creating a Crosstab Query

(5)

Creating a Find Duplicates Query

(3)

Designing Your Own Queries

(8)

The Query Design Toolbar

(2)

Using the QBE Grid

(3)

Setting Properties

101

(2)

Printing Your Table

103

(13)

Printing a Table

103

(2)

Controlling the Printed Page

105

(5)

Setting Printout Margins

106

(1)

Setting Page Specifications

106

(1)

Changing Your Printer

107

(2)

Controlling Printer Properties

109

(1)

Printing Your Layout

110

(3)

Using Print Preview

113

(3)

Creating Simple Reports

116

(15)

What Is a Report?

116

(1)

Creating a Report

117

(6)

Choosing Information to Include

117

(1)

Grouping Information

118

(1)

Sorting Information for Your Report

119

(1)

Specifying Your Report Layout

120

(1)

Wrapping Up Your Report

121

(2)

Using Other Report Wizards

123

(1)

Creating Mailing Labels

124

(7)

Choosing Fonts and Colors

125

(1)

Picking Label Content

125

(3)

Sorting Your Labels

128

(1)

Finishing Your Labels

128

(3)

Creating Custom Forms

131

(22)

Understanding Forms

131

(1)

Creating a Form Using the Form Wizards

132

(6)

Creating a Basic Form

134

(3)

Creating an AutoForm Form

137

(1)

Defining Your Own Forms

138

(15)

Attaching a Data Source

140

(1)

The Form Design Toolbox

140

(2)

Placing Objects on Your Form

142

(1)

Placing a Label Object

142

(2)

Placing Fields on the Form

144

(2)

Placing a Checkbox

146

(2)

Understanding Properties

148

(1)

Changing Object Properties

148

(2)

Changing Form Properties

150

(1)

Saving Your Form

151

(2)

Using Additional Tools

153

(15)

Using the Spell Checker

153

(3)

Spell Checking Your Data

153

(2)

Adding Custom Words

155

(1)

Using AutoCorrect

156

(1)

Adding Entries

156

(1)

Removing Entries

157

(1)

Analyzing a Table

157

(8)

Starting the Analysis

158

(2)

Confirming Table Splitting

160

(1)

Confirming Primary Key Selections

161

(1)

Correcting Typographical Errors

162

(1)

Finishing the Analysis

163

(2)

Improving Database Performance

165

(3)

Using Your Data with Word and Excel

168

(14)

Why Use Other Programs with Access?

168

(1)

Sharing Data with Word

169

(6)

The Scenario

169

(1)

Using the Word Mail Merge Wizard

169

(2)

Loading the Word Document

171

(1)

Inserting Merge Fields

171

(3)

Merging the Document and the Data

174

(1)

What about Updates?

175

(1)

Sharing Data with Excel

175

(7)

Transferring Data to Excel

175

(1)

Linking Information between Access and Excel

176

(3)

What Is Transferred?

179

(1)

What about Updates?

179

(3)

Using Web Features

182

(22)

What Is the Web?

182

(3)

How the Web Works

183

(1)

Web Addressing

184

(1)

Using Hyperlinks

185

(5)

The Hyperlink Data Type

185

(1)

Defining a Hyperlink

186

(3)

Activating a Hyperlink

189

(1)

Editing a Hyperlink

189

(1)

Deleting a Hyperlink

190

(1)

Creating Web Pages

190

(14)

Creating a Static HTML Web Page

191

(3)

Creating Server-Generated HTML Web Pages

194

(1)

Creating Data Access Pages

194

(1)

Using a Page Wizard

194

(6)

Designing Pages from Scratch

200

(2)

Conducting a NetMeeting

202

(2)

Understanding Data Relationships

204

(16)

Understanding Data Relationships

204

(4)

What Type of Relationships Can Exist?

206

(1)

Revisiting Keys

207

(1)

Characteristics of Keys

207

(1)

Types of Keys

207

(1)

Establishing Relationships

208

(12)

Pulling Out Unique Names

209

(3)

Creating the Sales Staff Table

212

(2)

Modifying the Business Customers Table

214

(1)

Establishing Links

215

(2)

Checking Your Link

217

(3)

Creating Complex Reports

220

(15)

Creating a New Report

220

(1)

Understanding the Design Window

221

(3)

Parts of a Report

222

(1)

Report Header and Footer

222

(1)

Page Header and Footer

222

(1)

Detail

223

(1)

Report Properties

223

(1)

Designing Your Report

224

(11)

Setting Up the Detail Section

224

(3)

Grouping Your Data

227

(1)

Setting Up the Page Header

228

(2)

Setting Up the Page Footer

230

(1)

Setting Up the Page

231

(1)

Viewing Your Report

231

(2)

Saving Your Report

233

(2)

Importing and Exporting Information

235

(18)

Using Information from Other Databases

235

(14)

Picking a Source Format

235

(2)

Importing Access Files

237

(1)

Importing Delimited Text Files

237

(6)

Importing Fixed-Width Text Files

243

(1)

Importing Excel Files

244

(4)

Importing Lotus Files

248

(1)

Importing Paradox and dBase Files

248

(1)

Preparing Information for Other Databases

249

(4)

Exporting to Microsoft Access

250

(1)

Exporting to a Text File

250

(3)

Ensuring Data Security

253

(21)

Setting a Database Password

253

(4)

Adding the Password

254

(1)

Using the Password

255

(1)

Removing the Password

256

(1)

Using Database Encryption

257

(1)

Working with Users and Groups

258

(3)

Understanding Workgroup Information Files

259

(1)

Understanding Permissions

259

(2)

Using the User-Level Security Wizard

261

(6)

Opening a Secured Database

267

(1)

Managing Security Accounts

268

(6)

Creating a New Workgroup Information File

268

(2)

Adding an Account

270

(1)

Removing an Account

271

(1)

Changing Account Permissions

271

(1)

Printing a Security Overview

272

(2)

Using OLE

274

(14)

What Is OLE?

274

(2)

What Are Objects?

275

(1)

Types of Objects Available

275

(1)

Putting Objects in Your Table

276

(8)

Inserting an Existing Object

277

(1)

Inserting a New Object

278

(2)

Creating an Editable Link

280

(1)

Changing Object Icons

281

(3)

Modifying Links

284

(2)

Editable Links

284

(1)

Active Links

285

(1)

No Links

286

(1)

Editing Objects

286

(2)

Creating and Using Macros

288

(20)

What Are Macros?

288

(2)

Creating Macros

290

(7)

Understanding the Macro Window

291

(1)

A Macro to Automate Adding Records

292

(4)

Saving Your Macro

296

(1)

Conditional Macros

297

(1)

Running Macros

297

(5)

Adding a Macro to a Form

302

(4)

Editing Your Macros

306

(2)

Working with Dialog Boxes and Menus

308

(16)

Adding Dialog Boxes

308

(5)

Displaying Messages

308

(3)

Your Forms as Pop-Up Windows

311

(2)

Adding Menus

313

(1)

Developing Switchboard Menus

314

(2)

Add Records

315

(1)

Review Records

315

(1)

Print Records

315

(1)

Exit

316

(1)

Adding Custom Menus

316

(8)

Understanding How to Customize Menus

316

(3)

Restoring Menus to Their Default

319

(1)

Creating a Custom Menu System

319

(2)

Using Custom Menus

321

(3)

Using Visual Basic for Applications

324

(27)

What Is Visual Basic for Applications?

324

(2)

Parts of a Program

326

(10)

Understanding Statements

326

(1)

Understanding Variables

327

(1)

Data Types

327

(2)

Declaring Variables

329

(1)

Variables Arrays

330

(1)

Assigning Values to Variables

331

(1)

Understanding Operators

331

(1)

Understanding Functions

332

(1)

Referring to Database Objects

333

(1)

Properties and Methods

334

(1)

Addressing Objects and Collections

335

(1)

Object Variables

336

(1)

Creating a VBA Module

336

(8)

What Is the VBA Editor?

337

(1)

Creating a New Procedure

338

(2)

Specifying Parameters

340

(1)

Specifying Variables

340

(1)

Stepping Through the Records

341

(1)

Wrapping It Up

342

(1)

Saving Your Module

343

(1)

Testing Your Procedure

344

(3)

Using the Immediate Window

344

(1)

Using Debug Print

345

(1)

Setting Breakpoints

346

(1)

Attaching Your Procedure to a Form

347

(4)

Putting It All Together

351

(13)

Database Design

351

(1)

The CD Table

352

(8)

The Song Table

352

(1)

The Groups Table

353

(1)

Establishing Relationships

353

(1)

Forms in the Database

354

(1)

Add Music

355

(1)

The Subform

356

(1)

Adding Groups

357

(1)

Review Music

357

(1)

Print CD List

358

(1)

Exit

358

(1)

Queries in the Database

359

(1)

Reports in the Database

360

(1)

VBA Procedures

360

(3)

Procedures in the Track List Form

360

(1)

Procedures in the Music Input Form

361

(2)

Improvements You Could Make

363

(1)

Index

364

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Hands on Access 2000

Summary

Table of Contents

Supplemental Materials