1. Define MS Access

MS Access is a Database Management System (DBMS) developed by Microsoft that combines:

  • a relational database engine
  • with a graphical user interface (GUI)

It is part of the Microsoft Office Suite and is used to:

  • store data
  • manage data
  • retrieve data efficiently
2. File Extension of MS Access

The file extension of an MS Access database is:

👉 .accdb

Meaning:

  • Represents a desktop database file
  • Stores:
    • tables
    • queries
    • forms
    • reports
    • other database objects
3. Components of MS Access

The main components of MS Access are:

  • Tables → store data
  • Queries → retrieve/filter data
  • Forms → user interface for data entry
  • Reports → formatted output
  • Macros → automate tasks
  • Data Macros → operate on table data
  • Modules → advanced programming (VBA)

👉 All these components work together to manage and organize data efficiently

4. Steps to Create a Form in MS Access

Procedure:

  1. Go to Create Tab
  2. Select Form or Form Wizard
  3. Choose Table/Query
  4. Select required Fields
  5. Set Layout Options
  6. Click Finish

👉 A form is created for easy data entry and viewing

1. Explain the Components of MS Access

Microsoft Access stores information as a database and treats anything that can have a name as an object. The main objects include:

a) Tables
  • Basic object in MS Access
  • Stores data in rows (records) and columns (fields)
  • Example: StudentID, Name, Age, Class
b) Queries
  • Used to retrieve and filter data
  • Types: Select queries, Action queries
  • Example: Students scoring above 90 marks
c) Forms
  • User-friendly interface for data entry and editing
  • Example: Student Entry Form
d) Reports
  • Used for formatted output and printing
  • Example: Sales Report
e) Macros
  • Automate repetitive tasks
  • Example: Auto opening a form
f) Data Macros
  • Work directly on table data
g) Modules
  • Advanced programming using VBA

👉 Together, these components help in efficient data management and automation

2. Process of Creating a Database in MS Access
Steps:
  1. Open MS Access
  2. Select Blank Desktop Database
  3. Enter database name
  4. Click Create
  5. Default table is created
Creating Table
  • Add fields and rename them
  • Example: ArtistID, ArtistName
  • Save table with a name
Working After Creation
  • Enter data in Datasheet View
  • Design structure in Design View
  • Define Field Name, Data Type, Description

👉 Process: Open → Create → Name → Configure → Save → Enter Data

3. Data Types, Primary Key and Indexes
📌 Data Types
  • Short Text → up to 255 characters
  • Long Text → large text
  • Number → numeric values
  • Date/Time → date and time
  • Currency → money values
  • AutoNumber → auto-generated unique values
  • Yes/No → Boolean values
  • Attachment → files
  • Hyperlink → URLs
  • Calculated → computed values
📌 Primary Key
  • Uniquely identifies each record
  • No duplicate or NULL values
  • Example: StudentID
Role:
  • Ensures uniqueness
  • Prevents duplicates
  • Supports relationships
  • Creates index automatically
📌 Indexes
  • Improve search and sorting speed
  • Options: No, Yes (Duplicates OK), Yes (No Duplicates)
Role:
  • Faster data retrieval
  • Better organization
  • Controls duplicates

👉 Data types control what data is stored, while keys and indexes control accuracy and performance

4. Import and Export Data in MS Access
📌 Importing Data
  • Import from spreadsheets, text files, databases
  • Option to link external data
📌 Exporting Data
  • Export to Excel, Word, other databases
  • Useful for sharing reports
📌 Data Sharing & Integration
  • Supports ODBC (SQL Server, Oracle, DB2)
  • Connects multiple systems
📌 Importance
  • Saves time
  • Improves consistency
  • Reduces duplication
  • Supports real-world applications

👉 Access enables efficient data sharing and integration across platforms