Record | search
Click here to view Record news from 60+ newspapers.
Bookmark or Share- Create and run an update query - Microsoft SupportYou use update queries in Access databases to add, change, or delete the information in an existing record. You can think of update queries as a powerful form of the Find and Replace dialog box. You cannot use an update query to add new records to a database, or to delete records from a database.
- Apply a filter to view select records in an Access databaseYou can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object.
- Create, edit or delete a relationship - Microsoft SupportIn an Access database, you create a table relationship using one of the following methods: In the Relationships window, add the tables that you want to relate, and then drag the field to relate them from one table to the other table. Drag a field on to a table datasheet from the Field List pane.
- Use a query as the record source for a form or reportBefore you use a query as your record source, you should consider whether you need to edit data. This article explains how to set the Record Source property for an existing form or report, and provides information about when you can and cannot edit query data.
- Examples of query criteria - Microsoft SupportA query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.
More
