Customize the Navigation Pane - Microsoft Support
WEBRight-click the top of the Navigation Pane and then select Navigation Options. Select the category for which you want to add one or more groups. For each group, under the Groups for <Group Name> list, click Add Group. Type a …
Create a grouped or summary report - Microsoft Support
WEBGrouping lets you organize and arrange records by group, such as by Region or SalesPerson. Groups can be nested so that you can easily identify the relationships among the groups and find the information you want quickly. You can also use grouping to calculate summary information, such as totals and percentages.
GROUP BY Clause - Microsoft Support
WEBThe GROUP BY clause in Access combines records with identical values in the specified field list into a single record. A summary value is created for each record if you include an SQL aggregate function , such as Sum or Count , in the SELECT statement.
Database design basics - Microsoft Support
WEBDatabase design basics. A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to …
Introduction to data types and field properties - Microsoft Support
WEBA field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Access, and includes additional information in a detailed data type reference section.
Use the Navigation Pane - Microsoft Support
WEBTo display the Filter by Group menu, click the title bar of the Navigation Pane. Select a group. By default, Access displays Tables, Queries, Forms, and Reports. You may also see Macros, Modules, and custom groups if any are defined in the database. To remove the group filter, select All Access Objects.
Learn the structure of an Access database - Microsoft Support
WEBThis article provides a basic overview of the structure of an Access database. Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool.
Access SQL: basic concepts, vocabulary, and syntax
WEBWorking with summarized data: GROUP BY and HAVING. Combining query results: UNION. What is SQL? SQL is a computer language for working with sets of facts and the relationships between them. Relational database programs, such as Microsoft Office Access, use SQL to work with data.
Examples of query criteria - Microsoft Support
WEBA 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.
Restrict data input by using validation rules - Microsoft Support
WEBAdd a validation rule to a control on a form. You can use the Validation Rule property and the Validation Text property of a form control to validate data that is input to that control and to help users who input data that is not valid.
Learn to build an expression - Microsoft Support
WEBMost typically, you group or sort on a field that you select from a list. However, if you want to group or sort on a calculated value, you can enter an expression instead. Grouping is the process of combining columns that contain duplicate values.