Database Objects in Microsoft Access

      No Comments on Database Objects in Microsoft Access

When the word database is mentioned, what comes to the mind is the collection of information. In Microsoft Access, every database is stored in a single file which contains what is known as database objects. Database objects are simply the components of a database. These components of Access Database are the main players that makes it awesome. There are six different types of database objects in MS Access as explained below:

  1. Tables

This object (component/feature) store information. Tables are the cornerstone of any database, and you can create as many tables as you need to store different types of information. A business database could keep track of its daily business log, customers, and employees as three separate tables.

  1. Queries

Let you perform an action on a table very quickly. Usually, this action involves retrieving a choice bit of information (like the 10 top-selling product in the organization or all the sales the business made in a single day). However, queries can also be used to apply changes.

  1. Forms

These are attractive windows that are created, arranged, and colorized to collect information. Forms also provide an easy way to view or change the data in a table.

  1. Reports

Reports also help you print some or all of the information in a table. You can choose where the information appears on the printed page, how it’s grouped and sorted, and how it’s formatted.

  1. Macros

Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer.

  1. Modules

Modules are files that contain Visual Basic code. You can use this code to do just about anything—from updating 10,000 records to firing off an email.

Access gurus refer to all these database ingredients as objects because you manage them all in essentially the same way. If you want to use a particular object, you add it to your database, give it a name, and then fine-tune it. Later on, you can view your objects, rename them, or delete ones you don’t want anymore.

Leave a Reply

Your email address will not be published. Required fields are marked *