Assign Macros to Events in Access – Instructions

A picture showing how to assign macros to events in Access.
Overview of Assigning Macros to Events in Access             You can manually assign macros to events in Access forms by using the “Property Sheet” pane. This is an alternative to using the “Command Button Wizard.” This is most often used with command button controls in forms. However, you can also run macros for events that
Read more
No Comments

Add a Macro to a Button in Access – Instructions

A picture showing how to add a macro to a button in Access.
Overview of Adding Macros to Buttons in Access Forms             You can add a macro to a button in Access forms to run the macro when a user clicks the form’s button. To run macros in Access forms, you often assign a macro to an “event” associated with a command button control in a form.
Read more
No Comments

Standalone Macros in Access – Instructions

A picture of a user creating a standalone macro in Access.
Overview of Standalone Macros in Access             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
Read more
No Comments

Charts in Access – Instructions and Video Lesson

A picture of the “Chart Wizard” that you use to create charts in Access.
Overview of How to Create Charts in Access             You can create charts in Access in two different ways if using Access 2019 or Access for Microsoft 365. You can insert new modern charts into your reports in Access or use the older Microsoft Graph chart controls. These are still available for backward-compatibility in Access
Read more
No Comments

Insert a Modern Chart in Access- Instructions

A picture of a user changing the chart settings after they insert a modern chart in Access.
Overview of Modern Charts in Access             You can insert a modern chart in Access 2019 or 365 into a report in Access. All charts in Access are inserted as a report control. Unlike other report controls, chart controls use their own data source to chart the data. Therefore, you can insert it into a
Read more
No Comments

SQL View in Access- Instructions

A picture showing a query in SQL view in Access.
Overview of SQL View in Access             SQL view in Access lets you see the SQL code of Access queries. When you are visually creating the query in the query design view in Access, what you are really doing is visually constructing SQL code. SQL stands for Structured Query Language. SQL is a multi-platform language
Read more
No Comments

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