Wildcard Characters in Access- Instructions

A picture showing how to use wildcard characters within query criteria in Access.
Overview of Wildcard Characters in Access             Wildcard characters in Access add flexibility to query criteria. Wildcard characters in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access you need to know. The asterisk represents multiple unknown characters. For example, the criteria “N*” would
Read more
No Comments

How to Use the ORDER BY Clause in SQL

A picture that shows how to use the ORDER BY clause in SQL within an Access query.
Overview of the ORDER BY Clause in SQL             This blog post shows you how to use the ORDER BY clause in SQL to sort the result set of a query. When viewing the result set of a SELECT statement in SQL, the records appear in the order that they were selected from the table.
Read more
No Comments

Sort a Query in Access – Instructions

A picture that shows how to sort a query in Access in datasheet view by using the buttons in the “Sort & Filter” button group on the “Home” tab of the Ribbon.
Overview of Sorting a Query in Access             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, click into the “Sort” row of the field in the QBE grid by which to sort
Read more
No Comments

Create Input Masks in Access – Instructions

A picture of the “Input Mask Wizard” in Access you use to create input masks in Access.
Overview of Creating Input Masks in Access             You can create input masks in Access for table fields to dictate a pattern to use for data entry in the fields. You can manually create input masks for most text, date, and number data type fields in Access, except the “Long Text” data type. Access also
Read more
No Comments

Select Controls in Access- Instructions

Select Controls in Access: A picture of a user selecting multiple controls in Access.
Overview of Selecting Controls in Access             When placing controls into forms and reports in design view, you often need to select the controls. In this lesson, you will look at the ways that you can select controls in Access.             To select a control in Access, click the control you want to select. When
Read more
No Comments

Export Data from Access – Instructions

A picture that shows how to export data from Access for Microsoft 365 to Excel.
Overview of Exporting Data from Access             You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported.             To export data
Read more
No Comments

Create Tables in Access – Instructions

A picture of a user creating a new table in table design view in Access.
Overview of How to Create Tables in Access             This lesson shows you how to create tables in Access. A table is an organized structure that holds information. It consists of fields of information into which you enter the records of the table. A field is a single column within a table, consisting of one
Read more
No Comments

Create Relationships in Access – Instructions

A picture of a user creating a relationship, or table join, between two database tables in the Relationships window in Access.
Overview of Creating Relationships in Access Opening the Relationships Windows in Access             You create relationships in Access between database tables in the Relationships window. As you create tables in Access, you want to relate the tables to access information from them through the “shared” or “common” fields by which they are joined. Relationships in
Read more
No Comments