Create a Navigation Form in Access – Instructions

A picture that shows how to create a navigation form in Access.
Overview of How to Create a Navigation Form in Access             You can quickly and easily create a navigation form in Access. A navigation form performs the same function as a switchboard form does within your database. A navigation form in Access contains buttons you click to open other database objects, like reports and forms.
Read more
No Comments

Set a Password on an Access Database – Instructions

A picture of a user starting to set a password on an Access database by first opening the database using the “Open Exclusive” command.
Overview of How to Set a Password on an Access Database             You can set a password on an Access database to prevent unauthorized access to the database file. To set a password on an Access database, you must first open the database using the “Open Exclusive” command. To do this, open Access and then
Read more
No Comments

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

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

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