This documentation is archived and is not being maintained.

Data Access

Office 2007

This page links to help on widely used data-access tasks. To view other categories of popular tasks covered in Help, see How Do I… in Access.

Structured Query Language (SQL)

How to: Build SQL Statements That Include Variables and Controls
Describes how to to construct an SQL statement that includes variables and control values in code.
How to: Create and Delete Tables and Indexes Using Access SQL
Describes how to use Access SQL to create and delete tables and indexes.
How to: Define Relationships Between Tables Using Access SQL
Describes how to use Access SQL to define relationships.
How to: Group Records in a Result Set Using Access SQL
Describes how to use the GORUP BY clause to group related records.
How to: Insert, Update, and Delete Records From a Table Using Access SQL
Describes how to use Access SQL to add, update, and delete records from a table.
How to: Modify a Table's Design Using Access SQL
Describes how to modify a table's design using Access SQL.
How to: Perform Joins Using Access SQL
Describes how to use Access SQL to perform joins.
How to: Retrieve Records Using Access SQL
Describes how to use Access SQL to retrieve records.
How to: Use Aggregate Functions to Work with Values in Access SQL
Describes how to use aggregate functions in Access SQL.

Data Access Objects (DAO)

How to: Add a Record to a DAO Recordset
Describes how to add a new record to a table-type or dynaset-type Recordset.
How to: Build SQL Statements That Include Variables and Controls
Describes how to to construct an SQL statement that includes variables and control values in code.
How to: Change Tables Involved in a One-to-Many Relationship in a DAO Recordset
Describes how to freely change the values on the "one" side of a one-to-many relationship.
How to: Count the Number of Records in a DAO Recordset
Describes how to count the umber of records in a Recordset object.
How to: Create a DAO Recordset From a Form
Describes how to create a Recordset object based on an Access form.
How to: Create a DAO Recordset From a Query
Describes how to create a Recordset object based on a stored select query.
How to: Create a DAO Recordset From a Table In the Current Database
Describes how to create a Recordset object for a table in the current database.
How to: Create a User-Defined Property
Illustrates how to create and set the value of the new uer-defined property.
How to: Delete a Record From a DAO Recordset
Describes how to delete a record from a DAO recordset.
How to: Detect the Limits of a DAO Recordset
Describes how to use the BOF and EOF properties to avoid run-time erros when moving through a recordset.
How to: Extract Data from a Record in a DAO Recordset
Describes several techniques for extracting data from a DAO Recordset.
How to: Find a Record in a Dynaset-Type or Snapshot-Type DAO Recordset
Describes how to use the Find methods to locate records in a dynaset-type or snapshot-type recordset.
How to: Find a Record in a Table-Type DAO Recordset
Describes how to use the Seek method to locate a record in a table-type recordset.
How to: Find the Current Position in a DAO Recordset
Describes how to find the current position in a recordset.
How to: Make Bulk Changes to a DAO Recordset
Describes how to efficiently make bulk updates to a recordset.
How to: Manipulate Multivalued Fields With DAO
Describes how to manipulate records in multivalued fields.
How to: Mark a Position in a DAO Recordset
Describes how to use the Bookmark propety to mark a record in a recordset.
How to: Modify a Query from a DAO Recordset
Describes how to modify a query's parameters using Access SQL.
How to: Modify an Existing Record in a DAO Recordset
Describes how to use the Edit and Update methods to modify records.
How to: Move Through a DAO Recordset
Describes how to use the Move methods to navigate a recordset.
How to: Read From and Write To a Field in a DAO Recordset
Describes how to use the Value property of a field to read or write data to a record.
How to: Return a Random Record from a DAO Recordset
Describes how to return a random record from a recordset.
How to: Set Properties of Data Access Objects in Visual Basic
Describes how to set properties for DAO objects.
How to: Sort Data in a DAO Recordset
Describes how to sort data in a recordset.
How to: Synchronize a DAO Recordset's Record with a Form's Current Record
Describes how to synchronize a recordset's record with the form's current record.
How to: Track Design Changes to a Table-Type DAO Recordset
Describes how to determine when a table was created or last updated.
How to: Use Transactions in a DAO Recordset
Describes how to use transactions in a DAO recordset.
How to: Work With Attachments In DAO
Describes how to load and save attachments in a recordset.

ActiveX Data Objects (ADO)

How to: Bind a Form to an ADO Recordset
Describes how to set a form's Recordset property to an open ADO Recordset object.
How to: Build SQL Statements That Include Variables and Controls
Describes how to to construct an SQL statement that includes variables and control values in code.
How to: Create an ADO Connection String
Describes the components of an ADO connection string.
How to: Set Properties of ActiveX Data Objects in Visual Basic
Describes how to set properties for ADO objects.

XML

How to: Export a Report to XML
Describes how to export the contents of a report to an XML file.
How to: Export Data, Schema, and Related Tables to XML
Describes how to export data and formatting contained in a table to an XML file.

See Also

How Do I... in Access


Show: