Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

جستجو بر اساس ... همه عنوان پدیدآور موضوع یادداشت تمام متن
اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا
➟
جستجو در لغت نامه
بیشتر
کتابخانه شخصی پرسش از کتابدار ارسال منبع

Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] - نسخه متنی

Alison Balter

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
میخواهم بخوانم
درحال خواندن
خوانده شده
ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
➟
جستجو در لغت نامه
بیشتر
لیست موضوعات

Sitemap Main Page

Table of content

Copyright

About the Author

Acknowledgments

Tell Us What You Think!

Introduction

Conventions Used In This Book

Part I: The Basics of Access Development

Chapter 1. Access As a Development Tool

Why This Chapter Is Important

What Types of Applications Can You Develop in Access?

Access As a Scalable Product

What Exactly Is a Database?

Getting to Know the Database Objects

Object Naming Conventions

Hardware Requirements

How Do I Get Started Developing an Access Application?

What's New in Access 2002 and 2003?

Practical Examples: The Application Design for a Computer Consulting Firm

Summary

Chapter 2. What Every Developer Needs to Know About Databases and Tables

Why This Chapter Is Important

Creating a New Database

Building a New Table

Selecting the Appropriate Field Type for Your Data

Working with Field Properties

The All-Important Primary Key

Working with the Lookup Feature

Working with Table Properties

Using Indexes to Improve Performance

Access Tables and the Internet

Adding Smart Tags to Your Tables

Creating a Pivot Table or Pivot Chart from a Table

Viewing Object Dependencies

Database Specifications and Limitations

Table Specifications and Limitations

Practical Examples: Designing the Tables Needed for a Computer Consulting Firm's Time and Billing Application

Summary

Chapter 3. Relationships: Your Key to Data Integrity

Why This Chapter Is Important

Introduction to Relational Database Design

Establishing Relationships in Access

Establishing Referential Integrity

Looking at the Benefits of Relationships

Examining Indexes and Relationships

Practical Examples: Establishing the Relationships Between the Tables Included in the Time and Billing Database

Summary

Chapter 4. What Every Developer Needs to Know About Query Basics

Why This Chapter Is Important

What Is a Query, and When Should You Use One?

Everything You Need to Know About Query Basics

Ordering Your Query Result

Refining Your Query with Criteria

Working with Dates in Criteria

Understanding How You Can Update Query Results

Building Queries Based on Multiple Tables

Creating Calculated Fields

Getting Help from the Expression Builder

Summarizing Data with 'Totals' Queries

Excluding Fields from the Output

'Null's and Query Results

Refining Your Queries with Field, Field List, and Query Properties

Building Parameter Queries When You Don't Know the Criteria at Design Time

Building Parameter Queries When You Don't Know the Criteria at Design Time

Adding Smart Tags to Your Queries

Creating a Pivot Table or Pivot Chart from a Query

Query Specifications and Limitations

Practical Examples: Building Queries Needed by the Time and Billing Application for a Computer Consulting Firm

Summary

Chapter 5. What Every Developer Needs to Know About Forms

Why This Chapter Is Important

Uses of Forms

Anatomy of a Form

Creating a New Form

Working with the Form Design Window

Selecting the Correct Control for the Job

Control Morphing

Conditional Formatting

What Form Properties Are Available, and Why Should You Use Them?

What Control Properties Are Available, and Why Should You Use Them?

Bound, Unbound, and Calculated Controls

Using Expressions to Enhance Your Forms

The Command Button Wizards: Programming Without Typing

Building Forms Based on More Than One Table

Basing Forms on Queries: The Why and How

Access Forms and the Internet

Adding Smart Tags to Your Forms

Creating a Pivot Table or Pivot Chart from a Form

Form Specifications and Limitations

Practical Examples: Designing Forms for Your Application

Summary

Chapter 6. What Every Developer Needs to Know About Reports

Why This Chapter Is Important

Types of Reports Available

Anatomy of a Report

Creating a New Report

Working with the Report Design Window

Selecting the Correct Control for the Job

What Report Properties Are Available and Why Use Them?

What Control Properties Are Available and Why Use Them?

Inserting Page Breaks

