What is MS-Access
• MS-ACCESS is a popular database management
system (DBMS) developed by Microsoft.
• MS-Access is a database management system
that allows users to create, design, and manage
databases.
• It is a part of the Microsoft Office suite and is
widely used for small to medium-sized
databases.
Set By:Berhanu E @wonji Didimtu
Sec.School
Key Features of MS-Access:
• Database Design: MS-Access allows users to
design and create databases using a visual
interface.
• Data Storage: MS-Access stores data in a
database file that can be accessed and managed
using the application.
• Querying: MS-Access allows users to create
queries to retrieve and manipulate data from the
database.
• Reporting: MS-Access provides tools for creating
reports and visualizing data.
• Security: MS-Access provides features for
securing databases, including user authentication
and access control.
Set By:Berhanu E @wonji Didimtu
Sec.School
Basic Database Concepts:
• Tables: A table is a collection of related data stored
in a database. Each table has rows and columns, with
each column representing a field or attribute.
• Fields: A field is a single piece of data stored in a
table, such as a name, address, or phone number.
• Records: A record is a single row in a table,
representing a single instance of the data.
• Primary Key: A primary key is a field or
combination of fields that uniquely identifies each
record in a table.
• Relationships: Relationships are used to link tables
together, allowing users to access and manipulate
data across multiple tables.
Set By:Berhanu E @wonji Didimtu
Sec.School
MS-Access Interface:
• Database Window: The database window is
the main interface for working with the
database, displaying a list of tables, queries,
forms, and reports.
• Navigation Pane: The navigation pane
provides a list of tables, queries, forms, and
reports, allowing users to navigate the
database.
• Object List: The object list displays a list of
objects in the database, including tables,
queries, forms, and reports.
Set By:Berhanu E @wonji Didimtu
Sec.School
Basic Operations:
• Create: Creating a new database, table, query,
form, or report.
• Read: Retrieving data from a table or query.
• Update: Editing or modifying existing data in a
table.
• Delete: Deleting data from a table or query.
• Execute: Running a query or macro to perform
an action.
Set By:Berhanu E @wonji Didimtu
Sec.School
Creating a New Database
• Click on StartMS-officeMS-Access then
• Click on Blank Database to create a new
database.
• Enter a name for your database in the File name
field.
• Choose a location for your database file.
• Click Create to create the new database.
Set By:Berhanu E @wonji Didimtu
Sec.School
