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
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
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
Add Records to a Table in Datasheet View in Access: Overview This tutorial shows you how to add records to a table in datasheet view in Access. In datasheet view in Microsoft Access, there is a blank row at the bottom of the table. This row also contains an asterisk (*) in the row