Create a Calculated Field in Access: Overview You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration of
Sort a Query in Access: Overview You can sort a query in Access by any field within the QBE grid when viewing the query in design view. To sort a query in Access when in design view, select the field in the QBE Grid by which to sort the result set. Then click into
Use the Field List in Access: Overview You can use the Field List in Access to easily add data fields to a data entry form. Most forms are connected to an underlying table or query from which they display and/or update the table data. In form design view, you can access the list of
Run a Query in Access: Overview You can run a query in Access when using query design view. To do this, click the “Design” tab of the “Query Tools” contextual tab within the Ribbon. Then click the “Run” button in the “Results” button group. If the results are not what you expected, you
Wildcard Characters in Access: Overview You can use wildcard characters in Access to add an additional level of flexibility to your query criteria. Wildcard characters within query criteria in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access
Select Controls in Access: Overview When you are placing controls into forms and reports in “Design View,” you will often need to select the controls. In this lesson, you will look at the ways that you can select controls in Access. To select controls in Access, click the control you want to select.
Aggregate Function Queries in Access: Overview You can create aggregate function queries in Access that perform a mathematical function on another grouped field in a query. Aggregate function queries in Access are usually shorter queries often used for summary totals in reporting. For example, if you want to know the sum of sales
Combo Box Controls in Access: Overview Combo box controls in Access allow you to create drop-down menus. These let users select a choice to make an entry within a field. The choices available in the combo box menu can come from different sources. You can use a table or query, or you can type