Touch Mode in Access – Instructions and Video Lesson

A picture of the user interface after enabling touch mode in Access.
Overview of Touch Mode in Access             Touch mode in Access gives easy access to the buttons and commands within the Ribbon and Quick Access toolbar. When you enter touch mode in Access, you enlarge the Ribbon and Quick Access toolbar. Also, you add extra space around the buttons and commands within them. This helps
Read more
No Comments

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

Create a Calculated Field in Access – Instructions

A picture that shows how to create a calculated field in Access in query design view.
Overview of Creating a Calculated Field in Access             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration
Read more
No Comments

Hide a Query Field in Access – Instructions

A picture showing how to hide a query field in Access.
Overview of How to Hide a Query Field in Access             You can easily hide a query field in Access. Sometimes when you create queries, you need to add a field to the QBE grid for criteria purposes only. In this case, you don’t want the field itself to appear in the result set. Having
Read more
No Comments

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