Unbound, Bound, and Calculated Controls

Using Expressions to Enhance Your Reports

Building Reports Based on More Than One Table

Working with Sorting and Grouping

Improving Performance and Reusability by Basing Reports on Stored Queries or Embedded SQL Statements

Access Reports and the Internet

Report Specifications and Limitations

Practical Examples: Building Reports Needed for Your Application

Summary

Chapter 7. VBA: An Introduction

Why This Chapter Is Important

VBA Explained

What Are Access Class Modules, Standard Modules, Form Modules, and Report Modules?

Working with Variables

Adding Comments to Your Code

Using the Line Continuation Character

Using the VBA Control Structures

Passing Parameters and Returning Values

Passing Parameters and Returning Values

Executing Procedures from the Module Window

The 'DoCmd' Object: Performing Macro Actions

Working with Built-In Functions

Working with Constants

Tools for Working in the Visual Basic Editor

Customizing the VBE

Practical Examples: Event Routines, User-Defined Functions, and Subroutines

Summary

Chapter 8. Objects, Properties, Methods, and Events Explained

Why This Chapter Is Important

Understanding Objects, Properties, Events, and Methods

Using the Object Browser to Learn About Access's Objects

Referring to Objects

Properties and Methods Made Easy

Declaring and Assigning Object Variables

Understanding the Differences Between Objects and Collections

Passing Objects to Subroutines and Functions

Determining the Type of a Control

Special Properties That Refer to Objects

Understanding Access's Object Model

Properties Introduced with Access 2002 and Access 2003

Practical Examples: Working with Objects

Summary

Chapter 9. Advanced Form Techniques

Why This Chapter Is Important

What Are the Form Events, and When Do You Use Them?

What Are the Section and Control Events, and When Do You Use Them?

Referring to 'Me'

What Types of Forms Can I Create, and When Are They Appropriate?

Using Built-In Dialog Boxes

Adding Custom Menus, Toolbars, and Shortcut Menus to Your Forms

Taking Advantage of Built-In, Form-Filtering Features

Including Objects from Other Applications: Linking Versus Embedding

'OpenArgs'

Switching a Form's 'RecordSource'

Power Combo Box and List Box Techniques

Power Subform Techniques

Automatic Error Checking

Viewing Object Dependencies

AutoCorrect Options

Propagating Field Properties

Windows XP Theme Support

Synchronizing a Form with Its Underlying Recordset

Creating 'Custom' Properties and Methods

Practical Examples: Applying Advanced Techniques to Your Application

Summary

Chapter 10. Advanced Report Techniques

Why This Chapter Is Important

Events Available for Reports, and When to Use Them

Order of Events for Reports

Events Available for Report Sections, and When to Use Them

Programmatically Manipulating Report Sections

Special Report Properties

Controlling the Printer

Viewing Object Dependencies

Automatic Error Checking

Propagating Field Properties

Practical Applications of Report Events and Properties

Practical Examples: Practicing What You Learned

Summary

Chapter 11. Advanced Query Techniques

Why This Chapter Is Important

'Action' Queries

Special Query Properties

Optimizing Queries

'Crosstab' Queries

Outer Joins

Self Joins

Understanding SQL

'Union' Queries

'Pass-Through' Queries

The Propagation of 'Null's and Query Results

Subqueries

Using SQL to Update Data

Using SQL for Data Definition

Using the Result of a Function as the Criteria for a Query

Passing 'Parameter' Query Values from a Form

Passing 'Parameter' Query Values from a Form

Jet 4.0 ANSI-92 Extensions

Practical Examples: Applying These Techniques in Your Application

Summary

Chapter 12. Advanced VBA Techniques

Why This Chapter Is Important

What Are User-Defined Types, and Why Would You Use Them?

Working with Constants

Working with Arrays

Advanced Function Techniques

Working with 'Empty' and 'Null'

Creating and Working with Custom Collections

Low-Level File Handling

Understanding and Effectively Using Compilation Options

Importing and Exporting Code Modules

Working with Project Properties

Practical Examples: Putting Advanced Techniques to Use

Summary

Chapter 13. Exploiting the Power of Class Modules

Why This Chapter Is Important

