Leírás
Microsoft Access 2021 is a database management application for creating, organizing, querying, and presenting structured data. Build custom databases with connected tables, forms, queries, and professional reports.
Microsoft Access 2021 Key FeaturesCreate and structure relational databases for business, educational, and personal projects.
Organize information using tables, relationships, forms, queries, and reports.
Add tables to queries and relationships through the persistent Add Tables task pane.
Manage external data sources and linked tables with the updated Linked Table Manager.
Use the Date/Time Extended data type for improved SQL compatibility and greater precision.
Search and replace text directly within long statements in SQL View.
Navigate database objects using clearer, rearrangeable tabs.
Work with improved Query Designer and Relationships Window controls.
Choose dark gray or black interface themes.
Enter hexadecimal color values when customizing database elements.
Create Structured Relational DatabasesMicrosoft Access 2021 helps users turn collections of information into organized relational databases. Tables store individual records, while relationships connect related information and reduce unnecessary duplication. This structure is suitable for managing contacts, inventory, orders, projects, assets, and other recurring business data.
Find and Present InformationQueries help users filter, combine, calculate, and examine stored information without manually reviewing every record. Forms provide practical interfaces for entering and updating data, while reports transform selected records into clear layouts that can be reviewed, printed, or shared.
Manage Linked Data SourcesThe updated Linked Table Manager provides a central location for viewing and maintaining linked tables and their data sources. Users can refresh, relink, edit, or remove connections when the source location, table name, or database structure changes.
Improved Database Design ToolsAccess 2021 introduces workflow improvements for database development. Users can add tables with fewer clicks, resize and navigate relationship diagrams more easily, rearrange open object tabs, and use Find and Replace in SQL View when editing complex statements.
Who will like Microsoft Access 2021Small businesses building custom databases without a dedicated development team.
Office professionals managing structured operational or administrative information.
Analysts creating queries, forms, and reports from connected datasets.
Teams maintaining inventory, customer, project, order, or asset records.
Students and educators learning relational database concepts.
Experienced Access users upgrading from an earlier perpetual version.