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

Combo Box Controls in Access- Instructions

A picture of the “Combo Box Wizard” used to create combo box controls in Access.
Overview of How to Create Combo Box Controls in Access             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,
Read more
No Comments

Add Records to a Table in Datasheet View in Access- Instructions

A picture showing how to add records to a table in datasheet view in Access.
Overview of How to Add Records to a Table in Datasheet View in Access             You can easily 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
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

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

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