Standalone Macros in Access: Overview Standalone macros in Access are programs you create in a visual environment. In Access, standalone macros run a series of actions in a specified order. Unlike embedded macros, standalone macros in Access appear as separate objects under the “Macros” category in the database’s Navigation Pane. Standalone macros in
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
Touch Mode in Access: Overview Touch mode in Access gives easy access to the buttons and commands within the Ribbon and Quick Access toolbar. When you enter touch mode, you enlarge the Ribbon and Quick Access toolbar. Also, you add extra space around the buttons and commands within them. This helps you access the
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
Create Input Masks in Access: Overview You can create input masks in Access to dictate a pattern used for data entry in selected fields. Access provides an easy step-by-step routine called the “Input Mask Wizard” to do this. The “Input Mask Wizard” helps you apply input masks to selected “text” and “date/time” fields.
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