Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

1NF (first normal form), First Normal Form
2NF (second normal form), Second Normal Form
3NF (third normal form), Third Normal Form
! (bang) operator, Referencing Objects, Fully Qualified Object Names
" " (double quotation marks), Constants
# (number sign), Constants
. (dot) operator, Fully Qualified Object Names
Ô (apostrophe), Comments
q-joins (theta-joins), θ-Join, Implementing Joins in Microsoft Access, Inner joins
[ ] (square brackets), Built-in Functions and Statements
¥ (“many”) symbol, Types of Relationships

A

AbsolutePage property, Properties of the Recordset object
AbsolutePosition property (ADO), Properties of the Recordset object
AbsolutePosition property (DAO), Notes on the Move methods
ac symbolic constants, Constants
Access
CurrentDb function for, The CurrentDb Function–The CurrentDb Function
housekeeping in, Properties and Methods of DAO Collections
Object data types for, Access Object Data Types
object model for, The Microsoft Access Object Model
Access collections, Properties and Methods of Access Collections
Access forms, Project Contents
Access IDE, The Visual Basic Editor, Part I
starting, The Visual Basic Editor, Part I
access modes, Properties of the Connection object
access permissions, Users
Access SQL, Details of the Relational Algebra, Introduction to Access SQL–Access SQL
data types for, Column definition
DDL component of, The DDL Component of Access SQL–Note
DML component of, The DML Component of Access SQL–Parameters
query types for, Access Query Types
reasons for using, Why Use SQL?
syntax conventions for, Syntax Conventions
action queries, Access Query Types, Running a Query
ActiveConnection property, Properties of the Recordset object, Command objects and connections
ActiveX Data Objects (see ADO)
ActualSize property, Properties of the Field object
Add method, Properties and Methods of User-Defined Collections
adding
columns to tables, The ALTER TABLE Statement
foreign keys to tables, Implementing a One-to-Many Relationship—Foreign Keys
records to recordsets, Adding a New Record
AddNew method, Adding a New Record, Methods of the Recordset object
address, memory and, Object Variables
adjacent quotation marks, String Data Type
ADO (ActiveX Data Objects), What Is ADO?–An Example: Using ADO over the Web
vs. DAO and ADOX, ADOX: Jet Data Definition in ADO
installing, Installing ADO
object model for, The ADO Object Model–Properties of the Field object
treelike view of, The ADO Object Model
OLE DB and, ADO and OLE DB–Service Providers
using over the Web, An Example: Using ADO over the Web–An Example: Using ADO over the Web
ADO Extensions for Data Definition and Security (ADOX), ADOX: Jet Data Definition in ADO–Conclusion
ADO objects, The Three-Pronged Approach to Data Manipulation–Properties of the Field object
ADODB prefix, The Three-Pronged Approach to Data Manipulation
ADOX (ADO Extensions for Data Definition and Security), ADOX: Jet Data Definition in ADO–Conclusion
object model for, The ADOX Object Model
algebraic query languages, Relational Algebra and Relational Calculus–Relational Algebra and Relational Calculus
ALL option
SELECT statement and, Predicate
UNION statement and, The UNION Statement
AllowZeroLength property, Note
ALTER TABLE command, The ALTER TABLE Statement
anomalies, Update anomalies
apostrophe (Ô) indicating comments, Comments
Append method, Properties and Methods of DAO Collections
append queries, Access Query Types
AppendChunk method, The Field Object
application-defined properties, Types of Properties
application modal dialog box, The MsgBox Function
architecture of databases, Why Program?
arguments, Parameters and Arguments–ByRef Versus ByVal Parameters
vs. parameters, Parameters and Arguments
arrays, Arrays–The UBound function
As Object declaration, The generic As Object declaration
assignments, Making Assignments with Default–Solution
atomic attributes, First Normal Form
attribute dependency, Redundancy
attribute names (see table schemes)
attributes, Entities and Their Attributes–Entities and Their Attributes, A Short Glossary
atomic, First Normal Form
environment, Preliminaries
fully qualified attribute names and, Cartesian Product
indivisible, First Normal Form
of ODBC drivers, Getting Driver Information–Getting Driver Information
for Relation objects, Creating a Relation
renaming, Renaming
scalar, First Normal Form
strictly informational, Redundancy
structured, First Normal Form
Attributes property, The Property Object and Dynamic Properties, Properties of the Field object
automatic syntax checking, Design-Time and Compile-Time Errors

B

backing up databases, Backing Up the Database
bang (!) operator, Referencing Objects, Fully Qualified Object Names
base tables, Query Languages
BCNF (Boyce-Codd normal form), Boyce-Codd Normal Form
Beep statement, The Beep Statement
BOF property (ADO), Properties of the Recordset object
BOF property (DAO), BOF and EOF
Bookmark property, Properties of the Recordset object
bookmarks, Bookmarks, Cursors
Boolean data types, Boolean Data Type
Boyce-Codd normal form (BCNF), Boyce-Codd Normal Form
break mode, Run Mode, Break Mode, and Design Mode
breakpoint, Run Mode, Break Mode, and Design Mode
bugs (see errors)
built-in functions, Built-in Functions and Statements–The Switch Function
built-in properties (ADO), The Property Object and Dynamic Properties
built-in properties (DAO), Types of Properties
Button types, The MsgBox Function
buttons, The MsgBox Function–The MsgBox Function
ByRef parameters, ByRef Versus ByVal Parameters
ByVal parameters, ByRef Versus ByVal Parameters

C

