Rename a Field in a Table in Access – Instructions and Video Lesson

A picture that shows how to rename a field in a table in Access.
Overview of Renaming Table Fields in Access             You can rename a field in a table in Access that you have already created to change the field’s name. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously
Read more
No Comments

Run a Query in Access – Instructions and Video Lesson

A picture showing how to run a query in Access when it is opened in query design view.
Overview of How to Run a Query in Access             You can run a query in Access when using query design view. To do this, click the “Query Design” contextual tab in the Ribbon. In older versions of Access, this tab is called the “Design” tab of the “Query Tools” contextual tab in the Ribbon,
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

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