Object OrientationAn Introduction

Creating and Using a Class Module

Setting Values with 'Property Set'

Creating Multiple Class Instances

The 'Initialize' and 'Terminate' Events

Working with Enumerated Types

Building Hierarchies of Classes

Adding a 'Parent' Property to Classes

The 'Implements' Keyword

Working with Custom Collections

Adding Your Own Events

Practical Examples: Class Modules

Summary

Chapter 14. What Are ActiveX Data Objects and Data Access Objects, and Why Are They Important?

Why This Chapter Is Important

Using ADO Versus DAO

Examining the ADO Model

Understanding ADO Recordset Types

Working with ADO Recordset Properties and Methods

Modifying Table Data Using ADO Code

Creating and Modifying Database Objects Using ADO Code

Examining the DAO Model

Getting to Know 'DBEngine'

Using 'CurrentDB()'

Understanding DAO Recordset Types

Selecting Among the Available Types of DAO Recordset Objects

Working with DAO 'Recordset' Properties and Methods

Modifying Table Data Using DAO Code

Creating and Modifying Database Objects Using DAO Code

Using the DAO 'Containers' Collection

Practical Examples: Applying These Techniques to Your Application

Summary

Part II: What to Do When Things Don't Go as Planned

Chapter 15. Debugging: Your Key to Successful Development

Why This Chapter Is Important

Avoiding Bugs

Harnessing the Power of the Immediate Window

Invoking the Debugger

Using Breakpoints to Troubleshoot

Stepping Through Code

Setting the Next Statement to Execute

Using the Call Stack Window

Working with the Locals Window

Working with Watch Expressions

Continuing Execution After a Runtime Error

Looking At Gotchas with the Immediate Window

Using Assertions

Debugging Tips

Practical Examples: Debugging Real Applications

Summary

Chapter 16. Error Handling: Preparing for the Inevitable

Why This Chapter Is Important

Implementing Error Handling

Using 'On Error' Statements

Using 'Resume' Statements

Clearing an Error

Examining the Cascading Error Effect

Using the 'Err' Object

Raising an Error

Using the 'Errors' Collection

Creating a Generic Error Handler

Preventing Your Own Error Handling from Being Invoked

Creating a Call Stack

Building a Custom Error Handler Class

Working with Error Events

Creating a List of Error Codes and Descriptions

Practical Examples: Incorporating Error Handling

Summary

Chapter 17. Optimizing Your Application

Why This Chapter Is Important

Introducing Optimization

Modifying Hardware and Software Configurations

Features Built Into Jet 3.5

Understanding What Jet 4.0 Does to Improve Performance

Letting the Performance Analyzer Determine Problem Areas

Designing Tables to Optimize Performance

Optimizing the Performance of Your Queries

Making Coding Changes to Improve Performance

Designing Forms and Reports to Improve Performance

Practical Examples: Improving the Performance of Your Applications

Summary

Part III: Developing Multiuser and Enterprise Applications

Chapter 18. A Strategy to Developing Access Applications

Why This Chapter Is Important

Splitting Databases into Tables and Other Objects

Basing Forms and Reports on Queries or Embedded SQL Statements

Understanding the Access Runtime Engine

Using an EXE Versus Access Database: What It Means to You

Understanding the Importance of Securing Your Database

Using Access as a Front End

Practical Examples: Applying the Strategy to the Computer Consulting Firm Application

Summary

Chapter 19. Using External Data

Why This Chapter Is Important

Importing, Linking, and Opening Files: When and Why

Importing External Data

Creating a Link to External Data

Opening an External Table

Understanding Windows Registry Settings

Using the 'Jet OLEDB:Link Provider' String

Working with Passwords

Refreshing and Removing Links

Sharing Data with SharePoint Team Services

Looking at Special Considerations

Troubleshooting

Looking at Performance Considerations and Links

Working with HTML Documents

Practical Examples: Working with External Data from Within Your Application

Summary

Chapter 20. Developing Multiuser and Enterprise Applications

Why This Chapter Is Important

Designing Your Application with Multiuser Issues in Mind

Understanding Access's Locking Mechanisms

Understanding the Client/Server Model

Deciding Whether to Use the Client/Server Model