CacheSize property, Properties of the Recordset object
call stack, The Calls Stack
calling (see declaring)
calling procedure, error-handling in, Handling Errors in the Calling Procedure
candidate keys, Keys and Superkeys
Cartesian product of tables, Cartesian Product
cascading updates/deletions, Cascading Updates and Cascading Deletions
Case Else part, The Select Case Statement
case-insensitive comparison, VBA String Functions
Catalog object, Creating a Database
characters, repeated, VBA String Functions
class modules, Class modules
classes, Entities and Their Attributes
DAO, list of, DAO Classes–Properties
entity (see entity classes)
client side, Cursors
client/server architecture, The Client/Server Architecture
Clone method, Methods of the Recordset object
Close method (ADO)
of Connection object, Methods of the Connection object, Methods of the Connection object
of Recordset object, Methods of the Recordset object, Methods of the Recordset object
Close method (DAO), Closing DAO Objects
closing objects, Closing DAO Objects
code
bookmarking, Bookmarks
debugging, Debugging–Breaking out of Debug mode
error handling and, Handling Errors in Code–The Resume Statement
executing, The Immediate Window, Tracing
in break mode, Run to Cursor (Ctrl+F8 or choose Run To Cursor from the Debug menu)
long lines of, handling, Line Continuation
sample, for ODBC, Open Database Connectivity (ODBC)
Code window, The Code Window–The Object and Procedure Listboxes
collections, The DAO Object Model–The DAO Object Model, Collections Are Objects Too–Refreshing Certain Collections
Collection objects and, A Collection Object
DAO collections and, A Look at the DAO Objects–Indexes
default, Default Collections
for objects, DAO Classes–Properties
Properties collection and, The Properties Collection–User-Defined Properties
refreshing, Refreshing Certain Collections, The CurrentDb Function
types of, Collections Are Objects Too
user-defined, Properties and Methods of User-Defined Collections
columns
adding/deleting, The ALTER TABLE Statement
constraint clauses for, Constraints
definition for, Column definition
headings for, Implementing Entity Sets—Tables
order of, Implementing Entity Sets—Tables
projection and, Projection
COM (Component Object Model), ADO and OLE DB
Command objects, The Command Object–Methods of the Command object
commands
in ADO, Methods of the Connection object, Creating a Query
compound, Methods of the Recordset object
executing, The Immediate Window
CommandText property, Properties of the Command object
CommandTimeout property, Properties of the Connection object, Properties of the Command object
CommandType property, Properties of the Command object
comments, Comments
compile errors, Design-Time and Compile-Time Errors
compiling programs, Design-Time and Compile-Time Errors
Component Object Model (COM), ADO and OLE DB
compound commands, Methods of the Recordset object
conceptual databases, Database Systems
Connection objects, The Connection Object–Methods of the Connection object
connection strings, A Closer Look at Connection Strings–ODBC support, Connection Strings
ConnectionFunction attribute, Getting Driver Information
ConnectionString property, Properties of the Connection object
ConnectionTimeout property, Properties of the Connection object
constants, Constants
enums and, Enums
scope of, Variable Scope
for Type property, Property: Type, Notes
VBA string functions and, VBA String Functions–VBA String Functions
constraints, Constraints
referential, Referential Integrity
Container objects, The DAO Object Model, Containers–Containers, Collections
continuation, Line Continuation
control statements, Control Statements–A Final Note on VBA
Controls collection, Properties and Methods of Access Collections
Count property, Properties and Methods of Access Collections
user-defined collections and, Properties and Methods of User-Defined Collections
counter, For loop and, The For Loop–The Do Loop
CreateDatabase method, Creating a Database
CreateField method, Notes
CREATE INDEX command, The CREATE INDEX Statement
CreateIndex method, Creating an Index
CreateParameter method, Methods of the Command object
CreateQueryDef method, Creating a QueryDef
CreateRelation method, Creating a Relation
CREATE TABLE command, The CREATE TABLE Statement–Notes
CreateTableDef method, Creating a Table and Its Fields
creating
databases, Creating a Database
fields, Creating a Table and Its Fields–Note
indexes
in ADOX, Creating Indexes–Creating Indexes
in DAO, Creating an Index–Creating an Index
Jet databases, Creating a Database–Creating a Database
Jet tables, Creating Tables
primary keys in ADOX, Creating a Primary Key
queries
in ADOX, Creating a Query
in DAO, Creating a QueryDef–Properties of a QueryDef Object
QueryDefs objects, Creating a QueryDef–Properties of a QueryDef Object
relations, Creating a Relation–Notes
sample database, Obtaining or Creating the Sample Database–Entering and Running the Sample Programs
tables, Creating a Table and Its Fields–Note
text files, File-Related Functions
crosstab queries, Access Query Types, TRANSFORM–TRANSFORM
current position/record in recordsets, Moving Through a Recordset
CurrentDb function, The CurrentDb Function–The CurrentDb Function
cursors, Cursors
CursorLocation property, Properties of the Connection object, Cursors, Properties of the Recordset object
CursorType property, Properties of the Recordset object

D

