Access Data Access How Do I...

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 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 property 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 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.

• How Do I... in Access