Tag Archives: Microsoft Access

How to Create a Form in Microsoft Access

Access is database application software that lets you create database of various sorts with ease. You can even create forms in Access. To begin with, forms in access allow you to view one record at a time. Furthermore, forms make it easier to enter data into tables. Lastly, forms express the same data in the table but in a manner far more presentable.


read more »

How to Create a Form Using form Wizard in Microsoft Access

Form wizard in Access lets you create forms with great ease. You can create forms in Ms Access with the help of the wizard with just a few clicks. In this tutorial, we will teach you how to use the wizard and other options relating to it. New record entry can be done to the database with the help of these forms.


read more »

How to Create a Query in Microsoft Access

The purpose of a query in Microsoft Access is to retrieve a particular set of data from one or more tables the query is concerned with. It can be used to group or filter the data according to the needs of the customer. Run a particular query and it will display you the results relevant to your query only. It is important to know how to work with simple queries. People create queries to solve various issues in their Access database.
In this tutorial, we will teach you how to create a query in Access.


read more »

How to Add Total and Sub Totals to a Report in Microsoft Access

Add total columns in Access to help you with your data calculations. If there are mathematical calculations in your report, it is easy to analyze the performance. With totals and subtotals, you can compare each section with one and another. Reports in MS Access provide in-depth analysis of business performance. Total function helps in making calculations in Access.


read more »

How to Add Conditional Formatting and Data Bars to Reports in Microsoft Access

When reading a report it is useful to identify any unusual number.
Conditional formatting in access allows you to change the appearance of your results according to the criteria you have specified. You can also analyze your data graphically through the use of data bars. In Microsoft Access, there are options to highlight things in your database that would otherwise go unnoticed.


read more »