dangling references, Maintaining relational integrity, Referential Integrity
DAO classes, list of, DAO Classes–Properties
DAO collections, Collections Are Objects Too–Refreshing Certain Collections
DAO (Data Access Objects), Why Program?, The Jet DBMS, Programming DAO: Overview
ADO and, What Is ADO?, ADOX: Jet Data Definition in ADO
ADOX and, ADOX: Jet Data Definition in ADO
DDL programming and, Programming DAO: Data Definition Language–Properties of a QueryDef Object
DML programming and, Programming DAO: Data Manipulation Language–Notes
Microsoft support for, Conclusion
Object data types for, Access Object Data Types
object model for, The DAO Object Model–The DAO Object Model
Properties collection and, The Properties Collection–User-Defined Properties
referencing objects and, Referencing Objects–Default Collections
DAO objects, A Look at the DAO Objects–Indexes
list of, A Collection Object–Properties
data, Avoiding data loss
editing using recordsets, Editing Data Using a Recordset–Notes
manipulating in database, Data Manipulation Languages
NULL values and, NULL Values
persistent, What Is a Database?
solving manipulation problems with, Some Common Data Manipulation Problems–Solution
viewing vertically/horizontally, Vertical to Horizontal–Solution
Data Access Objects (see DAO)
data consumers, Data Consumers
data definition, ADOX for, ADOX: Jet Data Definition in ADO–Conclusion
data dictionary/catalog, Database Management Systems
data manipulation language (see DML)
data providers, Data Providers–Data Providers, The ADO Object Model, Properties of the Connection object
Data Source Name (see DSN)
data source types, DSNs and Data Source Types
data sources, Data Stores, Data Stores, Data Sources–SQLDriverConnect
(see also DSN)
examples of, Example DSNs–Text-system data source
existing on system, Getting ODBC Information Using Visual Basic–Getting ODBC Information Using Visual Basic, Getting Data Sources
functions for connecting to, Connecting to a Data Source
list of, Getting ODBC Information Using Visual Basic–Getting ODBC Information Using Visual Basic, Getting Data Sources
data stores, Data Stores, Data Providers
data types, Column definition, Variables and Data Types–The Set statement
object, Access Object Data Types, Object Variables
of properties, Types of Properties
data-definition queries, Access Query Types
database management system (see DBMS)
Database objects, The DAO Object Model, Closing DAO Objects, Databases, Collections
Databases container, Containers
database programming, Database Programming
ADO and, What Is ADO?–Installing ADO
DAO DDL, Programming DAO: Data Definition Language–Properties of a QueryDef Object
DAO DML, Programming DAO: Data Manipulation Language–Notes
VBA and, Why Program?
database systems, Database Systems
databases, What Is a Database?
architecture of, Why Program?
backing up, Backing Up the Database
conceptual, Database Systems
creating
in DAO, Creating a Database
host languages for, The Jet DBMS
sample database, Obtaining or Creating the Sample Database–Entering and Running the Sample Programs
CurrentDb function for, The CurrentDb Function–The CurrentDb Function
deleting, Notes
design and, Database Design–Summary
duplicates of, The Jet DBMS, Notes
flat, Why Use a Relational-Database Design?
new, defining, Data Definition Languages
normalizing, Normalization–Decomposition
opening, Opening a Database
programming (see database programming)
relational (see relational databases)
resources for further reading, Suggestions for Further Reading
date constants, Constants
Date data type, Date Data Type
date-related functions, Date- and Time-Related Functions
dates, formatting, The Format Function
DBEngine object, DBEngine Object, Collections
DBMS (database management system), Database Design, Introduction to Access SQL, Database Management Systems, The Jet DBMS
(see also Jet DBMS)
client/server architecture for, The Client/Server Architecture
DBMS-based drivers, Driver Types
DBQ parameter, Connecting to an Excel workbook
DDL (data definition language)
as component of Access SQL, The DDL Component of Access SQL–Note
DAO and, Programming DAO: Data Definition Language–Properties of a QueryDef Object
for Jet DBMS, Data Definition Languages
debugging, The Immediate Window, Debugging–Breaking out of Debug mode, Handling Errors in Code
(see also problem-solving; runtime errors)
commenting out code and, Comments
debug mode, exiting from, Breaking out of Debug mode
declaration statements
location of in procedures, Variable Declaration
Require Variable Declaration option and, Option Explicit
declaring
functions, Calling Functions
subroutines, Calling Subroutines
variables, Variable Declaration
decomposition of table schemes, Decomposition–Decomposition
DefaultDatabase property, Properties of the Connection object
defaults
button, The MsgBox Function
collections, Default Collections
recordset types, Default Recordset Types
DefaultValue property, Note
DefinedSize property, Properties of the Field object
degree of table, Implementing Entity Sets—Tables, Union
deleting
cascading deletions and, Cascading Updates and Cascading Deletions
columns from tables, The ALTER TABLE Statement
databases, Notes
Delete method and (ADO), Methods of the Recordset object
Delete method and (DAO), Properties and Methods of DAO Collections, Deleting an Existing Record
delete queries and, Access Query Types, The DELETE Statement
DELETE statement and, The DELETE Statement
deletion anomalies and, Deletion anomalies
records, Deleting an Existing Record
tables, The DROP Statement
deletion anomalies, Deletion anomalies
dependency
attribute, Redundancy
functional, Functional Dependencies
loss of, Decomposition
trivial/nontrivial, Functional Dependencies
dependency-preserving decomposition, Decomposition
derived tables, Query Languages
design mode, Run Mode, Break Mode, and Design Mode
Step Into feature and, Step Into (F8 or choose Step Into from the Debug menu)
design-time errors, Design-Time and Compile-Time Errors
dialog boxes, The MsgBox Function
difference of tables, Difference–Difference
dimensions of an array, The dimension of an array
directories, housekeeping in, File-Related Functions
DISTINCT option, Predicate–Predicate, Predicate
DISTINCTROW option, Predicate–Predicate
DistinctCount property, Creating an Index
DLL (dynamic link library), The Jet DBMS, Introduction
DML (data manipulation language)
as component of Access SQL, The DML Component of Access SQL–Parameters
DAO and, Programming DAO: Data Manipulation Language–Notes
for Jet DBMS, Data Manipulation Languages
Do... loop statement, The Do Loop
docked windows, Docking
Document objects, The DAO Object Model, Documents, Methods
domains, Implementing Entity Sets—Tables
dot (.) operator, Fully Qualified Object Names
double quotation marks (” “), Constants
downloads, for LIBRARY sample database, Obtaining or Creating the Sample Database
driver types, Driver Types
DriverODBCVersion attribute, Getting Driver Information
drivers
ODBC, The ODBC Driver, Getting ODBC Driver Help, Getting Driver Information–Getting Driver Information
ODBC Driver Manager and, The ODBC Driver Manager
DROP statement, The DROP Statement
DSN (Data Source Name), The Microsoft OLE DB Provider for ODBC Drivers, Connecting to a text file, DSNs and Data Source Types–Text-system data source
connection strings and, Connection Strings
creating, Creating DSNs: The ODBC Administrator
examples of, Example DSNs–Text-system data source
types of, Creating DSNs: The ODBC Administrator
duplicate data (see redundancy)
duplicate Recordset objects, Methods of the Recordset object
duplicate rows, Projection
dynamic arrays, Dynamic arrays
dynamic cursors, Cursors
dynamic data, An Example: Using ADO over the Web
dynamic link library (see DLL)
dynamic properties, The Property Object and Dynamic Properties–The Property Object and Dynamic Properties
dynaset-type Recordset objects, Recordset Objects, Finding Records in a Dynaset-Type or Snapshot-Type Recordset

E

E/R (entity-relationship) diagram, Relationships Between Entities
editing buffer, Properties of the Recordset object
editing with recordsets, Editing Data Using a Recordset–Notes
EditMode property, Properties of the Recordset object
ElseIf parts, The If ...Then Statement
empty strings, NULL Values
End statement, Exiting a Procedure
Enforce Referential Integrity box, Setting Up the Relationships in Access
entities, Entities and Their Attributes–Entities and Their Attributes, A Short Glossary
E/R diagrams for, Relationships Between Entities
implementing, Implementing Entities–Implementing Entity Sets—Tables
relationships between, Relationships Between Entities
entity classes, Entities and Their Attributes–Entities and Their Attributes, A Short Glossary, Implementing a Many-to-Many Relationship—New Entity Classes
implementing, Implementing Entity Classes—Table Schemes
superkeys and, Keys and Superkeys, A Short Glossary
entity sets, Entities and Their Attributes, A Short Glossary
implementing, Implementing Entity Sets—Tables
superkeys and, Keys and Superkeys
entity-relationship (E/R) diagram, Relationships Between Entities
entity-relationship model, The Entity-Relationship Model of a Database
enums, Enums
environment handle, Preliminaries
EOF property (ADO), Properties of the Recordset object
EOF property (DAO), BOF and EOF
equality of sets, Equality of Sets–Solution
equi-joins, Equi-join, Implementing Joins in Microsoft Access
error messages
“Data source name not found...”, Connecting to a text file
“Invalid use of Null”, The Switch Function
“Item not found...”, The Properties Collection
“Project Unviewable”, The Project Window
error object (Err), The Error Object
Error objects, Errors, Properties
errors, Errors–Logical Errors
error dialog boxes and, Run Mode, Break Mode, and Design Mode
handling in code, Handling Errors in Code–The Resume Statement
resources for further reading, Handling Errors in Code
runtime (see runtime errors)
trapping, The On Error Goto Label Statement
Errors property, Properties of the Connection object
event procedures, The Calls Stack
example of DSNs, Example DSNs–Text-system data source
EXAMPLE.ZIP file, Obtaining or Creating the Sample Database
Excel (see Microsoft Excel)
Execute method, Methods of the Connection object, Methods of the Command object
Exit Do statement, The Do Loop
Exit For statement, The Exit For Statement
exiting
debug mode, Breaking out of Debug mode
procedures, Exiting a Procedure
expressions, query (see views)
external level of database, Database Systems
externally creatable objects, The ADO Object Model

