DAO Glossary

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

A

action query

ActiveX object

aggregate function

alias

ANSI character set

append query

argument

array

ASCII character set

asterisk

asynchronous query

AutoNumber data type

AutoNumber field

B

base computer

base table

batch optimistic updating

Big Integer data type

binary data type

bookmark

Boolean data type

Boolean expression

byte data type

C

Cartesian product

cascade

cascading delete

cascading update

case-sensitive

Char data type

class

client batch cursor library

clustered index

collection

collision

column

commit

compound query

conflict table

connection string

consistent

constant

constraint

control character

copy buffer

criteria

crosstab query

current database

Currency data type

current index

current record

current transaction

D

data access object

Data Access Objects (DAO)

database engine

database replication

data-definition query

data pipelining

data source

data type

date literal

dates and times

Decimal data type

DDL (Data Definition Language)

default synchronization partner

default synchronization schedule

default workspace

delete query

Design Master

design time

destination field

direct synchronization

DLL (dynamic-link library)

Double data type

dropbox folder

dynamic cursor

dynaset

E

equi-join

exclusive

expression

external database

external table

F

field

field data types

field properties

filter

Float data type

foreign key

foreign table

form

forward-only cursor

forward-only–type Recordset

forward scroll

FTP

Function procedure

G

globally unique identifier (GUID)

group

GUID data type

H

HTTP

hub server

hyperlink data type

I

inconsistent

index

indirect synchronization

inner join

installable ISAM

instance

Integer data type

Internet

intranet

intrinsic constant

J

join

K

keyset cursor

L

left join

left outer join

linked table

local object

locked

Long Binary data type

Long data type

M

make table query

managed replicas

many-only table

Memo data type

message

method

Microsoft Jet-connected ODBC data source

Microsoft Jet database

Microsoft Jet database engine

Microsoft Jet workspace

Microsoft Replication Manager

multiuser database

N

Numeric data type

normalize

Null

null field

numeric expression

O

Object Browser

object expression

object library

object replication

object variable

ODBC (Open Database Connectivity)

ODBC data source

ODBCDirect

ODBCDirect data source

ODBCDirect workspace

ODBC driver

ODBC Driver Manager

OLE

OLE Object data type

on-demand synchronization

one-to-many relationship

one-to-one relationship

optimistic

outer join

P

page

parameter

parameter query

parse

partial replica

pass-through query

permission

persistent object

personal identifier (PID)

pessimistic

primary key

primary table

procedural query

property

pseudo index

Q

query

R

read-only

record

referential integrity

relationship

replica

replica set

replica set member

replica set topology

replicated database

replicate

replicated object

replication

requery

reserved word

right join

right outer join

row

run-time error

retention period

S

satellite computer

schedule

scheduled synchronization

scope

secure workgroup

security

select query

self-join

server

server-side cursor

session

shared network folder

Short data type

Single data type

snapshot

sort order

SQL-specific query

SQL statement/string

standard deviation

standard naming conventions

star topology

static cursor

string comparison

String data type

string expression

Structured Query Language (SQL)

subquery

synchronization

synchronization conflict

synchronization error

synchronization window

synchronizer

syntax error

system object

T

table

TEMP

temporary disk

Text data type

Time data type

TimeStamp data type

transaction

U

union query

unmanaged replica

update

update query

user account

V

validation

validation properties

validation rule

VarBinary data type

variable

variance

Variant data type

variant expression

W

wildcard characters

workgroup

workgroup administrator

X

Y

Z

zero-length string