The Roles Access Plays in the Application Design Model

Learning the Client/Server Buzzwords

Upsizing: What to Worry About

Proactively Preparing for Upsizing

An Introduction to Transaction Processing

Understanding the Benefits of Transaction Processing

Modifying the Default Behavior of Transaction Processing

Implementing Explicit Transaction Processing

Introduction to Replication

Uses of Replication

Understanding When Replication Isn't Appropriate

Understanding the Implementation of Replication

Practical Examples: Getting Your Application Ready for an Enterprise Environment

Summary

Part IV: Black-Belt Programming

Chapter 21. Using ActiveX Controls

Why This Chapter Is Important

Incorporating ActiveX Controls in Access 2003

Setting Properties of an ActiveX Control at Design Time

Coding Events of an ActiveX Control

Using the Calendar Control

Using the UpDown Control

Using the StatusBar Control

Using the Common Dialog Control

Using the Rich Textbox Control

Using the TabStrip Control

Using the ImageList Control

Licensing and Distribution Issues

Practical Examples: Implementing ActiveX Controls

Summary

Chapter 22. Automation: Communicating with Other Applications

Why This Chapter Is Important

Defining Some Automation Terms

Declaring an Object Variable to Reference Your Application

Creating an Automation Object

Manipulating an Automation Object

Early Binding Versus Late Binding

Controlling Excel from Access

Closing an Excel Automation Object

Creating a Graph from Access

Controlling Word from Access

Controlling PowerPoint from Access

Automating Outlook from Access

Controlling Access from Other Applications

Practical Examples: Using Automation to Extend the Functionality of Your Applications

Summary

Chapter 23. Exploiting the Power of the Windows API

Why This Chapter Is Important

Declaring an External Function to the Compiler

Working with Constants and Types

Calling DLL Functions: Important Issues

Using API Functions

Practical Examples: Using Windows API Functions in Your Applications

Summary

Chapter 24. Creating Your Own Libraries

Why This Chapter Is Important

Preparing a Database to Be a Library

Creating a Reference

Debugging a Library Database

Securing an Access Library

Practical Examples: Building a Library for Your Application

Summary

Chapter 25. Using Builders, Wizards, and Menu Add-Ins

Why This Chapter Is Important

Using Builders

Using Wizards

Using Menu Add-Ins

Practical Examples: Designing Your Own Add-Ins

Summary

Chapter 26. An Introduction to Access and the Internet/Intranet

Why This Chapter Is Important

Saving Database Objects as HTML

Linking to HTML Files

Importing HTML Files

Understanding Data Access Pages

Creating Data Access Pages

Modifying Important Properties of a Data Access Page

Modifying the Record Navigation Control Properties

Creating Grouped Data Access Pages

Augmenting Data Access Pages with VBScript

Practical Examples

Summary

Part V: Adding Polish to Your Application

Chapter 27. Database Security Made Easy

Why This Chapter Is Important

Implementing Share-Level Security: Establishing a Database Password

Encrypting a Database

Establishing User-Level Security

Securing VBA Code with a Password

Providing an Additional Level of Security: Creating an MDE

Securing a Database Without Requiring Users to Log On

Looking at Special Issues

Practical Examples: Securing a Copy of the Northwind Database

Summary

Chapter 28. Advanced Security Techniques

Why This Chapter Is Important

Using Code to Maintain Groups

Using Code to Maintain Users

Listing All Groups and Users

Working with Passwords

Assigning and Revoking Permissions to Objects Using Code

Encrypting a Database Using Code

Accomplishing Field-Level Security Using Queries

Prohibiting Users and Groups from Creating Objects

Accomplishing Prohibited Tasks by Logging On as a Different User

Securing Client/Server Applications

Security and Replication

Implementing Security with SQL

DAO and Security

Choosing Between ADOX, SQL, and DAO

Practical Examples: Applying Advanced Techniques to Your Application

Summary

Chapter 29. Documenting Your Application

Why This Chapter Is Important

Preparing Your Application to Be Self-Documenting

Using the Database Documenter

The Object Dependency Feature

Writing Code to Create Your Own Documentation

Practical Examples: Applying What You Learned