F

Field objects, Fields, The Field Object–Properties of the Field object, Collections
properties of, Note
fields, Index Files
creating for tables, Creating a Table and Its Fields–Note
properties of, Note
file-based drivers, Driver Types
file data sources, File data sources
FileExtns attribute, Getting Driver Information
files, Index Files, File-Related Functions
(see also tables)
FileUsage attribute, Getting Driver Information
Find methods, Finding Records in a Dynaset-Type or Snapshot-Type Recordset
first normal form (1NF), First Normal Form
fixed-length string variables, String Data Type
flat databases, Why Use a Relational-Database Design?
floating windows, Docking
For Each loop, The For Each Loop
foreign keys, Implementing a One-to-Many Relationship—Foreign Keys
referential integrity and, Referential Integrity
ForÉNext statement (For loop), The For Loop
Format function, The Format Function
forms, Normal Forms–Boyce-Codd Normal Form
Forms collection, The Microsoft Access Object Model, Properties and Methods of Access Collections
Forms container, Containers
forward-only cursors, Cursors
FROM clause, FROM TableExpression
frontends, Host Languages
full-module view, Procedure and Full-Module Views
fully qualified attribute names, Cartesian Product
fully qualified object names, Fully Qualified Object Names, Default Collections
fully qualified procedure names, Fully Qualified Procedure Names
functional dependency, Functional Dependencies
decomposition and, Decomposition
functions, The IsDate function
built-in, Built-in Functions and Statements–The Switch Function
connection, The ODBC Driver Manager
for data source connections, Connecting to a Data Source
date- and time-related, Date- and Time-Related Functions
declaring, Calling Functions
file-related, File-Related Functions
ODBC, Getting ODBC Information Using Visual Basic
VBA, VBA String Functions–The Beep Statement

G

GetChunk method, The Field Object
GetRows method, Methods of the Recordset object
global variables, Module-level variables
glossary of database terms, A Short Glossary
GROUP BY option, GROUP BY GroupByCriteria
Group objects, Groups, Collections

H

HAVING option, HAVING GroupCriteria
help files, Getting Help
for ODBC drivers, Getting ODBC Driver Help
host applications, Host Languages
host languages, The Jet DBMS, Host Languages
housekeeping
in Access, Properties and Methods of DAO Collections
for files and directories, File-Related Functions

I

Icon types, The MsgBox Function
IDE (Integrated Development Environment), The Visual Basic Editor, Part I
keyboard shortcuts for, Navigating the IDE
IfÉThen statement, The If ...Then Statement
IgnoreNulls property, Creating an Index
Immediate If function (IIf function), The Immediate If Function
Immediate window, The Immediate Window
implementing
entities, Implementing Entities–Implementing Entity Sets—Tables
LIBRARY database, The LIBRARY Relational Database–Setting Up the Relationships in Access
relationships, Implementing the Relationships in a Relational Database–Cascading Updates and Cascading Deletions
in-line error checking, The On Error Resume Next Statement
index files, Index Files–Example
Index objects, Indexes, Creating Indexes, Collections
Index property, Notes on the Move methods
Indexed Sequential Access Method (ISAM), The Jet DBMS
indexes
ALTER TABLE statement for, The ALTER TABLE Statement
creating
in ADOX, Creating Indexes–Creating Indexes
in DAO, Creating an Index–Creating an Index
Indexes dialog box, Example
indivisible attributes, First Normal Form
information, loss of, Decomposition
Inherited property, Property: Inherited
initialized variables, Variable Initialization
INNER JOIN clause, Inner joins
inner joins, Joins–θ-Join, Inner joins
outer joins and, Outer Joins
semi-joins and, Semi-Joins–Semi-Joins
InputBox function, The InputBox Function
INSERT INTO statement, The INSERT INTO Statement
insertion anomalies, Insertion anomalies
Instr function, VBA String Functions
Integrated Development Environment (see IDE)
integrity (see referential integrity)
Internal ISAM Component, The Jet DBMS
internal level of database, Database Systems
intersection of tables, Intersection
Is function, The IsDate function
ISAM (Indexed Sequential Access Method), The Jet DBMS
IsDate function, The IsDate function
IsEmpty function, The IsEmpty function
IsMissing function, Optional Arguments
IsNull function, The IsNull function, The Switch Function
IsNumeric function, The IsNumeric function
Item method, Properties and Methods of User-Defined Collections

J

Jet Database Engine (see Jet DBMS)
Jet databases
ADOX data definition and, ADOX: Jet Data Definition in ADO–Conclusion
creating, Creating a Database–Creating a Database
Jet DBMS, The Jet DBMS–The Client/Server Architecture
integration with Access and Visual Basic, Host Languages
Jet Query Engine, The Jet DBMS
Jet tables, Creating Tables
JOIN statement, Nested joins
joins, Joins–Outer Joins, Joins–Notes
implementing in Access, Implementing Joins in Microsoft Access–Implementing Joins in Microsoft Access
semi-joins and, Semi-Joins–Semi-Joins

K

keyboard shortcuts, Navigating the IDE
keys, Keys and Superkeys, A Short Glossary
candidate, Keys and Superkeys
constraint clauses for, Constraints
foreign, Implementing a One-to-Many Relationship—Foreign Keys
functional dependency and, Functional Dependencies
NULLs appearing in, NULL Values
primary, Keys and Superkeys, Index Files
referenced, Implementing a One-to-Many Relationship—Foreign Keys
unique indexes and, Index Files
keyset cursors, Cursors
keywords, Calling Subroutines–Fully Qualified Procedure Names

L

