:
MS ACCESS
Microsoft Access (MS Access) is a database management system (DBMS) developed by
Microsoft that allows users to create and manage databases.
It
is used to store, manage, and manipulate data. It combines the relational
Microsoft Jet Database Engine with a graphical user interface and software-development
tools.
- Developer: Microsoft Corporation
- Part of: Microsoft Office Suite
(Professional and Microsoft 365 versions)
- Initial Release: 1992
- Latest Format: .accdb (introduced
in Access 2007)
F Features of MS Access:
- Tables – Where data is stored,
similar to Excel spreadsheets.
- Queries – Used to search, filter,
and manipulate data.
- Forms – Custom input screens for
entering or viewing data.
- Reports – Used to format,
summarize, and print data.
- Macros and VBA (Visual Basic for Applications) – For automating tasks and adding advanced functionality.
¯
F Here's
a more detailed breakdown:
Access is a DBMS, meaning it's designed to handle the storage, retrieval, and management of data.
Relational Database:
It utilizes a relational database model, which means data is organized into tables with relationships between them, allowing for efficient data storage and retrieval.
Access provides a visual interface for creating and interacting with databases, making it easier for users without extensive programming experience to work with data.
Development Tools:
Access includes tools for creating custom forms, reports, and even automating tasks using macros and Visual Basic for Applications (VBA).
Part of Microsoft Office Suite:
While it can be purchased separately, Access is also a component of the Microsoft Office suite, often included in professional editions.
Data Storage:
Access stores data in its own file format (based on the Access Database Engine, previously known as Jet Database Engine), but it can also import or link to data from other sources.
F Uses:
Access is used for a variety of purposes,
including:
- Tracking customer information.
- Managing inventory.
- Organizing research data.
- Developing custom business applications.
- Creating reports and dashboards.
F Main
Features of MS Access:
1. User-Friendly Interface
- Graphical user interface (GUI) with drag-and-drop design.
- Easy for non-programmers to create and manage databases.
2. Tables
- Stores structured data in rows and columns.
- Each table can have fields with specific data types (text,
number, date, etc.).
3. Queries
- Use SQL or Query Design View to extract or manipulate
data.
- Supports select, update, delete, and append queries.
- Can perform calculations, filtering, and joins between tables.
4. Forms
- Customized data entry interfaces for users.
- Can include buttons, dropdowns, and validation rules.
5. Reports
- Generate formatted output (invoices, summaries, print-ready
reports).
- Easy to design using drag-and-drop tools.
6. Macros
- Automate tasks and actions (like opening a form or running a
query).
- No programming knowledge needed — uses a simple action list.
7. VBA (Visual Basic for Applications)
- Full programming language for advanced automation and
customization.
- Allows creation of complex business rules and interfaces.
8. Relational Database Model
- Support for primary keys and foreign keys.
- Enforces data integrity through relationships between tables.
9. Data Import/Export
- Can import/export data from Excel, SharePoint, SQL Server,
ODBC, and more.
- Easy integration with other Microsoft Office tools.
10. Multi-User Support
- Can be split into front-end (forms, queries, reports)
and back-end (data) for multiple users.
- Works well in small local networks (not ideal for large,
internet-based systems).
11. Templates
- Comes with pre-built database templates (e.g., contacts,
inventory, task management).
- Saves time for common business needs.
¯
(TABLE
DESIGN) ENTRY THE FIELD NAME ACCORDING TO YOUR TABLE:
