Places the element relative to either the element's parent or, if there isn't one, the body. Values for the element's Left and Top properties are relative to the upper-left corner of the element's parent.
An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.
The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.
Additional information required by some macro actions. For example, the object affected by the action or special conditions under which the action is carried out.
The list that appears when you click the arrow in the Action column of the Macro window.
A query that copies or changes data. Action queries include append, delete, make-table, and update queries. They are identified by an exclamation point (!) next to their name in the Database window.
A row in the upper part of the Macro window in which you enter macro names, actions, conditions, and comments associated with a particular macro or macro group.
A Microsoft Access project (.adp) file with all modules compiled and all editable source code removed.
The default user account. When you install Access, the Setup program automatically includes the Admin user account in the workgroup information file it creates.
The system administrator's group account that retains full permissions on all databases used by a workgroup. The Setup program automatically adds the default Admin user account to the Admins group.
Advanced Filter Sort
A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria.
A function, such as Sum, Count, Avg, or Var, that you use to calculate totals.
In an Access database, a special type of replica in which you don't keep track of individual users. The anonymous replica is particularly useful in an Internet situation where you expect many users to download replicas.
ANSI SQL Query Mode
One of two types of SQL syntax: ANSI-89 SQL (also called Microsoft Jet SQL and ANSI SQL), which is the traditional Jet SQL syntax; and ANSI-92 SQL, which has new and different reserved words, syntax rules, and wildcard characters.
An action query that adds the records in a query's result set to the end of an existing table.
The background area of an application window. In Access, this is the screen area behind the Database window or any other open windows, but contained within the Access application window.
An action that establishes a connection to data from another application so that you can view and edit the data in both the original application and in Access.
A table stored in a file outside the open database from which Access can access records. You can add, delete, and edit records in a linked table, but you can't change its structure.
A collection of formats that determines the appearance of the controls and sections in a form or report.
In a Microsoft Access database, a field data type that automatically stores a unique number for each record as it's added to a table. Three kinds of numbers can be generated: sequential, random, and Replication ID.
Filtering data in PivotTable or PivotChart view by selecting one or more items in a field that allows filtering.
A link from an OLE object in Access to an OLE server that automatically updates the object in Access when the information in the object file changes.
Bigint Data Type
In an Access project, a data type of 8 bytes (64 bits) that stores whole numbers in the range of -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).
Binary Data Type
In an Access project, a fixed-length data type with a maximum of 8,000 bytes of binary data.
Bit Data Type
In an Access project, a data type that stores either a 1 or 0 value. Integer values other than 1 or 0 are accepted, but are always interpreted as 1.
A value used with bit-wise operators (And, Eqv, Imp, Not, Or, and Xor) to test, set, or reset the state of individual bits in a bit-wise field value.
The basic design surface of a data access page. It displays informational text, controls bound to data, and sections.
A property of a Recordset object or a form that contains a binary string identifying the current record.
The column in a list box, combo box, or drop-down list box that's bound to the field specified by the control's ControlSource property.
A control used on a form, report, or data access page to display or modify data from a table, query, or SQL statement. The control's ControlSource property stores the field name to which the control is bound.
Bound HTML Control
A control used on a data access page to bind HTML code to a Text or Memo field in an Access database or to a text, ntext, or varchar column in an Access project. You cannot edit the contents of a bound span control.
Bound Hyperlink Control
A control used on a data access page to bind a link, an intranet address, or an Internet address to an underlying Text field. You can click the hyperlink to navigate to the target location.
Bound Object Frame
A control on a form or report used to display and manipulate OLE objects that are stored in tables.
A control used on a form, report, or data access page to bind an image to an OLE Object field in an Access database or an image column in an Access project.
An Access tool that simplifies a task. For example, you can quickly create a complex expression with the Expression Builder.
A toolbar that is part of Access when it's installed on your computer. In contrast, a custom toolbar is one you create for your own application.
Byte Data Type
An Access database data type used to hold small positive integers ranging from 0 to 255.
A control used on a form, report, or data access page to display the result of an expression. The result is recalculated each time there is a change in any of the values that the expression is based on.
A field, defined in a query, that displays the result of an expression rather than displaying stored data. The value is recalculated each time a value in the expression changes.
All modules that might be called by any procedure in the module in which code is currently running.
The section on a grouped data access page that displays captions for columns of data. It appears immediately before the group header. You cannot add a bound control to a caption section.
For relationships that enforce referential integrity between tables, the deletion of all related records in the related table or tables when a record in the primary table is deleted.
For relationships that enforce referential integrity between tables, the updating of all related records in the related table or tables when a record in the primary table is changed.
A sequence of events caused by an event procedure directly or indirectly calling itself; also called an event cascade or a recursion. Be careful using cascading events, because they often result in stack-overflow or other run-time errors.
A field displayed in the category area of PivotChart view. Items in a category field appear as labels on the category axis.
An integer that corresponds to an open Dynamic Data Exchange (DDE) channel. Channel numbers are assigned by Microsoft Windows 95 or later, created with the DDEInitiate function, and used by other DDE functions and statements.
Char Data Type
In an Access project, a fixed-length data type with a maximum of 8,000 ANSI characters.
A control that indicates whether an option is selected. A check mark appears in the box when the option is selected.
A module that can contain the definition for a new object. Each instance of a class creates a new object. Procedures defined in the module become properties and methods of the object. Class modules can exist alone or with forms and reports.
The name used to refer to a class module. If the class module is a form or report module, the class name is prefaced with the type of module. For example, Form_OrderForm.
Class Name OLE
A predefined name, used to refer to an OLE object in Visual Basic. It consists of the name of the application used to create the OLE object, the object's type, and, optionally, the version number of the application. Example: Excel.Sheet
A segment of Visual Basic code that defines the beginning and end of a procedure.
A location within a database table that stores a particular type of data. It is also the visual representation of a field in a datasheet, and in an Access database, the query design grid or the filter design grid.
The part of PivotTable view that contains column fields.
A field in the column area of PivotTable view. Items in column fields are listed across the top of a PivotTable list. Inner column fields are closest to the detail area; outer column fields are above the inner column fields.
The horizontal bar at the top of a column. You can click a column selector to select an entire column in the query design grid or the filter design grid.
A control used on a form that provides the combined functionality of a list box and a text box. You can type a value, or click the control to display a list and select an item from the list.
A control that runs a macro, calls a Visual Basic function, or runs an event procedure. This is sometimes called a push button in other applications.
An operator used to compare two values or expressions; For example, < (less than), > (greater than), and = (equal to).
A control and an attached label, such as a text box with an attached label.
Filtering a field to show the top or bottom n items based on a total. For example, you could filter for the three cities that generated the most sales or the five products that are least profitable.
Formatting the contents of a control in a form or report based on one or more conditions. A condition can reference another control, the control with focus, or a user-defined Visual Basic for Applications function.
Can occur if data has changed in the same record of two replica set members. When a conflict occurs, a winning change is selected and applied in all replicas, and the losing change is recorded as a conflict at all replicas.
A string expression used to open an external database.
A restriction placed upon the value that can be entered into a column or a row. For example, values in the Age column cannot be less than 0 or greater than 110.
An application that contains a linked or embedded OLE object from another application. For example, if an OLE object in an Access database contains a Microsoft Excel worksheet, Access is the OLE container.
A form that displays more than one record on the screen in Form view.
Control Containing Hyperlink
A control that makes it possible for a user to jump to a document, Web page, or object. For example, a text box bound to a field that contains hyperlinks.
A query that calculates a sum, average, count, or other type of total on records, and then groups the result by two types of information: one down the left side of the datasheet and the other across the top.
Currency Data Type
In a Microsoft Access database, a data type that is useful for calculations involving money or for fixed-point calculations in which accuracy is extremely important.
The record in a recordset that you can modify or retrieve data from. There is only one current record in a recordset, but a recordset may have no current record, for example, after a record has been deleted from a dynaset-type recordset.
Cursor Data Type
In an Access project, a data type you can only use for creating a cursor variable. This data type cannot be used for columns in a table. A cursor is a mechanism used to work with one row at a time in the result set of a SELECT statement.
An item of a custom group field. A custom group contains two or more items from a row or column field.
A field in the row or column area that contains custom groups as its items.
User-defined sort order. For example, you could define a custom sort order to display values in the EmployeeTitle column on the basis of the title's seniority.
Custom Properties Dialog
A custom property sheet that allows users to set properties for an ActiveX control.
A toolbar that you create for your application. In contrast, a built-in toolbar is part of Access when it's installed on your computer.
Data Access Page Properties
Attributes of a data access page that identify the database the page is connected to and define the page's appearance and behavior.
Data Access Page Window
The window that displays data access pages in Design view and Page view.
The part of PivotTable or PivotChart view that contains summary data. Values in the data area are displayed as records in PivotTable view and as data points in PivotChart view.
The fields in underlying tables and queries, and the expressions, that make up the record source for a data access page.
A field that contains summarized data in PivotTable or PivotChart view. A data field usually contains numeric data.
An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.
An application-specific piece of data that can be transferred over a DDE channel.
A label that provides additional information about a data marker, which represents a single data point or value.
A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value. Related data markers in a chart constitute a data series.
A window that you can display when a data access page is open in Design view. The data outline provides a tree view of the data model of a page. You can select and set properties of the elements displayed in the window.
Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart.
Data Source Control
The engine behind data access pages and Microsoft Office Web Components that manages the connection to the underlying data source. The data source control has no visual representation.
A graphical representation of any portion of a database schema. It can be either a whole or partial picture of the structure of the database. It includes tables, the columns they contain, and the relationships between the tables.
An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.
The process of creating two or more special copies (replicas) of an Access database. Replicas can be synchronized changes made to data in one replica, or design changes made in the Design Master, are sent to other replicas.
The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.
A SQL-specific query that contains data definition language (DDL) statements. These statements allow you to create or alter objects in the database.
Data from a table, form, query, view, or stored procedure displayed in a row-and-column format.
A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.
Date Data Type
An Access database data type used to hold date and time information.
Datetime Data Type
In an Access project, a date and time data type that ranges from January 1, 1753, to December 31, 9999, to an accuracy of three-hundredths of a second, or 3.33 milliseconds.
Decimal Data Type
An exact numeric data type that holds values from -10^38 - 1 through 10^38 - 1. You can specify the scale (maximum total number of digits) and precision (maximum number of digits to the right of the decimal point).
Decimal Data Type Microsoft Access Database
An exact numeric data type that holds values from -10^28 - 1 through 10^28 - 1. You can specify the scale (maximum number of digits) and precision (maximum total number of digits to the right of the decimal point).
The section of a module containing declarations that apply to every procedure in the module. It can include declarations for variables, constants, user-defined data types, and external procedures in a dynamic-link library.
A property that you can set for a control so that each time a new control of that type is created, this property will have the same value.
A value that is automatically entered in a field or control when you add a new record. You can either accept the default value or override it by typing a value.
A query (SQL statement) that removes rows matching the criteria you specify from one or more tables.
The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.
A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.
The part of PivotTable view that contains detail and total fields.
A field that displays all rows, or records, from the underlying record source.
Used to contain the main body of a form or report. This section usually contains controls bound to the fields in the record source, but can also contain unbound controls, such as labels that identify a field's contents.
A method used to synchronize data between replicas that are connected directly to the local area network and are available through shared network folders.
A control that appears dimmed on a form or data access page. A disabled control cannot get the focus and will not respond to mouse clicks.
A set of routines that can be called from Visual Basic procedures and are loaded and linked into your application at run time.
Properties, such as title, subject, and author, that are stored with each data access page.
A set of records defined by a table, a query, or an SQL expression. Domain aggregate functions return statistical information about a specific domain or set of records.
A function, such as DAvg or DMax, that is used to calculate statistics over a set of records (a domain).
An area in PivotTable or PivotChart view where you can drop fields from the field list to display the data in the field. The labels on each drop area indicate the types of fields you can create in the view.
Drop-down List Box
A control on a data access page that, when clicked, displays a list from which you can select a value. You cannot type a value in a drop-down list box.
The process of Access updating or repainting the screen while a macro is running.
Also known as a text box, an edit control is a rectangular window in which a user can enter and edit text.
To insert a copy of an OLE object from another application. The source of the object, called the OLE server, can be any application that supports object linking and embedding. Changes to an embedded object are not reflected in the original object.
A previous-version database that has been opened in Access 2000 or later without converting its format. To change the design of the database, you must open it in the version of Access in which it was created.
A type of access to data in a database shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.
A control on a data access page that, when clicked, expands or collapses a grouped record to display or hide its detail records.
A button that is used to expand or collapse groups of records; it displays the plus (+) or minus (-) sign.
To output data and database objects to another database, spreadsheet, or file format so another database or program can use the data or database objects. You can export data to a variety of supported databases, programs, and file formats.
An Access tool you can use to create an expression. It includes a list of common expressions that you can select.
The source of the table that is to be linked or imported to the current database, or the destination of a table that is to be exported.
A table outside the open Access database or Access project.
Field Data Type
A characteristic of a field that determines what kind of data it can store. For example, a field whose data type is Text can store data consisting of either text or number characters, but a Number field can only store numerical data.
A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.
A small box or bar that you click to select an entire column in a datasheet.
A report magnification that fills the Report Snapshot window by fitting either the width or the height of a page, depending on whether the report is in portrait or landscape orientation.
A set of criteria applied to data in order to display a subset of the data or to sort the data. In Access, you can use filtering techniques, such as Filter By Selection and Filter By Form to filter data.
The part of PivotTable or PivotChart view that contains filter fields.
Filter By Form
A technique for filtering data that uses a version of the current form or datasheet with empty fields in which you can type the values you want the filtered records to contain.
Filter By Selection
A technique for filtering records in a form, datasheet, or data access page in which you retrieve only records that contain the selected value.
Filter Excluding Selection
A technique in which you filter records in a form, datasheet, or data access page to retrieve only those records that don't contain the selected value.
A field in the filter area that you can use to filter data displayed in PivotTable or PivotChart view. Filter fields perform the same functions as page fields in Microsoft Excel PivotTable reports.
Filter For Input
A technique for filtering records that uses a value or expression you enter to find only records that contain the value or satisfy the expression.
A file containing data where each field has a fixed width.
Float Data Type
In an Access project, an approximate numeric data type with 15-digit precision. It can hold positive values from approximately 2.23E - 308 through 1.79E + 308, negative values from approximately -2.23E - 308 through -1.79E + 308, or zero.
Able to move freely as its own window. A floating window is always on top. Toolbars, menu bars, the toolbox, and palettes can float.
One or more table fields (columns) that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related.
A table (such as Customer Orders) that contains a foreign key field (such as CustomerID) that's the primary key field in another table (such as Customers) in the database, and that is usually on the "many" side of a one-to-many relationship.
An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.
Use to display instructions for using a form, command buttons, or unbound controls to accept input. Displays at the bottom of the form in Form view and at the end of a printout.
Use to display a title for a form, instructions for using it, or command buttons that open related forms or carry out other tasks. Displays at the top of the form in Form view and at the beginning of a printout.
A module that includes code for all event procedures triggered by events occurring on a specific form or its controls.
Attributes of a form that affect its appearance or behavior. For example, the DefaultView property is a form property that determines whether a form will automatically open in Form view or Datasheet view.
The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form.
A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.
A window in which you work with forms in Design view, Form view, Datasheet view, or Print Preview.
Specifies how data is displayed and printed. An Access database provides standard formats for specific data types, as does an Access project for the equivalent SQL data types. You can also create custom formats.
An application consisting of a "back-end" database file that contains tables, and copies of a "front-end" database file that contain all other database objects with links to the "back-end" tables.
A query that takes input parameters and returns a result like a stored procedure. Types: scalar (multistatement; returns one value), inline (one statement; an updateable table value), and table (multistatement; table value).
A procedure that returns a value and that can be used in an expression. You declare a function with the Function statement and end it with the End Function statement.
General Sort Order
The default sort order determines how characters are sorted in the entire database, such as in tables, queries, and reports. Define General sort order if you plan to use a database with multiple language editions of Access.
Global Menu Bar
A special custom menu bar that replaces the built-in menu bar in all windows in your application, except where you've specified a custom menu bar for a form or report.
A replica in which changes are fully tracked and can be exchanged with any global replica in the set. A global replica can also exchange changes with any local or anonymous replicas for which it becomes the hub.
Global Shortcut Menu
A custom shortcut menu that replaces the built-in shortcut menu for the following objects: fields in table and query datasheets; forms and form controls in Form view, Datasheet view, and Print Preview; and reports in Print Preview.
A variable you declare with the Public keyword in the Declarations section of a module. A public variable can be shared by all the procedures in every module in a database.
A graphical representation of data in a form, report, or data access page.
An arrangement of vertical and horizontal dotted and solid lines that help you position controls precisely when you design a form, report, or data access page.
Grid Datasheet View
Vertical and horizontal lines that visually divide rows and columns of data into cells in a table, query, form, view, or stored procedure. You can show and hide these grid lines.
Two or more controls that can be treated as one unit while designing a form or report. You can select the group instead of selecting each individual control as you're arranging controls or assigning properties.
A collection of user accounts in a workgroup, identified by group name and personal ID (PID). Permissions assigned to a group apply to all users in the group.
Group Filter Control
A drop-down list box control on a data access page that retrieves records from an underlying recordset based on the value you select from the list. On a grouped page, the control retrieves a specific group of records.
Use to place information, such as group name or group total, at the end of a group of records.
Use to place information, such as group name or group total, at the beginning of a group of records.
The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.
Grouped Data Access Page
A data access page that has two or more group levels.
A 16-byte field used in an Access database to establish a unique identifier for replication. GUIDs are used to identify replicas, replica sets, tables, records, and other objects. In an Access database, GUIDs are referred to as Replication IDs.
A unique Integer value (Long in a 32-bit environment) you use to identify and access a Form or Report window. Use the hWnd property to return the handle.
A control used on a data access page to display an unbound image that represents a hyperlink to a file or Web page. In Browse mode, you can click the image to navigate to the target location.
A global replica that all replicas in the replica set synchronize their changes to. The hub serves as the parent replica.
The path to a destination such as an object, document, or Web page. A hyperlink address can be a URL (address to an Internet or intranet site) or a UNC network path (address to a file on a local area network).
Hyperlink Data Type
A data type for an Access database field that stores hyperlink addresses. An address can have up to four parts and is written using the following format: displaytext#address#subaddress#.
A field that stores hyperlink addresses. In an Access database (.mdb), it's a field with a Hyperlink data type. In an Access project (.adp), it's a field that has the IsHyperlink property set to True.
IDC HTX files
Microsoft Internet Information Server uses an IDC file and an HTX file to retrieve data from an ODBC data source and format it as an HTML document.
An element of an expression that refers to the value of a field, control, or property. For example, Forms![Orders]![OrderID] is an identifier that refers to the value in the OrderID control on the Orders form.
A control that is used to display a picture on a form, report, or data access page.
Image OLE Object Data Type
In an Access project, a variable-length data type that can hold a maximum of 2^31 - 1 (2,147,483,647) bytes of binary data. It is used to store BLOBs (Binary Large Objects), such as pictures, documents, sounds, and compiled code.
To copy data from a text file, spreadsheet, or database table into an Access table. You can use the imported data to create a new table, or you can append (add) it to an existing table that has a matching data structure.
Import Export Spec
A specification that stores the information Access needs to import or export a fixed-width or delimited text file.
A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows in a table. The primary key of a table is automatically indexed. Some fields can't be indexed because of their data type.
In an Access database, a window in which either you can view or edit a table's indexes or you can create multiple-field indexes.
A synchronization method used in a disconnected environment, such as when you travel with a portable computer.
Activation of an OLE object's OLE server from within a field or control. For example, you can play a waveform audio (.wav) file contained in a control by double-clicking the control.
A format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed.
An object created from the class that contains its definition. For example, multiple instances of a form class share the same code and are loaded with the same controls that were used to design the form class.
Int Data Type
In an Access project, a data type of 4 bytes (32 bits) that stores whole numbers in the range of -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
Integer Data Type
A fundamental data type that holds integers. An Integer variable is stored as a 16-bit (2-byte) number ranging in value from -32,768 to 32,767.
Used to synchronize replicas in a disconnected environment in which an Internet server is configured.
A constant supplied by Access, VBA, ADO, or DAO. These constants are available in the Object Browser by clicking globals in each of these libraries.
A unique element of data within a field. When a lower level of items is available for display in a PivotTable list or the field list, an expand indicator (+) appears beside the item.
Jet Replication Objects (JRO)
A set of automation interfaces that you can use to perform actions specific to Microsoft Jet databases. Using JRO, you can compact databases, refresh data from the cache, and create and maintain replicated databases.
Code that determines and responds to keys or key combinations pressed by the user.
A control that displays descriptive text, such as a title, a caption, or instructions, on a form, report or data access page. Labels might or might not be attached to another control.
A preview of a report that uses a minimum amount of data to display the general layout of the report. Click Print Preview to display the exact data that appears in the report.
Left Outer Join
An outer join in which all the records from the left side of the LEFT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the right.
A box that identifies the patterns or colors assigned to data series or categories in a chart.
A collection of procedures and database objects that you can call from any application. In order to use the items in the library, you must first establish a reference from the current database to the library database.
A connection between an OLE object and its OLE server, or between a dynamic data exchange (DDE) source document and a destination document.
The sequence of numbers for items in a list, starting with 0 for the first item, 1 for the second item, and so forth.
A table, query, form, report, macro, or module that remains in the replica or Design Master where it was created. Neither the object nor changes to the object are copied to other members in the replica set.
A replica that exchanges data with its hub or a global replica, but not with other replicas in the replica set.
The condition of a record, recordset, or database that makes it read-only to all users except the user currently modifying it.
A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.
An action or set of actions you can use to automate tasks.
A collection of related macros that are stored together under a single macro name. The collection is often referred to simply as a macro.
A form that contains one or more subforms.
Make Table Query
A query (SQL statement) that creates a new table and then creates records (rows) in it by copying records from an existing table.
A link that requires you to take action to update your data after the data in the source document changes.
An association between two tables in which one record in either table can relate to many records in the other table. To establish one, create a third table and add the primary key fields from the other two tables to this table.
Moving text used on a data access page to draw the user's attention to a specific page element, such as a headline or an important announcement. To place a marquee on a page, create a scrolling text control.
Maximum Record Limit
To improve performance, you can specify the maximum number of records that will be retrieved from a Microsoft SQL Server database for a form or datasheet in an Access project.
Microsoft Access database (.mdb) file with all modules compiled and all editable source code removed.
Memo Data Type
Memo data type: In a Microsoft Access database, this is a field data type. Memo fields can contain up to 65,535 characters.
Microsoft Access Database
A collection of data and objects, such as tables, queries, or forms, related to a particular topic or purpose. The Microsoft Jet database engine manages the data.
Microsoft Access Object
An object defined by Access that relates to Access, its interface, or an application's forms, reports, and data access pages, and that you use to program the elements of the interface used for entering and displaying data.
Microsoft Data Engine (MSDE)
A client/server data engine that provides local data storage on a smaller computer system, such as a single-user computer or small workgroup server, and is compatible with Microsoft SQL Server 7.0.
Microsoft Jet Database Engine
The part of the Access database system that retrieves and stores data in user and system databases. It can be thought of as a data manager upon which database systems, such as Access, are built.
Microsoft SQL Server Database
A database in Microsoft SQL Server, it consists of tables, views, indexes, stored procedures, functions, and triggers.
Describes any variable or constant declared in the Declarations section of a module or outside a procedure. Variables or constants declared at the module level are available to all procedures in a module.
Module Level Variable
A variable that's declared in the Declarations section of a module by using the Private keyword. These variables are available to all procedures in the module.
Money Data Type
In an Access project, a data type that stores monetary values in the range -922,337,203,685,477.5707 through 922,337,203,685,477.5807, with accuracy to a ten-thousandth of a monetary unit.
The large square displayed in the upper-left corner of the selected control in Design view. You can click and move the handle to move the control to another location.
The mode in which you can move column(s) in Datasheet view by using the left and right arrow keys.
A database that permits more than one user to access and modify the same set of data at the same time.
Name Auto Correct
A feature that automatically corrects common side effects that occur when you rename forms, reports, tables, queries, or fields, or controls on forms and reports. However, Name AutoCorrect cannot repair all references to renamed objects.
The buttons that you use to move through records. They are located in the lower-left corner of the Datasheet view and Form view windows. They are also available during previewing so that you can move through the pages of your document.
Nchar Data Type
In an Access project, a fixed-length data type with a maximum of 4,000 Unicode characters. Unicode characters use 2 bytes per character and support all international characters.
To minimize the duplication of information in a relational database through effective table design. You can use the Table Analyzer Wizard to normalize your database.
Ntext Data Type
In an Access project, a variable-length data type that can hold a maximum of 2^30 - 1 (1,073,741,823) characters. Columns with the ntext data type store a 16-byte pointer in the data row, and the data is stored separately.
A value you can enter in a field or use in expressions or queries to indicate missing or unknown data. In Visual Basic, the Null keyword indicates a Null value. Some fields, such as primary key fields, can't contain Null.
A field containing a Null value. A null field isn't the same as a field that contains a zero-length string ("") or a field with a value of 0.
Number Data Type
Number data type: In a Microsoft Access database, a field data type designed for numerical data that will be used in mathematical calculations. Use the Currency data type, however, to display or calculate currency values.
Numeric Data Type
In an Access project, an exact numeric data type that holds values from -10^38 - 1 through 10^38 - 1. You can specify the scale (maximum total number of digits) and precision (maximum number of digits to the right of the decimal point).
Nvarchar Data Type
In an Access project, a variable-length data type with a maximum of 4,000 Unicode characters. Unicode characters use 2 bytes per character and support all international characters.
An application or DLL that supplies a linked or embedded OLE object to another application. For example, if an OLE object in an Access database contains a Microsoft Excel worksheet, Excel is the OLE server.
Object Data Type
A fundamental data type representing any object that can be recognized by Visual Basic. Although you can declare any object variable as type Object, it's best to declare object variables according to their specific type.
A file that contains definitions of objects and their methods and properties. The file that contains an object library typically has the extension .olb.
ODBC Connect String Builder
An Access tool you can use to connect to an SQL database when you create a pass-through query. If you save the query, the connection string is stored with the query.
ODBC Data Source
Data and the information needed to access that data from programs and databases that support the Open Database Connectivity (ODBC) protocol.
A database for which an Open Database Connectivity (ODBC) driver that you can use for importing, linking to, or exporting data is supplied.
A technology that allows you to access ODBC data sources directly by using DAO features that bypass the Microsoft Jet database engine.
An object supporting the OLE protocol for object linking and embedding. An OLE object from an OLE server, for example, a Windows Paint picture or a Microsoft Excel spreadsheet can be linked or embedded in a field, form, or report.
OLE Object Data Type
A field data type you use for objects created in other applications that can be linked or embedded (inserted) in an Access database.
A component database architecture that provides efficient network and Internet access to many types of data sources, including relational data, mail files, flat files, and spreadsheets.
A program in the OLE DB architecture that enables native access to data, instead of accessing data using ODBC or IISAM drivers, which are external ways to access the data.
An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.
An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of one and only one record in the related table.
A control, also called radio button, that is typically used as part of an option group to present alternatives on a form, report, or data access page. The user cannot select more than one option.
A frame that can contain check boxes, toggle buttons, and option buttons on a form, report, or data access page. You use an option group to present alternatives from which the user can select a single option.
A join in which each matching record from two tables is combined into one record in the query's results, and one table contributes all of its records, even if the values in the joined field don't match those in the other table.
When security is being used, the user account that has control over a database or database object. By default, the user account that created a database or database object is the owner.
A portion of the database (.mdb) file in which record data is stored. Depending on the size of the records, a page (4 KB in size) may contain more than one record.
Use to display page summaries, dates, or page numbers at the bottom of every page in a form or report. In a form, the page footer appears only when you print the form.
Use to display a title, column headings, dates, or page numbers at the top of every page in a form or report. In a form, the page header appears only when you print the form.
An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later.
A query in which a user interactively specifies one or more criteria values. A parameter query is not a separate kind of query; rather, it extends the flexibility of a query.
A database that contains only a subset of the records in a full replica. With a partial replica, you can set filters and identify relationships that define which subset of the records in the full replica should be present in the database.
Pass Through Query
An SQL-specific query you use to send commands directly to an ODBC database server. By using pass-through queries, you work directly with the tables on the server instead of having the Microsoft Jet database engine process the data.
A set of attributes that specify what kind of access a user has to data or objects in a database.
A case-sensitive alphanumeric string 4 to 20 characters long that Access uses in combination with the account name to identify a user or group in an Access workgroup.
A view that shows a graphical analysis of data in a datasheet or form. You can see different levels of detail or specify the layout by dragging fields and items, or by showing and hiding items in the drop-down lists for the fields.
An interactive table that summarizes large amounts of data by using format and calculation methods that you choose. You can rotate its row and column headings to view the data in different ways, similar to an Excel PivotTable report.
A Microsoft Office Web Component used to analyze data interactively on a Web page. Data displayed in a row and column format can be moved, filtered, sorted, and calculated in ways that are meaningful for your audience.
A view that summarizes and analyzes data in a datasheet or form. You can use different levels of detail or organize data by dragging the fields and items, or by showing and hiding items in the drop-down lists for the fields.
The pointer that appears when you move the pointer to the left edge of a field in a datasheet. When the plus pointer appears, you can click to select the entire field.
A form that stays on top of other windows. A pop-up form can be modal or modeless.
One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.
The "one" side of two related tables in a one-to-many relationship. A primary table should have a primary key and each record should be unique.
A Sub or Function procedure is declared as private by using the Private keyword in a Declare statement. Private procedures are available for use only by other procedures within the same module.
A sequence of declarations and statements in a module that are executed as a unit. Procedures in Visual Basic include both Sub and Function procedures.
Describes any variables or constants declared within a procedure. Variables and constants declared within a procedure are available to that procedure only.
Procedure Level Variable
A variable that's declared within a procedure. Procedure-level variables are always private to the procedure in which they're declared.
The set of all code modules in a database, including standard modules and class modules. By default, the project has the same name as the database.
A window used to view or modify the properties of various objects such as tables, queries, fields, forms, reports, data access pages, and controls.
In an Access project, a publication can contain one or more published tables or stored procedure articles from one user database. Each user database can have one or more publications. An article is a grouping of data replicated as a unit.
The process of exporting datasheets, forms, or reports to static HTML or server-generated HTML, or creating data access pages, and setting up these files and all related files as a Web application on a Web server such as Microsoft IIS.
The grid that you use to design a query or filter in query Design view or in the Advanced Filter/Sort window. For queries, this grid was formerly known as the QBE grid.
A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.
A window in which you work with queries in Design view, Datasheet view, SQL view, or Print Preview.
Real Data Type
In an Access project, an approximate numeric data type with seven-digit precision. It can hold positive values from approximately 1.18E - 38 through 3.40E + 38, negative values from approximately -1.18E - 38 through -3.40E + 38, or zero.
Record Navigation Control
A control used on a data access page to display a record navigation toolbar. In a grouped page, you can add a navigation toolbar to each group level. You can customize the record navigation control by changing its properties.
Record Navigation Section
A section in a data access page that displays the record navigation control for a specific group level. It appears after the corresponding group header section. You can't place bound controls in a record navigation section.
Record Number Box
A small box that displays the current record number in the lower-left corner in Datasheet view and Form view. To move to a specific record, you can type the record number in the box, and press ENTER.
A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.
The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.
The collective name given to table-, dynaset-, and snapshot-type Recordset objects, which are sets of records that behave as objects.
The Access database to which the user has established a reference from the current database. The user can create a reference to a database and then call procedures within standard modules in that database.
The current Access database from which the user has created a reference to another Access database. The user can create a reference to a database and then call procedures within standard modules in that database.
Rules that you follow to preserve the defined relationships between tables when you enter or delete records.
In an Access database, to redisplay the records in a form or datasheet to reflect changes that other users have made. In an Access project, to rerun a query underlying the active form or datasheet in order to reflect changes to records.
An association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.
A window in which you view, create, and modify relationships between tables and queries.
Places the element in the natural HTML flow of the document but offsets the position of the element based on the preceding content.
To redraw the screen. The Repaint method completes any pending screen updates for a specified form.
A copy of a database that is a member of a replica set and can be synchronized with other replicas in the set. Changes to the data in a replicated table in one replica are sent and applied to the other replicas.
The Design Master and all replicas that share the same database design and unique replica set identifier.
Replica Set Topology
The order in which changes are propagated from replica to replica. Topology determines how quickly changes in another replica appear in your replica.
The process of copying a database so that two or more copies can exchange updates of data or replicated objects. This exchange is called synchronization.
An Access database object that prints information formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.
A report section used to place information that normally appears at the bottom of the page, such as page numbers, dates, and sums.
A report section used to place information, such as a title, date, or report introduction, at the beginning of a report.
A module that includes code for all event procedures triggered by events occurring on a specific report or its controls.
The box where the rulers meet in the upper-left corner of a report in Design view. Use the box to perform report-level operations, such as selecting the report.
A file (.snp extension) that contains a high-fidelity copy of each page of an Access report. It preserves the two-dimensional layout, graphics, and other embedded objects of the report.
A window in which you work with reports in Design view, Layout Preview, or Print Preview.
To rerun a query underlying the active form or datasheet in order to reflect changes to the records, display newly added records, and eliminate deleted records.
A word that's part of the Visual Basic for Applications programming language. Keywords include the names of statements, data types, methods, operators, objects, and predefined functions. Don't use keywords for variable or object names.
Right Outer Join
An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left.
The part of PivotTable view that contains row fields.
A field in the row area of PivotTable view. Items in row fields are listed down the left side of the view. Inner row fields are closest to the detail area; outer row fields are to the left of the inner row fields.
A small box or bar that, when clicked, selects an entire row in table or macro Design view, or when you sort and group records in report Design view.
The window in which you create and modify macros.
Scrolling Text Control
A control used on a data access page to display a marquee, or moving text. You can customize the display of text by setting options such as direction and speed. Browsers that do not support scrolling text will display static text.
A part of a form, report, or data access page such as a header, footer, or detail section.
The horizontal bar above a data access page section in Design view. The section bar displays the type and name of the section. Use it to access the section's property sheet.
The box on the left side of a section bar when an object is open in Design view. Use the box to perform section-level operations, such as selecting the section.
An Access workgroup in which users log on with a user name and password and access to database objects is restricted according to permissions granted to specific user accounts and groups.
A query that asks a question about the data stored in your tables and returns a result set in the form of a datasheet without changing the data.
The rectangle formed by the currently selected rows (records) and columns (fields) within Datasheet view.
A join in which a table is joined to itself. Records from the table are combined with other records from the same table when there are matching values in the joined fields.
A character that separates units of text or numbers.
A field displayed in the series area of a chart and containing series items. A series is a group of related data points.
An individual data value plotted in a chart and represented by a column, bar, line, pie or doughnut slice, or other type of data marker.
Server Filter By Form
A technique that uses a version of the current form or datasheet with empty fields in which you can type values you want the filtered records to contain. The data is filtered by the server before it's retrieved from the database.
An Active Server Pages (ASP) or IDC/HTX file that is output from a table, query, or form, connected to an ODBC data source, and processed by the Internet Information Server to dynamically create read-only HTML files.
A sequence of operations performed by the Microsoft Jet database engine that begins when a user logs on and ends when the user logs off. All operations during a session form one transaction scope and are subject to the user's logon permissions.
Smalldatetime Data Type
In an Access project, a date and time data type that is less precise than the datetime data type. Data values range from January 1, 1900, through June 6, 2079, to an accuracy of one minute.
Smallint Data Type
In an Access project, a data type of 2 bytes (16 bits) that stores whole numbers in the range of -2^15 (-32,768) through 2^15 - 1 (32,767).
Smallmoney Data Type
In an Access project, a data type that stores monetary values from -214,748.3648 to 214,748.3647, with accuracy to a ten-thousandth of a monetary unit. When smallmoney values are displayed, they are rounded up to two decimal places.
A static image of a set of data, such as the records displayed as the result of a query. Snapshot-type Recordset objects can be created from a base table, a query, or another recordset.
A program that you can use to view, print, or mail a snapshot, such as a report snapshot. Snapshot Viewer 11.0 consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), and other related files.
Snapshot Viewer Control
An ActiveX control (Snapview.ocx) that you use to view a snapshot report from Microsoft Internet Explorer 3.0 or later, or from any application that supports ActiveX controls, such as Access or Microsoft Visual Basic.
SQL Database ODBC
A database based on Structured Query Language (SQL).
SQL Specific Query
A query that consists of an SQL statement. Subqueries and pass-through, union, and data-definition queries are SQL-specific queries.
An expression that defines an SQL command, such as SELECT, UPDATE, or DELETE, and includes clauses such as WHERE and ORDER BY. SQL strings/statements are typically used in queries and in aggregate functions.
SQL Variant Data Type
In an Access project, a data type that stores values of several data types, except for text, ntext, image, timestamp, and sql_variant types. It is used in a column, parameter, variable, or return value of a user-defined function.
A window that displays the SQL statement for the current query or is used to create an SQL-specific query (union, pass-through, or data definition). When you create a query in Design view, Access constructs the SQL equivalent in SQL view.
A module in which you can place Sub and Function procedures that you want to be available to other procedures throughout your database.
A precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit. They are stored in an SQL database and can be run with one call from an application.
Text characters that set apart a string embedded within a string. Single quotation marks (') and double quotation marks (") are string delimiters.
A procedure that carries out an operation. Unlike a Function procedure, a Sub procedure doesn't return a value. You begin a Sub procedure with a Sub statement and end it with an End Sub statement.
A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.
A form contained within another form or a report.
A control that displays a subform in a form or a subform or a subreport in a report.
An SQL SELECT statement inside another select or action query.
A report contained within another report.
To agree to receive a publication in an Access database (.mdb) or an Access project (.adp). A subscriber database subscribes to replicated data from a publisher database.
The database that receives tables and data replicated from a publisher database in an Access project (.adp).
The process of updating two members of a replica set by exchanging all updated records and objects in each member. Two replica set members are synchronized when the changes in each have been applied to the other.
Sysname Data Type
In an Access project, a special system-supplied, user-defined data type that is used for table columns, variables, and stored procedure parameters that store object names.
Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.
A control you can use to construct a single form or dialog box that contains several pages, each with a tab, and each containing similar controls, such as text boxes or option buttons. When a user clicks a tab, that page becomes active.
A database object that stores data in records (rows) and fields (columns). The data is usually about a particular category of things, such as employees or orders.
Table Data Type
In an Access project, a special data type used to store a result set in a local variable or return value of a user-defined function for later processing. It can be used in place of a temporary table stored in the tempdb database.
In an Access database, attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in table Design view, as are field properties.
In an Access database, a window in which you work with tables in Design view or Datasheet view.
A control, also called an edit field, used on a form, report, or data access page to display text or accept data entry. It can have a label attached to it.
Text Data Type
In a Microsoft Access database, this is a field data type. Text fields can contain up to 255 characters or the number of characters specified by the Fieldsize property, whichever is less.
Textmemo Data Type
In an Access project, a variable-length data type that can hold a maximum of 2^31 - 1 (2,147,483,647) characters; default length is 16.
A collection of formats that determines the appearance of the controls, sections, body, and text on a data access page.
Timestamp Data Type
In an Access project, a data type that is automatically updated every time a row is inserted or updated. Values in timestamp columns are not datetime data, but binary(8) or varbinary(8), indicating the sequence of data modifications.
Tinyint Data Type
In an Access project, a data type of 1 byte (8 bits) that stores whole numbers in the range of 0 through 255.
A control used to provide on/off options on a form or report. It can display either text or a picture, and can be standalone or part of an option group.
The default property setting of a control type. You customize a control type before you create two or more similar controls to avoid customizing each control individually.
A set of tools that are available in Design view to add controls to a form, report, or data access page. The toolset available in page Design view is different from the toolset available in form and report Design view.
Brief descriptions of the names of buttons and boxes on toolbars and in the toolbox. A ToolTip is displayed when the mouse pointer rests on the button or combo box.
The order in which changes are propagated from replica to replica. Topology is important because it determines how quickly changes in another replica appear in your replica.
A field that summarizes data from the underlying record source. A total field might use a summary function, such as Sum or Count, or use an expression to calculate summary values.
A query that displays a summary calculation, such as an average or sum, for values in various fields from a table or tables. A totals query is not a separate kind of query; rather, it extends the flexibility of select queries.
A series of changes made to a database's data and schema.
A special form of a stored procedure that is carried out automatically when data in a specified table is modified. Triggers are often created to enforce referential integrity or consistency among logically related data in different tables.
A control that is not connected to a field in an underlying table, query, or SQL statement. An unbound control is often used to display informational text or decorative pictures.
Unbound Form Report
A form or report that isn't connected to a record source such as a table, query, or SQL statement. (The form's or report's RecordSource property is blank.)
Unbound Object Frame
A control you place on a form or report to contain an unbound object. An unbound object is an object, such as a picture, whose value isn't derived from data stored in a table.
A query that uses the UNION operator to combine the results of two or more select queries.
An index defined by setting a field's Indexed property to Yes (No Duplicates). A unique index will not allow duplicate entries in the indexed field. Setting a field as the primary key automatically defines the field as unique.
Uniqueidentifier Data Type
In an Access project, a 16-byte globally unique identifier (GUID).
A type of recordset that works efficiently in a client/server environment by caching data on the client and minimizing round trips to the server to access and update data.
To accept changes to data in a record. The changes are saved in the database when you move to another record on a form, datasheet, or data access page, or when you explicitly save the record.
An action query (SQL statement) that changes a set of records according to criteria (search conditions) that you specify.
An account identified by a user name and personal ID (PID) that is created to manage the user's permissions to access database objects in an Access workgroup.
A collection that you create by adding objects to a Collection object. Items in a collection defined by the Collection object are indexed beginning with 1.
User-Defined Data Type
In a Microsoft SQL Server database, a definition of the type of data a column can contain. It is defined by the user with existing system data types. Rules and defaults can only be bound to user-defined data types.
A query that takes input parameters and returns a result like a stored procedure. Types: scalar (multistatement; returns one value), inline (one statement; an updateable table value), and table (multistatement; table value).
A custom object defined in a form or report class module. In a class module, you can create methods and properties for a new object, create a new instance of this object, and manipulate it with these properties and methods.
When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.
The group account that contains all user accounts. Access automatically adds user accounts to the Users group when you create them.
The process of checking whether entered data meets certain conditions or limitations.
A property that defines valid input values for a field or record in a table, or a control on a form. Access displays the message specified in the ValidationText property when the rule is violated.
Varbinary Data Type
In an Access project, a variable-length data type with a maximum of 8,000 bytes of binary data.
Varchar Data Type
In an Access project, a variable-length data type with a maximum of 8,000 ANSI characters.
In an Access project, a type of query that is a virtual table based on an SQL SELECT statement. For example, a view might only contain 3 out of 10 available columns in a join of two tables, in order to limit access to certain data.
A property of a replica that indicates which members of the replica set it can synchronize with and which conflict resolution rules apply. Replicas fall into three visibility types: global, local, and anonymous.
Visual Basic Identifier
A data member in a Visual Basic code module. An identifier can be a Sub, Function, or Property procedure, a variable, a constant, a Declare statement, or a user-defined data type.
Web Page Preview
Opens a data access page for preview in Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later.
The part of an SQL statement that specifies which records to retrieve.
A group of users in a multiuser environment who share data and the same workgroup information file.
A case-sensitive alphanumeric string 4 to 20 characters long that you enter when creating a new workgroup information file by using the Workgroup Administrator. This uniquely identifies the Admins group for this workgroup file.
Workgroup Information File
A file Access reads at startup that contains information about the users in a workgroup. This information includes users' account names, their passwords, and the groups of which they are members.
Information added to a tag to provide more information about the tag, such as <ingredient quantity="2" units="cups">flour</ingredient>.
Information delimited by a start and end tag in an Extended Markup Language (XML) document. An example would be <LastName>Davolio</LastName>.
Combinations of characters and symbols that replace other characters when an XML document is parsed, usually those that have other meanings in XML. For example, < represents the < symbol which is also the opening bracket for a tag.
Yes/No data type: A field data type you use for fields that will contain only one of two values, such as Yes or No and True or False. Null values are not allowed.
A string that contains no characters. You can use a zero-length string to indicate that you know there's no value for a field. You enter a zero-length string by typing two double quotation marks with no space between them ("").