labels, The On Error Goto Label Statement
languages
algebraic query, Relational Algebra and Relational Calculus–Relational Algebra and Relational Calculus
data definition (see DDL)
data manipulation (see DML)
host (see host languages)
nonprocedural, Relational Algebra and Relational Calculus
structured query (see SQL)
late binding, The generic As Object declaration
LCase function, VBA String Functions
Left function, VBA String Functions
left outer joins, Difference, Outer Joins, Implementing Joins in Microsoft Access
left semi-joins, Semi-Joins
Len function, VBA String Functions
LIBRARY sample database, Database Design–Insertion anomalies, The Entity-Relationship Model of a Database–Entities and Their Attributes
downloading files for, Obtaining or Creating the Sample Database
entity-relationship diagram for, Implementing the Relationships in a Relational Database
implementing, The LIBRARY Relational Database–Setting Up the Relationships in Access
primary keys in, Keys and Superkeys
Properties collection and, Property: Value
Relation objects and, Notes
TableDef objects and, Say It Again
lifetime, Variable Lifetime–Static variables
Like operator function, VBA String Functions
line-continuation character, Line Continuation
ListDPs procedure, Finding OLE DB Providers–Finding OLE DB Providers, The Microsoft Jet 3.51 OLE DB Provider
literal constants, Constants
local constants/variables, Procedure-level (local) variables
LockType property, LockType, Properties of the Recordset object
logical errors, Logical Errors
logical pages, Properties of the Recordset object
logical structure of database, Database Systems
long integers, Numeric Data Types
looping, The For Loop–The Do Loop
loss of data, Avoiding data loss
lossless decomposition, Decomposition
LTrim function, VBA String Functions

M

machine data sources, Machine data sources
Macros container, Containers
make-table queries, Query Languages, Access Query Types, The SELECT...INTO Statement
“many” (¥) symbol, Types of Relationships
many-to-many relationships, Types of Relationships, Implementing a Many-to-Many Relationship—New Entity Classes
matching elements, A Matching Problem
MaxRecords property, Properties of the Recordset object
MDAC (Microsoft Data Access Components), Installing ADO
.mdb file, Closing DAO Objects, Creating a Database
memory, data types and, Variables and Data Types
metadata, Database Management Systems
methods
of Command objects, Methods of the Command object
of DAO collections, Properties and Methods of DAO Collections
for objects, Referencing the Properties and Methods of an Object, The DAO Object Model, DAO Classes–Properties
for Recordset objects, Methods of the Recordset object–Methods of the Recordset object
for recordsets, ODBC support
of user-defined collections, Properties and Methods of User-Defined Collections
Microsoft Access (see entries at Access)
Microsoft Data Access Components (MDAC), Installing ADO
Microsoft Excel, What Is ADO?
connecting to Microsoft OLE DB provider for ODBC, Connecting to an Excel workbook–Connecting to an Excel workbook
sample DSNs and, Example DSNs–Text-system data source
Microsoft Jet OLE DB provider, The Microsoft Jet 3.51 OLE DB Provider–The Microsoft Jet 3.51 OLE DB Provider
connection test for, The Microsoft Jet 3.51 OLE DB Provider
Microsoft, support for DAO and, Conclusion
Microsoft OLE DB provider for ODBC, The Microsoft OLE DB Provider for ODBC Drivers–ODBC support
connecting to Microsoft Excel, Connecting to an Excel workbook–Connecting to an Excel workbook
connecting to text files, Connecting to a text file–Connecting to a text file
Mid function, VBA String Functions
Mode property, Properties of the Connection object
module-level constants/variables, Module-level variables
modules, Class modules
Modules container, Containers
Move methods, Moving Through a Recordset, Methods of the Recordset object
moving through recordsets, Moving Through a Recordset–Notes on the Move methods
MsgBox function, The MsgBox Function–The MsgBox Function
multicolumn constraints, Constraints
multiple-value problems, Multiple-value problems

N

