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