- CALCULATEDD FIELD FOR EXPRESSIONS*
- DATA BASE TOOLS FOR CONNECTING PRIMARY KEYS OF TWO TABLES THROUGH THE RELATIONSHIPS TAB
Microsoft Access is a database management system (DBMS) from Microsoft that combines the Microsoft Jet Database Engine with a graphical user interface (GUI) and software-development tools. Some key features of Access include:
-
Easy creation of databases
- Access provides templates and wizards to help create tables, queries, forms and reports for tracking data.
- This allows databases to be set up quickly without programming.
-
Drag-and-drop interface
- Fields, controls and layouts can be added to forms and reports by dragging and dropping.
- This makes building interfaces intuitive.
-
Relational databases
-
Access uses relational databases, which allow data to be linked and queried across multiple tables. Relationships between tables can be set up to join and retrieve related data.
-
Custom forms and reports
- Forms are used to view, enter and edit data in a database.
- Reports summarize data and can be formatted with grouping levels, images and charts.
- Forms and reports can be easily customized in Access.
-
Queries
- create queries that filter, sort, calculate and retrieve specific data.
- Parameter queries allow criteria to be specified at runtime.
-
Macros for automation
- Macros can automate tasks like running queries, opening forms and printing reports.
- This allows some basic programming without complex code.
-
Import and export capabilities
- data to various sources like Excel, XML, SharePoint lists and other database formats.
- integrating data between Access and other programs.
-
Security
- Password protection and encryption can be used to secure Access databases.
- Users’ permissions can be controlled.
So in summary, Access makes database creation and management easier for non-technical business users without sacrificing advanced relational database features. The visual tools and interface help build full-featured databases and applications.