Name property (ADO), The Property Object and Dynamic Properties, Properties of the Field object
Name property (DAO), Property: Name, Properties of the Command object
named arguments, Named Arguments
names
fully qualified object, Fully Qualified Object Names, Default Collections
fully qualified procedure, Fully Qualified Procedure Names
for projects, Project Names
for variables, Object-Variable Naming Conventions
naming conventions for variables, Variable Naming Conventions, Object-Variable Naming Conventions
natural joins (nat-joins), Natural join–Natural join, Implementing Joins in Microsoft Access
navigating recordsets, Moving Through a Recordset–Notes on the Move methods
nested joins, Nested joins
NextRecordset method, Methods of the Recordset object
nodes, The Project Window, Project Contents
NoMatch property, Notes
nonprocedural languages, Relational Algebra and Relational Calculus
nontrivial dependency, Functional Dependencies
normal forms, Normal Forms–Boyce-Codd Normal Form
functional dependency and, Functional Dependencies
normalization, Normal Forms, Normalization–Decomposition
NULL values, Insertion anomalies, NULL Values
number sign (#), Constants
numbers
converting to strings, VBA String Functions
formatting, The Format Function
in InputBox, The InputBox Function
Numeric data types, Numeric Data Types
NumericScale property, Properties of the Field object

O

Object box, The Object and Procedure Listboxes
Object Browser utility, DAO 3.0/3.5 Collections, Properties, and Methods
object-collection relationships, The DAO Object Model
object data types, Access Object Data Types, Object Variables
object models
Access, The Microsoft Access Object Model
ADO, The ADO Object Model–Properties of the Field object
ADOX, The ADOX Object Model
COM, ADO and OLE DB
DAO, The DAO Object Model–The DAO Object Model
object properties, The DAO Object Model
object variables, Object Variables–Object-Variable Naming Conventions, Using Object Variables to Your Advantage
naming, Object-Variable Naming Conventions
vs. standard, Object Variables
objects, Objects–Referencing the Properties and Methods of an Object
ADO, The Three-Pronged Approach to Data Manipulation–Properties of the Field object
As Object declaration for, The generic As Object declaration
closing, Closing DAO Objects
collections and, Collections Are Objects Too–Refreshing Certain Collections
default collections for, Default Collections
Command, The Command Object–Methods of the Command object
Connection, The Connection Object–Methods of the Connection object
DAO, A Look at the DAO Objects–Indexes
error (Err), The Error Object
externally creatable, The ADO Object Model
fully qualified names for, Fully Qualified Object Names
referencing, Referencing the Properties and Methods of an Object, Referencing Objects–Default Collections
Set statement and, The Set statement
viewing, The Object and Procedure Listboxes
ODBC (Open Database Connectivity), The Microsoft OLE DB Provider for ODBC Drivers, The Microsoft OLE DB Provider for ODBC Drivers, Open Database Connectivity (ODBC)–Getting Data Sources
(see also Microsoft OLE DB provider for ODBC)
ODBC Administrator, The Microsoft OLE DB Provider for ODBC Drivers, Creating DSNs: The ODBC Administrator
ODBC Driver Manager, The ODBC Driver Manager
ODBC drivers, The ODBC Driver
help files for, Getting ODBC Driver Help
lists of, obtaining, Getting ODBC Information Using Visual Basic–Getting Driver Information
ODBC functions, Getting ODBC Information Using Visual Basic
OLE DB (technology), What Is ADO?, ADO and OLE DB–Service Providers
OLE DB providers, A Closer Look at Connection Strings–ODBC support
finding in Windows registry, Finding OLE DB Providers–Finding OLE DB Providers
On Error statements, The On Error Goto Label Statement, The On Error GoTo 0 Statement
one-to-many relationships, Types of Relationships, Implementing a One-to-Many Relationship—Foreign Keys
one-to-one relationships, Types of Relationships, Implementing a One-to-One Relationship
Open Database Connectivity (see ODBC)
Open method, Methods of the Connection object, Methods of the Recordset object
Open statement, File-Related Functions
OpenDatabase method, Opening a Database
opening
databases, Opening a Database
recordsets, Opening a Recordset
OpenRecordset method, Opening a Recordset
OpenSchema method, Methods of the Connection object, The Microsoft Jet 3.51 OLE DB Provider
operators, VBA and, VBA Operators
optimization, Optimization
Option Explicit, Option Explicit
optional arguments, Optional Arguments
optional parameters, Built-in Functions and Statements
Options parameter, Methods of the Connection object, Methods of the Connection object
ORDER BY option, Predicate, ORDER BY OrderByCriteria
order of columns/table rows, Implementing Entity Sets—Tables
OriginalValue property (ADO), Properties of the Field object
outer joins, Outer Joins, Implementing Joins in Microsoft Access, Outer joins
overlapping intervals, Overlapping Intervals I–Solution

P

PageCount/PageSize property, Properties of the Recordset object
Parameter objects, Parameters, Properties
parameter queries, Access Query Types, Parameters
parameters, Parameters and Arguments
to a function, Calling Functions
optional, Built-in Functions and Statements
Parameters property, Properties of the Command object
PARAMETERS statement, Parameters
pass-through queries, Access Query Types
pattern matching, VBA String Functions
PercentPosition property, Notes on the Move methods
persistent data, What Is a Database?
physical database, Database Systems
Internal ISAM component and, The Jet DBMS
pointer variables, Object Variables
positional arguments, Named Arguments
Precision property (ADO), Properties of the Field object
predicate (the), Predicate
Prepared property, Properties of the Command object
primary index, Index Files
primary keys, Keys and Superkeys, Index Files
creating in ADOX, Creating a Primary Key
Primary property, Creating an Index
private constants/variables, Module-level variables
Private/Public procedures, Public and Private Procedures
problem-solving, Some Common Data Manipulation Problems–Solution
procedural languages, Relational Algebra and Relational Calculus
Procedure list box, The Object and Procedure Listboxes
procedure-level constants/variables, Procedure-level (local) variables
procedures, Standard modules, Creating a Procedure–Run Mode, Break Mode, and Design Mode, Exiting a Procedure
creating, Creating a Procedure
executing, Run Mode, Break Mode, and Design Mode
exiting, Exiting a Procedure
Private/Public, Public and Private Procedures
stepping and, Step Over (Shift+F8 or choose Step Over from the Debug menu)
viewing, Procedure and Full-Module Views
programmatic ID, Finding OLE DB Providers
programming (see database programming)
Project Explorer, The Project Window–Class modules
projection, Projection, The SELECT Statement
(see also SELECT statement)
projects, The Project Window
names of, Project Names
properties, The DAO Object Model
application-defined, Types of Properties
built-in (ADO), The Property Object and Dynamic Properties
built-in (DAO), Types of Properties
of Command objects, Properties of the Command object
of DAO collections, Properties and Methods of DAO Collections
editing, Changing the Properties of an Existing Table or Field
of fields, Note
of indexes, Creating an Index
of Microsoft Access collections, Properties and Methods of Access Collections
for objects, DAO Classes–Properties
of QueryDef objects, Properties of a QueryDef Object
of Recordset objects, Properties of the Recordset object–Properties of the Recordset object
recordset-available, ODBC support
referencing, Referencing the Properties and Methods of an Object
types of, Types of Properties
user-defined, User-Defined Properties
of user-defined collections, Properties and Methods of User-Defined Collections
Properties collection (ADO), The Property Object and Dynamic Properties
Properties collection (DAO), The Properties Collection–User-Defined Properties
Properties property, The Property Object and Dynamic Properties
Properties window, The Properties Window
Property objects (ADO), The Property Object and Dynamic Properties–The Property Object and Dynamic Properties
Property objects (DAO), The Properties Collection, Property: Inherited, Properties
Provider property, Properties of the Connection object
public constants/variables, Module-level variables

Q

qualified attribute names, Cartesian Product
queries, Query Languages, Access Query Types
Access design of, Access Query Design
creating
in ADOX, Creating a Query
in DAO, Creating a QueryDef–Properties of a QueryDef Object
Jet Query Engine for, The Jet DBMS
make-table, Query Languages
parameter, Access Query Types, Parameters
running, Running a Query
subqueries and, Access Query Types, Subqueries–Notes
updatable, Access Query Types, Updatable Queries, The UPDATE Statement
Query Design window, Details of the Relational Algebra, Access Query Design
query expressions (see views)
query types, Access Query Types
QueryDef objects, QueryDefs, Collections
creating, Creating a QueryDef–Properties of a QueryDef Object
properties of, Properties of a QueryDef Object
quotation marks
adjacent, String Data Type
double, Constants
quotients, Other Relational Algebra Operations, The Quotient: An Additional Operation of the Relational Algebra–Step 3

R

read-only properties, Types of Properties
read/write properties, Types of Properties
readability
improved
by named arguments, Named Arguments
by object variables, Using Object Variables to Your Advantage
of VBA programs, Variable Naming Conventions
RecordCount property, Properties of the Recordset object
records (see rows)
RecordsAffected parameter, Methods of the Connection object
RecordsAffected property, Properties of a QueryDef Object
Recordsets collection, Note
recordset cursors, Cursors
Recordset objects, Closing DAO Objects, Recordsets, Recordset Objects–Notes, The Recordset Object–Methods of the Recordset object, Collections
creating, The Recordset Object
duplicating, Methods of the Recordset object
methods of, Methods of the Recordset object–Methods of the Recordset object
obtaining in ADO, The Three-Pronged Approach to Data Manipulation
opening, Opening a Recordset
properties of, Properties of the Recordset object–Properties of the Recordset object
searching, Finding Records in a Recordset–Finding Records in a Dynaset-Type or Snapshot-Type Recordset
snapshot-type, Recordset Objects
recordset types, Default Recordset Types, ODBC support
recordsets
adding records to, Adding a New Record
Do... loops and, The Do Loop
navigating, Moving Through a Recordset–Notes on the Move methods
redimensioning arrays, The UBound function
redundancy, Redundancy–Redundancy, Redundancy–Redundancy
referenced keys, Implementing a One-to-Many Relationship—Foreign Keys
referenced table schemes, Implementing a One-to-Many Relationship—Foreign Keys
referencing methods and properties, Referencing the Properties and Methods of an Object
referencing objects, Object Variables, Referencing Objects
referential constraints, Referential Integrity
referential integrity, Maintaining relational integrity, Referential Integrity
NULL in primary keys and, NULL Values
Refresh method, Properties and Methods of DAO Collections
refreshing collections, Refreshing Certain Collections, The CurrentDb Function
Relations collection, Relations
Relations container, Containers
Relation objects, Creating a Relation–Notes, Collections
relational algebra, Relational Algebra and Relational Calculus–Optimization
relational calculus, Relational Algebra and Relational Calculus–Relational Algebra and Relational Calculus
relational databases, Why Use a Relational-Database Design?–Creating views, A Short Glossary
entity-relationship model of, The Entity-Relationship Model of a Database
relations
creating, Creating a Relation–Notes
VBA, VBA Operators
relationships
between entities, Relationships Between Entities
between tables, Nested joins
implementing, Implementing the Relationships in a Relational Database–Cascading Updates and Cascading Deletions
integrity of (see referential integrity)
object-collection, The DAO Object Model
types of, Types of Relationships
Relationships view, Setting Up the Relationships in Access
remote database model, The Client/Server Architecture
Remove method, Properties and Methods of User-Defined Collections
renaming table attributes, Renaming
repeated characters, VBA String Functions
Replication Engine, The Jet DBMS
Reports collection, Properties and Methods of Access Collections
Reports container, Containers
Requery method, Methods of the Recordset object
Require Variable Declaration option, Option Explicit
Required property, Note, Creating an Index
resources for further reading
databases, Suggestions for Further Reading
errors, Handling Errors in Code
Visual Basic, Class modules
Visual Basic for Applications, A Final Note on VBA
restriction of tables (selection), Selection–Selection
result tables, Query Languages
Resume statements, The Resume Statement
Resync method, Methods of the Recordset object
Right function, VBA String Functions
right outer joins, Outer Joins, Implementing Joins in Microsoft Access
right semi-joins, Semi-Joins
rows, Index Files
deleting, Deleting an Existing Record
duplicate, Projection, Predicate
inserting into tables, The INSERT INTO Statement
order of, Implementing Entity Sets—Tables
selection and, Selection–Selection
RTrim function, VBA String Functions
run mode, Run Mode, Break Mode, and Design Mode
runtime errors, Runtime Errors, Handling Errors in Code–The Resume Statement
Run to Cursor feature, Run to Cursor (Ctrl+F8 or choose Run To Cursor from the Debug menu)
running queries, Running a Query
running sums, Running Sums–Solution

S

sample database, obtaining, Obtaining or Creating the Sample Database–Entering and Running the Sample Programs
sample DSNs, Example DSNs–Text-system data source
scalar attributes, First Normal Form
schema.ini, Text-system data source
scope, Variable Scope
vs. lifetime, Variable Lifetime
SDI (single document interface), The Project Window
searching recordsets, Finding Records in a Recordset–Finding Records in a Dynaset-Type or Snapshot-Type Recordset
second normal form (2NF), Second Normal Form
secondary index, Index Files
Seek method, Finding Records in a Table-Type Recordset
Select Case statement, The Select Case Statement
SELECTÉ INTO statement, The SELECT...INTO Statement
select queries, Access Query Types, Running a Query
SELECT statement, The SELECT Statement–ORDER BY OrderByCriteria, Some Common Data Manipulation Problems
DISTINCT option and, Predicate–Predicate, Predicate
DISTINCTROW option and, Predicate, Predicate
for subqueries, Subqueries–Notes
selection, Selection–Selection
self-joins, Self-joins
semantic models, Relationships Between Entities
semi-joins, Semi-Joins–Semi-Joins
semiqualified names, Fully Qualified Object Names
SEQUEL, Introduction to Access SQL
server side, Cursors
service providers, Service Providers
Set Next Statement feature, Set Next Statement (Ctrl+F9 or choose Set Next Statement from the Debug menu)
Set statement, The Set statement
sets, equality of, Equality of Sets–Solution
single-column constraints, Constraints
single document interface (SDI), The Project Window
snapshot-type Recordset objects, Recordset Objects, Finding Records in a Dynaset-Type or Snapshot-Type Recordset
Source property, Properties of the Recordset object
Space function, VBA String Functions
spaces, VBA String Functions
split-screens, Docking
SQL (Structured Query Language), Details of the Relational Algebra, Details of the Relational Algebra, Why Use SQL?
(see also Access SQL)
DAO and, Why Program?
SQLBrowseConnect function, Getting Driver Information
SQLConnect function, The SQLConnect Function, Getting Driver Information
SQLDataSources function, Getting Data Sources
SQLDriverConnect function, SQLDriverConnect, Getting Driver Information
SQLDrivers function, Getting Driver Information
SQLLevel attribute, Getting Driver Information
SQL queries, Access Query Types
SQL Server, What Is ADO?
SQLSetEnvAttr function, Preliminaries
SQL View, Access Query Design
square brackets [ ] indicating optional parameters, Built-in Functions and Statements
standard modules, Standard modules
State property, Properties of the Connection object, Properties of the Recordset object
statements, Miscellaneous Functions and Statements–The Resume Statement
changing order of execution for, Set Next Statement (Ctrl+F9 or choose Set Next Statement from the Debug menu)
control, Control Statements–A Final Note on VBA
error-handling, The On Error Goto Label Statement–The Resume Statement
stepping and, Step Into (F8 or choose Step Into from the Debug menu)
VBA and, Built-in Functions and Statements–The Beep Statement
static cursors, Cursors
static variables, Static variables–Static variables, Variable Initialization
Step Into feature, Step Into (F8 or choose Step Into from the Debug menu)
Step Out feature, Step Out (Ctrl+Shift+F8 or choose Step Out from the Debug menu)
Step Over feature, Step Over (Shift+F8 or choose Step Over from the Debug menu)
stepping, Debugging–Breaking out of Debug mode
Stop statement, Run Mode, Break Mode, and Design Mode
StrCmp function, VBA String Functions
Str function, VBA String Functions
strictly informational attributes, Redundancy, Second Normal Form
String data types, String Data Type
String function, VBA String Functions
strings
comparing, VBA String Functions
converting to number, VBA String Functions
formatting, The Format Function
string constants and, Constants
structured attributes, First Normal Form
Structured Query Language (see SQL)
subqueries, Access Query Types, Subqueries–Notes, Some Common Data Manipulation Problems
subroutines, declaring, Calling Subroutines
subschemes (see views)
subsets of tables
projection and, Projection
selection (restriction) of, Selection–Selection
suffixes, Variable Declaration
superkeys, Keys and Superkeys, A Short Glossary
functional dependency and, Functional Dependencies
Supports method, Methods of the Recordset object
Switch function, The Switch Function
symbolic constants, Constants
syntax conventions, Syntax Conventions
syntax errors, checking for, Design-Time and Compile-Time Errors
system data sources, Machine data sources
system modal dialog box, The MsgBox Function

T

table schemes, Implementing Entity Classes—Table Schemes, Why Program?
attributes of, Redundancy
decomposing, Decomposition–Decomposition
normal forms for, Normal Forms–Boyce-Codd Normal Form
table-type Recordset objects, Recordset Objects, Finding Records in a Table-Type Recordset
TableDef objects, Say It Again, TableDefs, Collections
tables, Implementing Entity Sets—Tables, A Short Glossary
ALTER TABLE command and, The ALTER TABLE Statement
base, Query Languages
Cartesian product of, Cartesian Product
CREATE TABLE command and, The CREATE TABLE Statement–Notes
creating in DAO, Creating a Table and Its Fields–Note
degree of, Implementing Entity Sets—Tables, Union
deleting or deleting from, The DROP Statement, The DELETE Statement
derived, Query Languages
difference of, Difference–Difference
inserting data into other, The SELECT...INTO Statement
intersection of, Intersection
joins and, Joins–Implementing Joins in Microsoft Access, Joins–Notes
optimization and, Optimization
printing list of, The Microsoft Jet 3.51 OLE DB Provider
projection of, Projection
quotients of, The Quotient: An Additional Operation of the Relational Algebra–Step 3
relationships between, Nested joins
result, Query Languages
rows, inserting into, The INSERT INTO Statement
selection (restriction) and, Selection–Selection
semi-joins and, Semi-Joins–Semi-Joins
union of, Union–Union, Access Query Types, The UNION Statement
updating, The UPDATE Statement
virtual (see views)
Tables collection, The Tables Collection
Tables container, Containers
tabular format, Data Providers, The Recordset Object
text files
connecting to ODBC provider, Connecting to a text file–Connecting to a text file
creating, File-Related Functions
sample DSNs and, Text-system data source
theta-joins, θ-Join, Implementing Joins in Microsoft Access, Inner joins
third normal form (3NF), Third Normal Form
three-tier structure, Database Systems
time, Date Data Type, Date- and Time-Related Functions
time to completion, Time to Completion I–Solution 2
TOP option (SELECT statement), Predicate
tracing, Debugging–Breaking out of Debug mode
TRANSFORM statement, TRANSFORM–TRANSFORM
Trim function, VBA String Functions
trivial/nontrivial dependency, Functional Dependencies
type conversion functions, VBA String Functions
Type property (ADO), The Property Object and Dynamic Properties, Properties of the Field object
Type property (DAO), Property: Type
type-declaration suffixes, Variable Declaration
types (see data types)
recordset, ODBC support
Type property and, Notes

U

UBound function, The UBound function
UCase function, VBA String Functions
UnderlyingValue property (ADO), Properties of the Field object
underscore, for line continuation, Line Continuation
union of tables, Union–Union, The UNION Statement
union queries and, Access Query Types
UNION statement, The UNION Statement
unique indexes, Index Files
Unique property, Creating an Index
update anomalies, Update anomalies
Update method, Editing an Existing Record, Adding a New Record, Methods of the Recordset object
UPDATE statement, The UPDATE Statement
updates
cascading, Cascading Updates and Cascading Deletions
record, Editing an Existing Record
updatable queries and, Access Query Types, Updatable Queries, The UPDATE Statement
URLs
MDAC, Installing ADO
for this book, Obtaining Updated Information
user data sources, Machine data sources
user-defined collections, Properties and Methods of User-Defined Collections
user-defined properties, User-Defined Properties
User objects, Users, Collections
users
beeping, The Beep Statement
displaying messages to, The MsgBox Function–The MsgBox Function
event procedures and, The Calls Stack
getting input from, The InputBox Function, The SQLConnect Function, SQLDriverConnect

V

Val function, VBA String Functions
ValidationRule and ValidationText properties, Note
Value property (ADO), The Property Object and Dynamic Properties, Properties of the Field object
Value property (DAO), Property: Value
values, NULL values and, Insertion anomalies, NULL Values
variable counter, The For Loop–The Do Loop
variable-length string variables, String Data Type
variables, Variables and Data Types
changing value of, ByRef Versus ByVal Parameters
declaring, Variable Declaration
initialized, Variable Initialization, The IsEmpty function
IsNull function and, The IsNull function
lifetime of, Variable Lifetime–Static variables
naming conventions for, Variable Naming Conventions, Object-Variable Naming Conventions
object, Object Variables–Object-Variable Naming Conventions, Using Object Variables to Your Advantage
naming, Object-Variable Naming Conventions
object
vs. standard, Object Variables
pointer, Object Variables
scope of, Variable Scope
VBA string functions for, VBA String Functions–VBA String Functions
Variant data types, Variable Declaration, Variant Data Type
variants, Variable Declaration, Variant Data Type
vb symbolic constants, Constants
VBA data types, list of, Variables and Data Types
VBA operators/relations, VBA Operators
VBA (Visual Basic for Applications), Why Program?, The Jet DBMS, The Visual Basic Editor, Part I
built-in functions and statements for, Built-in Functions and Statements–VBA String Functions
control statements for, Control Statements–A Final Note on VBA
debugging, Debugging–Breaking out of Debug mode
help files for, Getting Help
using for further study, A Final Note on VBA
miscellaneous functions and statements for, Miscellaneous Functions and Statements–The Beep Statement
procedures for, Standard modules
programs and, Entering and Running the Sample Programs
readability of, Variable Naming Conventions
resources for further reading, A Final Note on VBA
rules for initializing variables and, Variable Initialization
string functions for, VBA String Functions–VBA String Functions
Version property, Properties of the Connection object
viewing
data vertically/horizontally, Vertical to Horizontal–Solution
objects, The Object and Procedure Listboxes
output, The Immediate Window
procedures, Procedure and Full-Module Views
split-screen, Docking
views, Creating views, Query Languages, Database Systems
virtual tables, Query Languages
Visual Basic
resources for further reading, Class modules
using to obtain ODBC information, Getting ODBC Information Using Visual Basic–Getting Data Sources
Visual Basic Editor, The Visual Basic Editor, Part I
keyboard shortcuts for, Navigating the IDE
Visual Basic for Applications (see VBA)

W

watch statement, Run Mode, Break Mode, and Design Mode
Web, using ADO over, An Example: Using ADO over the Web–An Example: Using ADO over the Web
WHERE clause
SELECT statement and, The SELECT Statement, WHERE RowCondition
UPDATE statement and, The UPDATE Statement
windows, docked/floating, Docking
Workspace objects, The DAO Object Model, Closing DAO Objects, Workspaces, Collections
write-only properties, Types of Properties
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.21.93.168