In this tutorial, we have created a variety of select queries, mainly from the Design View. But in Access, we can make use of some special query wizards to create a couple of specific select queries. The first one is Find Duplicates Query wizard. The Find Duplicates Query Wizard will create a query that locates… Read More »
A database is a collection of tables of data that allow logical relationships to each other. You use relationships to connect tables by fields that they have in common. A table can be part of any number of relationships, but each relationship always has exactly two tables. In a query, a relationship is represented by… Read More »
Aggregate queries are great if you are looking just for one specific number, but if you want summarizing information like a spreadsheet-like summary you might want to consider trying a crosstab query. When you want to restructure summary data to make it easier to read and understand, consider using a Crosstab Query. A crosstab query is… Read More »
In this chapter, we will be covering how to calculate on a group of records in Access. We have created a field that calculates row by row or record by record to create a line total or subtotal field, but what if we wanted to calculate down by a group of records rather than by… Read More »
An index is a data structure, a special data structure designed to improve the speed of data retrieval. If you often search a table or sort its records by a particular field, you can speed up these operations by creating an index for the field. Microsoft Access uses indexes in a table as you use… Read More »
In MS Access, an expression is like a formula in Excel. This consists of a number of elements that can be used alone or in a combination to produce a result. Expressions can include operators’, constants, functions and identifiers. Expressions can be used to perform a variety of tasks from retrieving the value of a… Read More »
Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data. Wildcards can also help with getting databased on a specified pattern match. Access supports two sets of wildcard characters because it supports two standards for Structured Query… Read More »
In this chapter, let us understand Many-to-Many Relationship. To represent a many-tomany relationship, you must create a third table, often called a junction table, that breaks down the many-to-many relationship into two one-to-many relationships. To do so, we also need to add a junction table. Let us first add another table tblAuthers. Let us now create… Read More »
The vast majority of your relationships will more than likely be this one to many relationships where one record from a table has the potential to be related to many records in another table. The process to create one-to-many relationship is exactly the same as for creating a one-to-one relationship. Let us first clear the… Read More »
Let us now understand One-to-One Relationship in MS Access. This relationship is used to relate one record from one table to one and only one record in another table. Let us now go to the Database Tools tab. Click on the Relationships option. Select tblEmployees and tblHRData and then click on the Add button to add them to our view and then close… Read More »