Microsoft Access

What are the different database objects available in MS-Access? Explain.

Following are the different database objects available in MS-Access:

Table
A table stores data about an entity (a person, place, or thing) and is the basic element in any database.

Form
A form provides a more convenient and attractive way to enter, display and/or print the data in a table.

Query
A query answers a question about the database. The most common type of query specifies a set of criteria, then searches the database to retrieve the records that satisfy that criteria.

Report
A report presents the data in a table or query in attractive fashion on the printed page.

Macro
A macro is analogous to a computer program and consists of commands that are executed automatically one after the other. Macros are used to automate the performance of any repetitive task.

Module
It is used to create modules. A module contains an object that stores the code of VBA (Visual Basic for Application).