Database Objects in Microsoft Access

Database objects are the components used to organize, manage, and work with information in a database.

For example, a student management database can use tables to store student details, queries to search for students, forms to enter information, and reports to print fee records.

• Tables: Store data.
• Queries: Retrieve or process data.
• Forms: Provide a user-friendly interface for working with records.
• Reports: Present information in a formatted layout.

Macros and modules can also be used to automate tasks and add programming functionality.

A table stores data in rows and columns. Each row is a record, and each column is a field.

Example: A Students table stores student IDs, names, courses, and other student information.

A query retrieves, filters, sorts, calculates, or modifies data according to specified conditions.

Examples:

• Find students enrolled in the ADCA course.
• Display students whose fees are pending.
• Calculate the total amount collected in a month.
• Find students admitted after a particular date.

Queries can use data from one or more related tables.

A form provides a convenient interface for entering, viewing, and editing database records.

Examples of forms:

• Student Admission Form
• Course Registration Form
• Fee Payment Form
• Employee Details Form

Forms can include text boxes, buttons, drop-down lists, labels, and other controls.

A report presents database information in a structured format suitable for viewing or printing.

Examples of reports:

• Student List Report
• Monthly Fee Collection Report
• Course Enrollment Report
• Employee Salary Report

Reports can organize information using headings, grouping, sorting, and calculated totals.

A macro is an Access object that can automate certain tasks without requiring you to write a complete VBA program.

Examples:

• Open a form when a button is clicked.
• Display a message.
• Run a query.
• Open a report.

The actions available depend on the macro type and the database environment.

Modules contain Visual Basic for Applications (VBA) code used to build more advanced database functionality.

VBA can help automate tasks, validate information, respond to events, and perform custom calculations.

Modules are useful when built-in Access features and macros do not meet all the application's requirements.

Database objects often work together to complete a task. For example, a student management system may work as follows:

1. A form collects student information.
2. The information is stored in a table.
3. A query retrieves students who meet specific conditions.
4. A report displays the selected student information.
5. A macro or VBA code can automate selected actions.

Imagine you are creating a database for a computer institute. You could create these objects:

• Students Table: Stores student details.
• Courses Table: Stores course information.
• Admission Form: Enters student details.
• Pending Fees Query: Finds students with unpaid fees.
• Fee Collection Report: Displays payment totals.
• Macro: Opens the admission form.

Task: Identify the database objects you would use.

1. Plan a Students table.
2. Plan a Courses table.
3. Describe a form for entering student information.
4. Describe a query for finding students in the ADCA course.
5. Describe a report showing monthly fee collection.
6. Suggest one task that a macro could automate.

1. What are database objects?
2. Name the four main objects in MS Access.
3. What is the purpose of a table?
4. What is a query used for?
5. How does a form help users?
6. What is the purpose of a report?
7. What is a macro?
8. What is a module?
9. How can database objects work together?
10. Which object would you use to print a fee collection summary?