Wednesday , November 13 2019
Home / Microsoft Access & VBA / Database objects in ms access with functions and description

Database objects in ms access with functions and description

Database objects in ms access


Database objects in ms access with brief description of their functionalities.


When you create a database in MS Access, it will add some objects automatically to design database, forms, reports, relationship between them. Here we will know about:

  1. Access db structure.
  2. List of access database objects with their functions.
  3. Benefits to use them.
  4. Using the database objects to design business class applications.
  5. Definition and functions of  table, query, forms, reports, macro, module.


First you should know, what is object. The object is an individual part of db. Database objects is a crucial element to develop business class applications. They are used to enter, store and view records. You can design and build customize software for your business by using them.

There are six important database objects in ms access. I have described below with their functionalities.

  1. Table: The database table contains all personal and business records. It stores all kind of data, when a user give an entry. It can be called the bucket of data or information. Then you can use these records in future to take complex decisions. So, it is much crucial element for us.
  2. Query: The query is used to bring data by searching from table. It can search records in one or more tables depending on conditions or without condition.
  3. Form: The form is an interface to enter data from users. When a user enter data into a form and save, then it stores data into the table. That means, a form has a link with a particular table.
  4. Report: If you want to view well organized records in page and also need to print them into hard copy, then you have to design reports in microsoft access. This report takes raw data from tables and organize them into well format. It depends on either query or direct table for taking data. Then it can be printed on paper.
  5. Macro: Macro is a collection of commands which is executed chronologically one after another and finally perform a specific task.
  6. Module: The module is used to write VBA (visual basic application) programs in ms access. You  will write VBA program once and use them multiple times in any place of your application when required.
To create database objects in ms access:

First, you have to open a database.

Second, go to “Create” tab.

Third, click on the specific object (suppose select “Table Design” option to create table). Then follow the steps one by one to complete the process. Finally, the particular object will be created.



  1. Hi, i read your blog from time to time and i own a similar one and i was just wondering if you get a lot of spam remarks? If so how do you prevent it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any help is very much appreciated.

  2. Wow! This blog lߋoks exactlү like my olɗ օne!
    It’s оn а completеly ԁifferent subject bսt іt hɑs
    pretty mucһ the same pаɡe layout and design. Excellent choice οf colors!

  3. Tһiѕ article proviԀeѕ cⅼear idea designed for the new
    peeople of blogging, thаt genuinely how to do blogging and site-building.

  4. Heeya this is kind of of ᧐ff topic but I was wаnting to know if blogs use WYSIWYG editors оr if you hve tо manually ccode ԝith HTML.
    Ӏ’m starting a blog soon but have no coding knoᴡ-һow s᧐ I wantеd to gеt guidance fгom someone witһ experience.
    Any heⅼp would be enormously appreciated!

  5. I really can’t believe how great this site is. Keep up the good work. I’m going to tell all my friends about this place.

  6. This site looks better and better every time I visit it. What have you done with this place to make it so amazing?!

  7. This site looks better and better every time I visit it. What have you done with this place to make it so amazing?!

Leave a Reply

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