Access 97/2000 Database Development Outside Vba

by Saksena, Devendra; Berkowitz, Neal

ISBN13: 9781556228223

ISBN10: 1556228228

Format: Paperback

Pub. Date: 2001-05-01

Publisher(s): Jones & Bartlett Pub

Other versions by this Author

List Price: ~~$39.95~~

Rent Textbook

Select for Price

Add to Cart

There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $63.26

Summary

Emphasizes how to develop simple yet powerful databases without requiring the writing of Visual Basic for Applications code.

Introduction	p. xvii
Introducing Access	p. 1
Why Access?	p. 1
What is Access?	p. 2
How is Access Useful?	p. 4
How to Use This Book	p. 5
Hardware and Software Issues	p. 5
Before We Start	p. 6
Tables	p. 7
Beginning Your Work	p. 7
Fields	p. 12
Some Important Topics	p. 23
Table Properties	p. 30
Other Ways of Creating Tables	p. 32
Publishing Your Table on the Web	p. 38
Naming Conventions	p. 40
Summary	p. 41
Exercises	p. 42
Queries	p. 45
Select Queries	p. 45
Criteria	p. 49
Calculated Fields	p. 52
The Expression Builder	p. 54
Some Useful Functions	p. 55
Joining Tables and Queries	p. 58
Multi-table Queries	p. 62
Sorting	p. 64
Query Wizards	p. 66
Structured Query Language	p. 70
Query Properties	p. 76
Field Properties	p. 77
Tips and Tricks	p. 77
Summary	p. 78
Exercises	p. 79
Aggregate Queries	p. 81
Aggregate or Totals Queries	p. 81
Domain Aggregate Functions	p. 85
Setting Criteria in Totals Queries	p. 87
Dealing with Aggregate Expressions in Totals Queries	p. 90
Using the Simple Query Wizard for Totals Queries	p. 91
Parameter Queries	p. 92
Action Queries	p. 94
Crosstab Queries	p. 98
SQL-Specific Queries	p. 100
Practical Issues	p. 102
Designing Queries for Actual Applications	p. 104
Optimizing a Query	p. 106
Summary	p. 107
Exercises	p. 108
Forms	p. 111
Introduction	p. 111
Understanding Forms	p. 112
Form Properties	p. 115
Format Properties	p. 116
Designing Forms	p. 122
Improving the Appearance of Your Form	p. 127
Modifying Form Properties Through the Property Sheet	p. 129
Form Controls	p. 130
Subforms	p. 138
More About Form Design	p. 141
Summary	p. 150
Exercises	p. 150
Reports	p. 151
Introduction	p. 151
The Report in Design View	p. 153
Report and Report Section Properties	p. 154
The Report Design View Explored	p. 156
Report Controls	p. 160
Subreports	p. 161
Enhancing Your Reports	p. 163
Reports Created by the Wizard and Crosstab Reports	p. 169
Summary	p. 170
Exercises	p. 170
Macros and Code	p. 173
Introduction	p. 173
More about Macros	p. 175
Basics of Visual Basic for Applications	p. 182
Modules, Functions, and Subs Defined	p. 188
Modules Dissected	p. 189
Alternatives to Writing Code	p. 195
Understanding the Writing of Simple Code	p. 197
DAO, DLL, and ADO--A Brief Overview	p. 201
Summary	p. 205
Exercises	p. 205
Errors	p. 209
Introduction	p. 209
Errors--Numbered and Defined	p. 211
Handling Run-time Errors	p. 215
Resuming Execution after Handling the Error	p. 216
Handling Run-time Errors--Error Handling Procedures	p. 218
Making Your Code Bulletproof	p. 220
Strategies to Avoid Errors	p. 227
Tips for Debugging	p. 228
Summary	p. 229
Form Events	p. 231
Introduction	p. 231
Control Events and Their Uses	p. 235
The Order of Form and Control Events	p. 237
Designing Advanced Forms	p. 240
List Boxes and Combo Boxes Revisited	p. 246
Some Other Useful Form and Control Properties	p. 247
Issues in Designing Forms for Different Uses	p. 250
Summary	p. 254
Exercises	p. 255
Reports--Part 2	p. 257
Introduction	p. 257
Section Events	p. 258
Designing a Form that Supplies Criteria to a Report	p. 260
Designing Advanced Reports	p. 263
Reports and the Internet	p. 275
Summary	p. 277
Exercises	p. 277
Data Access Pages	p. 279
Introduction	p. 279
Studying Data Access Pages	p. 280
The Pages Toolbox	p. 285
Working with Pages	p. 295
Summary	p. 302
Security Issues	p. 305
Introduction	p. 305
Protecting Data	p. 307
Security Jargon	p. 312
Setting Security	p. 313
Guidelines on Granting Permissions	p. 320
Securing Your Database	p. 321
The Security Wizard	p. 323
Other Important Topics	p. 324
Disabling Security	p. 331
Summary	p. 331
Designing a Database	p. 333
Introduction	p. 333
Security	p. 334
Designing Tables	p. 337
Designing Queries, Forms, and Reports	p. 341
Putting It Together	p. 350
Summary	p. 357
Exercises	p. 357
Distributing Your Database	p. 359
Applying Finishing Touches	p. 359
Tuning Your Database	p. 371
Summary	p. 373
Exercises	p. 374
Some Final Words of Advice	p. 374
The Leszynski Naming Convention	p. 375
Access and Jet Errors Table	p. 377
Circle, PSet, and Line Methods	p. 463
Introduction	p. 463
The Circle Method	p. 464
The PSet Method	p. 466
The Line Method	p. 468
Command Button Tasks	p. 471
PATIENTS Database Documentation	p. 473
Introduction	p. 473
PATIENTS Explained	p. 474
Using PATIENTS	p. 475
General	p. 476
Command-Line Options	p. 477
Introduction	p. 477
Startup Command-Line Options	p. 477
Opening an Access Application with Command- Line Options from the Start Menu	p. 479
Opening an Access Application with Command- Line Options from a Shortcut	p. 479
Data Access Page Security	p. 481
Protecting a Data Access Page	p. 481
Index	p. 485
Table of Contents provided by Syndetics. All Rights Reserved.

Kids

Men

Unisex

Women

For You

For Your Car

For Your Home

For Your Pet

For Your Tech

Holiday

Home Decor

Mascot

Office Decor

Spirit

Stationary

Diploma Frames

Graduation Gear

Graduation Gifts

For Your Office

Clothing

Access 97/2000 Database Development Outside Vba

Rent Textbook

New Textbook

Used Textbook

eTextbook

Summary

Table of Contents

Access 97/2000 Database Development Outside Vba

Rent Textbook

New Textbook

Used Textbook

eTextbook

How Marketplace Works:

Summary

Table of Contents

Digital License