Microsoft Access 2021

Create a small business database, simplify data entry with forms and use queries and reports to retrieve and summarize records. Microsoft Access 2021 is Microsoft's desktop database: build related tables, queries, data-entry forms and printable reports, automate them with macros and VBA, and link data from Excel, SQL Server and ODBC sources. The 2021 release adds the Date/Time Extended data type, an updated Linked Table Manager and tabs for open database objects. Start with tables to hold the records, then use queries to select or summarize information. Forms give users a clearer data-entry surface, while reports turn stored records into material that can be read, printed or shared. Related tables help avoid repeating the same information throughout a database and make it possible to bring different record types together. A useful Access project therefore involves both data design and interface design. Think about how records relate, which fields users need to enter and which questions the reports must answer. This is a desktop database workflow, not a claim that a hosted database service or server licence is included. Existing databases and add-ins should be checked against this release before migration. Microsoft support for Access 2021 ends on 13 October 2026, after which it no longer receives security updates.

Features

• Related tables and queries
• Data-entry forms and reports
• Macros and VBA
• Link Excel, SQL Server and ODBC data