Access is considered a relational database in which data is split into tables that are interconnected. Database Relationship tells you how one table is connected to the other table and how data is integrated in between them. It is important to know how relationships in Access work in order to maintain referential integrity between tables.
In this tutorial, we will teach you how to create relationship in Access.

Ms Office Access is database application software that lets you create a database with ease. Access makes it easy to search your table and data. There are three main techniques in this software to do this which are; finding, sorting and filtering. If you have a large database it becomes impossible to look for a particular record so the use of these tools makes it convenient to look for data in a more effective manner. To sort in Access is very effective in finding data and records.

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.

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.

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.

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.

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.

Queries are questions that a user asks from the database. You can create wild card queries in Access. When these wild card queries are executed, they go and search the access database according to the search criteria mentioned. These Wildcard Queries are very useful when you are looking for a certain word; you don’t remember where you have used it and what context it was used in.
Wild card queries are of one time use only because you don’t need them in future as you do not forget the same thing over and over again. You can always create a wild card query whenever the need arises.
In this tutorial, we will teach you how to create a wildcard query in Access.

Pivot table in Access is a good way to group and summarize huge amounts of information like sales records pulled from a database. Pivot tables allow you to analyze your data in a more graphical manner.
The best thing about pivot tables is that they are very customizable. For example, you can start with a sub grouped view that shows you all your sales grouped by customer’s country. Let’s say, you change your mind and want all the sales grouped according to the orders. This change can easily be brought about in the pivot table.

Creating graphs and charts will give your data a more presentable look. It will be easier for the end user to analyze data presented in graphical form. Sometimes merely looking at numbers is not enough. A graphical image conveys the message better.
In this tutorial, we will teach you how to create a pivot chart in Access.