Summary

Chapter 30. Maintaining Your Application

Why This Chapter Is Important

Compacting Your Database

Backing Up Your Database

Converting an Access Database

Detecting Broken References

Practical Examples: Maintaining Your Application

Summary

Chapter 31. Third-Party Tools That Can Help You Get Your Job Done Effectively

Why This Chapter Is Important

Total Visual CodeTools

Total Access Analyzer

Total Access Emailer

Total Visual Agent

Total Access Startup

Total Access Components

Total Access Memo

Total Access Statistics

Total Access Detective

Total Visual SourceBook

Total Access Speller

Total Access Admin

xplorer

Component Toolbox OCX

chedule

IM Professional

Practical Examples: Using Third-Party Tools with Your Applications

Summary

Chapter 32. Distributing Your Application

Why This Chapter Is Important

Introducing the Packaging Wizard

Loading the Packaging Wizard Add-In

Distributing Your Application to Run with a Full Copy of Access

Using Full Versions Versus Runtime Versions of Access

Preparing Your Database for Use with the Access Runtime Version

Looking at Other Issues

Practical Examples

Summary

Part VI: Appendixes

Appendix A. Table Structures

The 'tblClients' Table

The 'tblClientAddresses' Table

The 'tblAddressTypes' Table

The 'tblClientPhones' Table

The 'tblPhoneTypes' Table

The 'tblCorrespondence' Table

The 'tblCorrespondenceTypes' Table

The 'tblTerms' Table

The 'tblContactTypes' Table

The 'tblCompanyInfo' Table

The 'tblEmployees' Table

The 'tblErrorLog' Table

The 'tblErrors' Table

The 'tblExpenseCodes' Tables

The 'tblPaymentMethods' Table

The 'tblPayments' Table

The 'tblProjects' Table

The 'tblTimeCardExpenses' Table

The 'tblTimeCardHours' Table

The 'tblTimeCards' Table

The 'tblWorkCodes' Table

Appendix B. Naming Conventions

License Agreement

What's on the CD-ROM

Windows Installation Instructions

Index

Index SYMBOL

Index A

Index B

Index C

Index D

Index E

Index F

Index G

Index H

Index I

Index J

Index K

Index L

Index M

Index N

Index O

Index P

Index Q

Index R

Index S

Index T

Index U

Index V

Index W

Index X

Index Y

Index Z
توضیحات
افزودن یادداشت جدید

