Introduction to Microsoft Access

MS Access is a relational database management system (RDBMS).

It stores related information in tables and provides tools to work with that information.

Example: A computer institute can use Access to maintain student names, course details, mobile numbers, and fees.

A database is an organized collection of related information.

It allows information to be stored and retrieved efficiently.

Example: A library database may contain book details, member records, and issue information.

MS Access helps reduce manual record-keeping and makes information easier to search and manage.

• Store records systematically.
• Search for specific information.
• Calculate totals using queries.
• Create forms for data entry.
• Prepare reports for printing.

• Table-based data storage.
• Queries for searching and processing data.
• Forms for entering and editing records.
• Reports for presenting information.
• Relationships between related tables.
• Support for macros and VBA automation.

MS Access databases commonly contain four main objects:

• 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.

A table stores data in rows and columns.

Each row represents a record, while each column represents a field.

Example: A Students table may contain StudentID, Name, Course, and Mobile fields.

A record is one complete row of information in a table.

For example, one student's ID, name, course, and mobile number together form a record.

A table can contain hundreds or thousands of records.

A field is a column in a database table that stores one type of information.

Examples include Name, DateOfBirth, CourseName, and Fees.

Every field has a name and a data type.

A query is used to retrieve, filter, calculate, or modify data according to specified conditions.

Example: Find all students enrolled in the ADCA course.

Queries can also calculate totals and combine information from related tables.

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

Instead of entering data directly into a table, users can work through labeled fields and controls.

Example: A Student Admission Form can collect a student's name, address, and course.

A report presents database information in a structured and printable format.

Reports can display grouped records, totals, headings, and calculated values.

Example: A monthly fee collection report shows the payments received during a month.

A primary key uniquely identifies each record in a table.

For example, StudentID can identify each student even when two students have the same name.

A primary key cannot contain duplicate values or Null values.

A relationship connects related tables through matching fields.

For example, a Students table and a Payments table can be connected using StudentID.

Relationships help organize data and maintain consistency between related records.

Modern Access databases commonly use the .accdb file extension.

Older Access database versions commonly used .mdb.

Example: student_database.accdb

The file extension helps identify the database file type.

1. Open the Windows Start menu.
2. Search for Microsoft Access.
3. Open the application.
4. Choose a blank database or an available template.
5. Follow the prompts to create or open a database.

These steps assume MS Access is installed on your computer.

A blank database allows you to build a database from the beginning.

1. Open MS Access.
2. Select Blank Database.
3. Enter a database name, such as StudentManagement.
4. Choose a save location if required.
5. Click Create.

The Access interface contains several areas that help you work with database objects.

• Ribbon: Displays commands and tools.
• Navigation Pane: Lists database objects.
• Object tabs: Help you switch between open objects.
• Work area: Displays the selected table, query, form, or report.

The exact interface may differ between Access versions.

The Ribbon is the command area at the top of the Access window.

It organizes tools into tabs and groups.

Depending on the selected object, you may see commands for creating tables, designing forms, running queries, and generating reports.

The Navigation Pane lists the objects available in the current database.

You can use it to open tables, queries, forms, and reports.

Organizing object names clearly makes a database easier to maintain.

When creating a database, provide a meaningful file name and save location.

Save changes to database objects when prompted.

Use descriptive names such as LibraryManagement.accdb or StudentRecords.accdb.

Keep backups of important databases to protect against accidental data loss.

1. Start MS Access.
2. Select Open or Browse.
3. Locate the required database file.
4. Select the .accdb or supported database file.
5. Open the file and select an object from the Navigation Pane.

Schools, coaching centers, and training institutes can use Access for small database applications.

• Student admission records.
• Course and fee details.
• Attendance information.
• Examination marks.
• Certificate records.

Businesses can use Access to organize day-to-day information.

• Customer and supplier records.
• Product inventory.
• Orders and sales information.
• Employee details.
• Invoice and payment records.

Suitability depends on the application's size, performance requirements, and number of users.

• Provides a graphical interface for database tasks.
• Supports tables, queries, forms, and reports.
• Can connect related tables.
• Supports SQL and VBA for more advanced tasks.
• Useful for many small and medium-sized desktop database applications.

• It is not designed for every large-scale database workload.
• Concurrent users and database size must be considered.
• Its desktop application is primarily designed for Windows.
• Important data still requires backups and suitable access controls.

For larger applications, a server database may be more suitable.

Excel is primarily a spreadsheet application, while Access is a relational database application.

• Excel: Useful for calculations, charts, and spreadsheet analysis.
• Access: Useful for related tables, structured records, forms, queries, and reports.

The best choice depends on the type of information and the task.

Database information may contain private student, customer, or business records.

• Store database files in secure locations.
• Limit access to authorized users.
• Make regular backup copies.
• Protect backup files as carefully as the original.
• Test backups periodically.

Task: Create a database for a computer training institute.

1. Open MS Access.
2. Create a blank database named SooproStudents.accdb.
3. Save it in an appropriate folder.
4. Locate the Navigation Pane.
5. Identify the Ribbon and database work area.
6. Close the database after saving.

1. What is MS Access?
2. What is a database?
3. Name the four main database objects.
4. What is the difference between a field and a record?
5. What is a primary key?
6. Which file extension is commonly used by modern Access databases?
7. How is Access different from Excel?

Microsoft Access is a relational database application used to store and manage structured information.

Its main objects are tables, queries, forms, and reports. Primary keys identify records, while relationships connect related tables.

In the next lessons, you will learn how to create databases, design tables, choose field data types, and manage records.