So what exactly is Microsoft Access and how will it help my business? This article provides an overview of the components that exist inside of MS Access that Phoenix Consultants Group can program to your individual specifications:
There are several pieces that exist within a MS Access system. You have tables, forms, queries, reports, and modules. Each of the pieces is called an "object" by Microsoft.
What is a Microsoft Access Table:
A table in MS Access is quite different than a table in real life. Instead of having wooden legs and being used for meals. Access Tables are a grid made up of rows and columns. Here's and example of a table in Access:
What is a Microsoft Access Form:
A form is an object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source. Alternatively, you can create an "unbound" form that does not link directly to a table, but which still contains command buttons, labels, or other controls that you need to operate your application.
This article focuses primarily on bound forms. You can use bound forms to control access to data, such as which fields or rows of data are displayed. For example, certain users might need to see only several fields in a table with many fields. Providing those users with a form that contains only those fields makes it easier for them to use the database. You can also add command buttons and other features to a form to automate frequently performed actions.
Think of bound forms as windows through which people see and reach your database. An effective form speeds the use of your database, because people don't have to search for what they need. A visually attractive form makes working with the database more pleasant and more efficient, and it can also help prevent incorrect data from being entered.
What is a Microsoft Access Query:
As tables grow in size they can have hundreds of thousands of records, which makes it impossible for the user to pick out specific records from that table. Queries were designed to combat this problem. With a query you can apply a filter to the table's data, so that you only get the information that you want.
The tricky part of queries is that you must understand how to construct one before you can actually use them. This lesson will guide you through the basics of making a couple very simple Access queries.
What is a Microsoft Access Report:
Having all your data stored in Access is great for maintaining a database, but it isn't the best when you want to share the data or view it away from a computer. The solution to this problem is to create an Access report that will let you design a ready-to-print document of your desired database information.