[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
[Y]
[Z]

Packaging Wizard
2nd
3rd
4th

applications

adding custom menus/toolbars
2nd
3rd

creating for runtime version
2nd

debugging
2nd
3rd

distributing as MDE files

distribution tests
2nd
3rd

error-handling

security features

startup options
2nd
3rd
4th
5th

supplying information

built-in toolbars

non-supported

deploying the application
2nd

disabled keys
2nd

Hidden Database window

Hidden Design view

launching
2nd

script names, specifying

Start Menu Items, selecting

unavailable menu items

Packaing Wizard

applications

custom help additions

Page Break tool

Page event

reports
2nd

Page Footer Format event

reports

Page Footer property

reports

Page Footers

reports

Page Header Format event

reports
2nd

Page Header property

reports

Page Headers

reports

page headers

reports

printing first and last page entries
2nd
3rd

Page locking

Page Wizard

data access pages, creating
2nd
3rd

grouped data access pages

creating
2nd
3rd

pal prefix

Palette Source property

forms

parameter arrays
2nd

Parameter Info feature

modules

Parameter object

Data Access Object model
2nd

parameter queries
2nd
3rd

Parameter queries

building
2nd
3rd
4th

Detail reports

parameter queries (ADO)
2nd

parameter query values

passing from forms
2nd
3rd

parameters
[See also arguments]2nd

Crosstab queries

CursorType

ADO recordset types
2nd
3rd
4th

functions
2nd

LinkToDBase subroutine

LockType

ADO recordset types
2nd

named

named parameters
2nd

optional parameters
2nd
3rd

Options

ADO recordset types
2nd

passing
2nd

by reference
2nd

passing arrays as
2nd

passing by reference vs. passing by value
2nd
3rd

string parameters

passing
2nd

subroutines
2nd

Parameters dialog box

Parent property

classes

adding to
2nd

pass-through queries

creating
2nd

passing objects to subroutines and functions
2nd

passing parameters
2nd

by reference vs. by value
2nd
3rd

passing string parameters
2nd

Password Required dialog box

passwords
2nd
3rd
4th

assigning

assigning to users
2nd

case-sensitivity

changing for Admin User (user-level security)
2nd

clearing user passwords

code

security measures

databases
2nd
3rd

ensuring users have passwords
2nd

external data
2nd
3rd

listing users without passwords
2nd

lost passwords

share-level security
2nd
3rd

SQL

changing
2nd

system administrator (user-level security)

user rights

user-level security

pdbe object-naming prefix

Performance Analyzer
2nd

queries

Performance Analyzer dialog box
2nd

period (.)

permissions

Administer

assigning
2nd

SQL
2nd

constants

Delete Data

Insert Data

Modify Design

objects

assigning/revoking
2nd

Open Exclusive

Open/Run

Read Data

Read Design

removing

SQL
2nd

Update Data

user rights

databases

implicit

modifying
2nd
3rd
4th

new objects

view rights, assigning

workgroups

types
2nd

persisting recordsets
2nd
3rd

personal applications

developing

personal error handling, preventing

personal identification (PID)

workgroups

pessimistic locking

Picture properties

forms

reports

PID (personal identification)

Pivot Chart view

tables

displaying
2nd
3rd

Pivot Table view

fields
2nd

forms

controlling information detail
2nd

data filtering
2nd

displaying
2nd
3rd
4th

summarized data
2nd

query displays
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th

axes exchange

filtering data
2nd
3rd

summarized data
2nd

tables

axes exchange

controlling information detail
2nd

displaying
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th

filtering data
2nd

summarized data display
2nd

pivot tables

forms

controlling information detail (Pivot Table view)
2nd

creating from
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th

displaying (Pivot Table view)
2nd
3rd
4th

filtering data (Pivot Table view)
2nd

summarized data (Pivot Table view)
2nd

queries

creating from
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th

Pivot Tables

replacing Crosstab queries with

PivotCharts

new features

PivotTables

new features

polymorphism

Pop Up property

forms

pop-up forms
2nd
3rd

PowerPoint

controlling from Access
2nd
3rd

slides
2nd

precedence

procedures
2nd

prefixes (naming conventions)

Preserve keyword
2nd

preventing personal error handling

previewing

reports

PreviousControl property

Primary Key indexes

creating
2nd

primary keys

Append queries

normalization

normalization and

Null values and

Update queries

warnings

primary keys (client/servers)

Print common dialog box

Print event

report sections
2nd

Print Form Definition dialog box (Database Documenter)

Print Query Definition dialog box (Database Documenter)

Print Security dialog box

Print Table Definition dialog box (Database Documenter)

PrintCount property

reports

printed forms

Printer object
2nd

Printers collection

printing

error forms

forms

labels

in specific locations
2nd
3rd

multiple labels
2nd
3rd

page headers

reports
2nd
3rd

reports

page breaks, inserting

properties
2nd

user/group information (security)
2nd

values to the Immediate window
2nd

PrintSection property

reports
2nd
3rd

private procedures

private variables

Private variables
2nd

system information class
2nd

prm object-naming prefix

prms object-naming prefix

procedures

.

functions
[See also subroutines]

calling

ChangeCaption

declaring

Class modules

error handling

creating call stacks
2nd
3rd

event

creating

modules

executing

Module window
2nd
3rd

GetDriveInfo

libraries

unique names

private

public

recursive procedures
2nd

scope
2nd
3rd

precedence
2nd

Static
2nd

updating records

variables

lifetime

programming
[See also coding]

importing

external data

new features
2nd

VBA

constants

find and replace feature

viewing code
2nd

prohibited tasks, accomplishing

project properties
2nd

editing

viewing

Project Properties dialog box

Project window

VBA

Project/Library drop-down list (Object Browser)

projects

passwords

protection measures

properties
2nd

AbsolutePosition
2nd

AbsolutePosition property (ADO recordsets)
2nd

ActiveControl

ActiveForm

ActiveReport

ActivesX controls

setting at design time
2nd

adding to Class modules

Alias property

query tables

Application object

assigning multiple properties

With...End With construct
2nd

automation objects

BOF property (ADO recordsets)
2nd

bookmark

records

Bookmark property (ADO recordsets)
2nd

Bound Column

combo boxes

Calendar control

DayFont

DayFontColor

DayLength

GridFont

GridFontColor

GridLinesColor

GridLinesFormat

MonthLength

ShowDateSelectors

ShowTitle

Value

ValueIsNull

Caption property

query fields

changing

loops

check boxes

Triple state property

Column Count

combo boxes

Column Width

combo boxes

combo boxes

Common Dialog control

compared to methods
2nd

Connection strings

Control

forms
2nd
3rd
4th
5th

control defaults

optimization and

Control Source

combo boxes

controls
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th
12th
13th

Allow AutoCorrect

Auto Repeat

Auto Tab

availability

Back Color
2nd

Back Style
2nd

Border Color
2nd

Border Style
2nd

Border Width
2nd

Bottom Margin

Can Grow
2nd

Can Shrink
2nd

Cancel

Caption

Control Source

ControlTip Text

Data
2nd

Data properties
2nd

Default Value

Display When

Enter Key Behavior

Font Color

Font Italic
2nd

Font Name
2nd

Font Size
2nd

Font Underline
2nd

Font Weight
2nd

Fore Color
2nd

Format
2nd
3rd
4th
5th
6th

Format properties
2nd
3rd
4th

Height
2nd

Help Context ID

Hyperlink Address
2nd

Hyperlink SubAddress
2nd

IME (Input Method Editor)

Input Mask

Is Hyperlink

Keyboard Language

Left
2nd

Left Margin

Line Spacing

Margin

Name
2nd

Numerical Shape

Other

Reading Order

Right Margin

Running Sum

Scroll Bar Align

Scroll Bars

Shortcut Menu Bar

Special Effect
2nd

Status Bar Text

Tab Index

Tab Stop

Tag
2nd

Text Align

Top
2nd

Top Margin

Validation Rule

Validation Text

Vertical

Visible

Width
2nd

ControlType property
2nd
3rd
4th

custom

adding to classes
2nd

custom properties

creating
2nd
3rd
4th
5th
6th

PropertyGet routine
2nd
3rd

PropertyLet routine
2nd
3rd

Public variables, creating
2nd
3rd

data access pages
2nd
3rd
4th

ConnectionFile
2nd
3rd
4th
5th
6th

ConnectionString

Data properties
2nd
3rd
4th
5th
6th
7th
8th
9th
10th

DdataEntry

MaxRecords

navigation buttons

record navigation control properties
2nd
3rd

RecordsetType

RecordSource

UseRemoteProvider

databases

documentation

DateCreated
2nd

DateModified
2nd

default

Description property

queries

query fields

EOF

EOF property (ADO recordsets)
2nd

Err object

Field List properties

queries

Field properties

queries
2nd

field properties

tblClients table
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th
12th
13th
14th
15th
16th
17th
18th
19th
20th
21st
22nd
23rd
24th
25th
26th
27th
28th
29th
30th
31st
32nd
33rd
34th
35th
36th
37th
38th

tblCompanyInfo table
2nd
3rd
4th
5th
6th

tblEmployees table
2nd
3rd
4th
5th

tblErrorLog table
2nd
3rd
4th

tblErrors table
2nd
3rd
4th

tblPaymentMethods table
2nd

tblPayments table
2nd
3rd
4th

tblProjects table
2nd
3rd
4th
5th

tblTimeCardExpenses table
2nd
3rd
4th

tblTimeCardHours table
2nd
3rd
4th
5th

tblTimeCards table
2nd
3rd

tblWorkCodes table
2nd

fields

Default Value

Input Mask

printing

Validation Rule

file information class

FullFileName property
2nd
3rd

Filter
2nd

tables

Filter property

queries

Filter property (ADO recordsets)
2nd

FilterOn
2nd

Force New Page

reports

Form

Format property

query fields

forms
2nd
3rd
4th
5th
6th
7th
8th

Allow Additions

Allow Datasheet View

Allow Deletions

Allow Design Changes

Allow Edits

Allow Filters

Allow Form View

Allow PivotChart View

Allow PivotTable View

Auto Resize

Border Style

Cycle

Data Entry

Data properties
2nd

Description property

Dividing Lines

Fast Laser Printing

Fetch Defaults

Filter

Format

Format properties
2nd

Grid X

Grid Y

Has Module

Help Context ID

Help File

Layout for Print

Menu Bar

Min Max Buttons

Modal

Moveable

Navigation Buttons

OpenArgs property
2nd

Order By

Orientation

Palette Source

Picture

Pop Up

Record Locks

Record Selectors

Recordset Type

RecordSource property
2nd
3rd

Scroll Bars

Shortcut Menu

Shortcut Menu Bar

Subdatasheet

Tag

Toolbar

What's This Button

Width

Help
2nd

Input Mask property

query fields
2nd

LastModified
2nd

Lookup Wizard

Display Control property

Me

modifying
2nd

Module

Multiselect property (list boxes)
2nd

Object Browser

objects

object library

Order By property

queries

OrderBy
2nd

OrderByOn
2nd

Orientation

tables

UpDown object

Output All Fields property

queries

Parent

adding to classes
2nd

PreviousControl

project properties
2nd

editing

viewing

queries

Description property

modifying behavior and appearance
2nd

viewing

Query properties
2nd

Record Locks property

queries

RecordCount
2nd
3rd

RecordCount property (ADO recordsets)
2nd
3rd
4th

Recordset objects
2nd

Recordset Type property

queries

RecordsetClone

forms

recordsets
2nd
3rd
4th

RecordSource

Report

reports
2nd
3rd
4th
5th
6th
7th
8th
9th
10th

Auto Center

Auto Resize

Border Style

Can Grow property

Can Shrink property

Caption

Close Button

Control Box

controls
2nd
3rd
4th
5th

Data

Description property

Force New Page property

Format

FormatCount

Grid X

Grid Y

Group On property

Grp Keep Together

HasContinued

Help Context ID

Help File

Layout for Print

Min Max Buttons

MoveLayout
2nd
3rd

NextRecord
2nd
3rd

Page Footer

Page Header

Picture

PrintCount

PrintSection
2nd
3rd

Repeat Section property

sorting/grouping data
2nd

Tag

Width

WillContinue

Rich Textbox control

Row Source Type

combo boxes

Run Permissions property

queries

Section

Sort property (ADO recordsets)
2nd

Source property

query tables

special properties that refer to objects
2nd

Subdatasheet Name

tables

subforms

Link Child Fields

Link Master Fields

Source Object

subreports

Can Grow

Can Shrink

Link Child Fields

Link Master Fields

Source Object

Tab controls
2nd

table fields

Allow Zero Length
2nd
3rd

Caption
2nd

Default Value
2nd

Field Size
2nd

Format
2nd

Indexed
2nd
3rd
4th

Input Mask
2nd
3rd
4th

Required
2nd
3rd

Unicode Compression

Validation Rule
2nd
3rd
4th

Validation Text

tables
2nd

Description

viewing
2nd
3rd

Top Values

queries
2nd
3rd

Top Values property

queries

Unique Records

queries

Unique Records property

queries

Unique Values

queries
2nd

Unique Values property

queries

UpDown object

upsizing to client/servers

Validation Rule

tables

Validation Text

tables

viewing

Properties collection

Table object

Properties object

Data Access Object model

Properties window

reports

VBA

property builders

Property Get routine

Class modules
2nd

class modules

custom error handler class

data access class
2nd

system information class
2nd

Property Let routine

Class modules
2nd

class modules

custom error handler class

data access class
2nd

system information class
2nd

PropertyGet routine

custom properties, creating
2nd
3rd

PropertyLet routine

custom properties, creating
2nd
3rd

prototypes

applications development
2nd

prp object-naming prefix

prps object-naming prefix

prps prefix

Public constants

Public keyword

public procedures

public variables
2nd

Public variables
2nd

custom properties, creating
2nd
3rd

PWD keyword

/ 544