– Microsoft access 2016 basics vocabulary free
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.
A database 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.
You declare a function by using the Function statement and end it by using the End Function statement. The default sort order determines how characters are sorted in the entire database, such as in tables, queries, and reports. You should define the General sort order if you plan to use a database with multiple language editions of Access. In Access and earlier, a special custom menu bar that replaces the built-in menu bar in all windows in your database 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. 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 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. 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.
An arrangement of vertical and horizontal dotted and solid lines that help you position controls precisely when you design a form or report. Permissions assigned to a group apply to all users in the group. A drop-down list box control on a data access page that retrieves records from an underlying recordset based on the value that you select from the list. On a grouped page, the control retrieves a specific group of records. Used 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.
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 are arranging controls or setting properties. A unique identification string used with remote procedure calls. A GUID is a bit value. A global replica to which all replicas in the replica set synchronize their changes. 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. 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, it is a field with a Hyperlink data type. In an Access project, it is a field that has the IsHyperlink property set to True. A control that is 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 go to the target location.
An element of an expression that refers to the value of a field, control, or property. For example, Forms! A data member in a Visual Basic code module. To copy data from a text file, spreadsheet file, 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.
A specification that stores the information that Access needs to run an import or export operation on 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. In an Access database, a window in which you can view or edit a table’s indexes or create multiple-field indexes. A synchronization method that is used in a disconnected environment, such as when you travel with a portable computer. You must use the Replication Manager to configure indirect synchronization. For example, you can play a waveform audio.
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 that is 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. A fundamental data type that holds integers. An Integer variable is stored as a bit 2-byte number ranging in value from , to 32, Used to synchronize replicas in a disconnected environment in which an Internet server is configured.
You must use the Replication Manager to configure Internet synchronization. These constants are available in the Object Browser by clicking globals in each of these libraries.
A unique element of data within a field. 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. A control that displays descriptive text, such as a title, a caption, or instructions, on a form or report.
Labels may or may not be attached to another control. A view in which you can make many types of design changes to forms and reports while viewing live data. 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 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. An action that establishes a connection to data from another program so that you can view and edit the data in both the original program 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 cannot change its structure.
The sequence of numbers for items in a list, starting with 0 for the first item, 1 for the second item, and so on. A table, query, form, report, macro, or module that remains in the replica or Design Master in which 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 Access database. The part of the Access database system that retrieves and stores data in user and system databases. The engine can be thought of as a data manager upon which database systems, such as Access, are built.
The object tab in which you create and modify macros. You can start the Macro Builder from a variety of places, such as a form or report, or directly from the Create tab on the Ribbon. 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 query SQL statement that creates a new table and then creates records rows in that table by copying records from an existing table or query results. 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 a many-to-many relationship, create a third table and add the primary key fields from the other two tables to this table. Moving text that is 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. 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. An Access or earlier database. In an Access database, this is a field data type. Memo fields can contain up to 65, characters.
An Access database or Access project file. An Access database stores database objects and data in an. A collection of data and objects such as tables, queries, or forms that is related to a particular topic or purpose. An object, defined by Access, that relates to Access, its interface, or an application’s forms and reports.
In addition, you can use a Microsoft Access object to program the elements of the interface used for entering and displaying data. A project file doesn’t contain any data or data-definition-based objects, such as tables and views.
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 Visual Basic for Applications VBA module or outside of a procedure. Variables or constants declared at the module level are available to all procedures in a module.
These variables are available to all procedures in the module. In an Access project, a data type that stores monetary values in the range ,,,, The large square that is displayed in the upper left corner of the selected control or control layout in Design view or Layout view.
You can drag the handle to move the control or control layout to another location. The mode in which you can move a column 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. A feature that automatically corrects common side effects that occur when you rename forms, reports, tables, queries, 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. These buttons are located in the lower left corner of the Datasheet view and Form view. The buttons are also available in Print Preview so that you can move through the pages of your document. The pane that appears when you open an Access database or an Access project.
The Navigation Pane displays the objects in the database, and can be customized to sort and group objects in different ways. In an Access project, a fixed-length data type with a maximum of 4, 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. Columns with the ntext data type store a 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 a Null value.
A field containing a Null value. A null field is not the same as a field that contains a zero-length string ” ” or a field with a value of 0. In an 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. In an Access project, a variable-length data type with a maximum of 4, Unicode characters. 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 is best to declare object variables according to their specific types. Shows objects that have a dependency on the selected object and also objects on which the selected object has dependencies.
A file that contains definitions of objects and their methods and properties. The file that contains an object library typically has the file name extension. A type of object exposed by a program through Automation; for example, Application, File, Range, and Sheet. Use the Object Browser in the Visual Basic Editor or refer to the program’s documentation for a complete listing of available objects.
An Access tool that 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. 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 — a driver that you can use for importing, linking to, or exporting data — is supplied.
A program that contains a linked or embedded OLE object from another program. 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. An object supporting the OLE protocol for object linking and embedding. A field data type that you use for objects created in other programs that can be linked or embedded inserted in an Access database. 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 a radio button, that is typically used as part of an option group to present alternatives on a form or report.
A user cannot select more than one option. A frame that can contain check boxes, toggle buttons, and option buttons on a form or report. 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 at least 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 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. Used 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. Used 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. 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. By using pass-through queries, you work directly with the tables on the server instead of the data being processed by the Access database engine. A set of attributes that specifies what kind of access a user has to data or objects in a database.
An object stored in the database; for example, a database table or QueryDef object. Dynaset-type or snapshot-type Recordset objects are not considered persistent objects because they are created in memory as needed.
A case-sensitive alphanumeric string that is 4 to 20 characters long and that Access uses in combination with the account name to identify a user or group in an Access workgroup. A type of locking in which the page containing one or more records, including the record being edited, is unavailable to other users when you use the Edit method, and remains unavailable until you use the Update method.
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. 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. 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. Describes any variables or constants declared within a procedure. Variables and constants declared within a procedure are available to that procedure only.
A variable that is 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 pane that is used to view or modify the properties of various objects such as tables, queries, fields, forms, reports, data access pages, and controls. A dynamic cross-reference of one or more table data fields columns that permits an ODBC table server table without a unique index to be edited. A public variable can be shared by all the procedures in every module in a database. 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. To save a database to a document management server, such as a server running Windows SharePoint Services. 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 or report. In an Access project, an approximate numeric data type with seven-digit precision.
It can hold positive values from approximately 1. 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. A small box that displays the current record number in the lower-left corner in Datasheet view and Form view.
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 can be a table, query, or SQL statement.
In an Access project, it can 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.
Rules that you follow to preserve the defined relationships between tables when you add, update, 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 that is established between common fields columns in two tables. A relationship can be one-to-one, one-to-many, or many-to-many. 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. 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 that you can print containing information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels. A report section that is used to place information that normally appears at the bottom of the page, such as page numbers, dates, and sums.
A report section that is used to place information such as a title, date, or report introduction at the beginning of a report. A module that includes Visual Basic for Applications VBA 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. It preserves the two-dimensional layout, graphics, and other embedded objects of the report. 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 is part of a language, such as Visual Basic. Reserved words include the names of statements, predefined functions and data types, methods, operators, and objects. 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. 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 horizontal bar above a form or report 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 in which access to database objects is restricted according to permissions granted to specific user accounts and groups.
An initial value used to generate pseudorandom numbers. For example, the Randomize statement creates a seed number used by the Rnd function to create unique pseudorandom number sequences. 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 field that is displayed in the series area of a chart and that contains series items. A series is a group of related data points. An individual data value that is plotted in a chart and represented by a column, bar, line, pie or doughnut slice, or other type of data marker. 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 is retrieved from the database.
A sequence of operations performed by the Access 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. 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, , through June 6, , to an accuracy of one minute.
In an Access project, a data type that stores monetary values from , 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 consists of a stand-alone executable program, a Snapshot Viewer control Snapview. An ActiveX control Snapview. The sql variant data type is used in a column, parameter, variable, or return value of a user-defined function. An object tab that displays the SQL statement for the current query or that is used to create an SQL-specific query union, pass-through, or data definition.
A query that consists of an SQL statement. Subqueries and pass-through, union, and data-definition queries are SQL-specific queries. A parameter that indicates the way in which a probability function is centered around its mean and that is equal to the square root of the moment in which the deviation from the mean is squared. A Visual Basic for Applications VBA 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 that is stored under a name and processed as a unit. The collection is stored in an SQL database and can be run with one call from a program.
Text characters that set apart a string embedded within a string. Single quotation marks ‘ and double quotation marks ” are string delimiters. 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. To agree to receive a publication in an Access database or an Access project. 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. 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. 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 that 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.
In an Access project, a special data type that is 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, an object tab in which you work with tables in Design view or Datasheet view.
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. A control, also called an edit field, that is used on a form or report to display text or accept data entry. A text box can have a label attached to it. Text fields can contain up to characters or the number of characters specified by the FieldSize property, whichever is less.
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. In an Access project, a data type of 1 byte 8 bits that stores whole numbers in the range of 0 through It can display either text or a picture, and can be stand-alone or part of an option group.
The following illustrates what a SQL statement for a simple select query might look like in Access:. This example SQL statement reads “Select the data that is stored in the fields named E-mail Address and Company from the table named Contacts, specifically those records in which the value of the field City is Seattle. If an identifier contains spaces or special characters such as “E-mail Address” , it must be enclosed in square brackets.
A SELECT clause does not have to say which tables contain the fields, and it cannot specify any conditions that must be met by the data to be included. More information about how you use these clauses is presented in these additional articles:. Like Microsoft Excel, Access lets you sort query results in a datasheet. An ORDER BY clause contains a list of the fields that you want to use for sorting, in the same order that you want to apply the sort operations. For example, suppose that you want your results sorted first by the value of the field Company in descending order, and — if there are records with the same value for Company — sorted next by the values in the field E-mail Address in ascending order.
Note: By default, Access sorts values in ascending order A-Z, smallest to largest. Use the DESC keyword to sort values in descending order instead. Sometimes you want to work with summarized data, such as the total sales in a month, or the most expensive items in an inventory. For example, if you want your query to show the count of e-mail addresses listed for each company, your SELECT clause might resemble the following:. The aggregate functions that you can use depend on the type of data that is in the field or expression that you want to use.
For more information about the available aggregate functions, see the article SQL Aggregate Functions. If you want to use criteria to limit your results, but the field that you want to apply criteria to is used in an aggregate function, you cannot use a WHERE clause. For example, if you only want the query to return rows if there are more than one e-mail addresses associated with the company, the HAVING clause might resemble the following:. When you want to review all the data that is returned by several similar select queries together, as a combined set, you use the UNION operator.
The SELECT statements that you combine must have the same number of output fields, in the same order, and with the same or compatible data types. When you run the query, data from each set of corresponding fields is combined into one output field, so that the query output has the same number of fields as each of the select statements. Note: For the purposes of a union query, the Number and Text data types are compatible.
When you use the UNION operator, you can also specify whether the query results should include duplicate rows, if any exist, by using the ALL key word. For example, suppose that you have a table named Products and another table named Services.
Both tables have fields that contain the name of the product or service, the price, warranty or guarantee availability, and whether you offer the product or service exclusively. Although the Products table stores warranty information, and the Services table stores guarantee information, the basic information is the same whether a particular product or service includes a promise of quality.
You can use a union query, such as the following, to combine the four fields from the two tables:. SQL syntax. Access SQL: basic concepts, vocabulary, and syntax. Notes: Access ignores line breaks in a SQL statement. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow.
Microsoft access 2016 basics vocabulary free –
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. A workspace that uses the Access database engine to access a data source. 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 object tab. A query that copies or changes data. Action queries include append, delete, make-table, and update queries.
They are identified by an exclamation point! A row in the upper part of the Macro object tab in which you enter macro names, actions, arguments, and comments associated with a particular macro or macro group. An Access project. 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. The anonymous replica is particularly useful in an Internet situation where you expect many users to download replicas. Filtering data in PivotTable or PivotChart view by selecting one or more items in a field that allows filtering. A collection of formats that determines the appearance of the controls and sections in a form or report. In an Access database, a field data type that automatically stores a unique number for each record as it is added to a table.
Three kinds of numbers can be generated: sequential, random, and Replication ID. A table in an Access database.
You can manipulate the structure of a base table by using the DAO objects or data definition DDL SQL statements, and you can modify data in a base table by using Recordset objects or action queries. 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 they are always interpreted as 1.
A value that is used with bitwise operators And, Eqv, Imp, Not, Or, and Xor to test, set, or reset the state of individual bits in a bitwise field value. 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 is 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. A control that is 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 go to the target location. A control on a form or report that is used to display and manipulate OLE objects that are stored in tables.
A control that is 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. A control that is 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. An Access tool that simplifies a task. For example, you can quickly create a complex expression by using the Expression Builder. In Access and earlier, a toolbar that is part of the Access user interface when it is installed on your computer. In contrast, a custom toolbar is one that you create for your own database application.
In current versions of Access, toolbars are replaced by the Ribbon, which arranges commands in related groups on tabs. In addition, you can add commands that you frequently use to the Quick Access Toolbar. A control that is 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 on which the expression is based. 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. The process of one action triggering another action. For example, when a cascading update relationship is defined for two or more tables, an update to the primary key in the primary table automatically triggers changes to the foreign table.
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.
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. 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 field that is displayed in the category area of PivotChart view. Items in a category field appear as labels on the category axis.
A control that indicates whether an option is selected. A check mark appears in the box when the option is selected. Allows for business rules that span multiple tables. For example, the Order table could have a CHECK constraint that would prevent orders for a customer from exceeding a credit limit defined for the customer in the Customer table. 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. 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. A conflict that occurs during a batch update. A client reads data from the server and then attempts to modify that data in a batch update, but before the update attempt is executed, another client changes the original server data.
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. 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 displayed 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 in a combo box, or you can click the control to display a list and then select an item from that list.
A control that runs a macro, calls a Visual Basic function, or runs an event procedure. A command button is sometimes called a push button in other programs. An operator that is used to compare two values or expressions. 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 the focus, or a user-defined Visual Basic for Applications function. A condition that occurs 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 in all replicas. A restriction placed on 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 A control that makes it possible for a user to jump to a document, Web page, or object.
An example is a text box that is 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.
In an 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 from which you can modify or retrieve data. There can be only one current record in a recordset at any given time, but a recordset may have no current record — for example, after a record has been deleted from a dynaset-type recordset.
In an Access project, a data type you can use only for creating a cursor variable.