Microsoft Access LTSC 2021
by Build and share a database in seconds
Create apps, utilize databases & store data in SQL Server
$156.00 /One Time
With Access, you can build a database without writing code or being a database expert. It lets you build and share a database in seconds. You supply the information and Access does the rest, making it easy to create and structure your data. Reports and queries put your data into the format you want, so your applications consistently look great. It provides well-designed templates and you can instantly create forms for simple data entry and summarize them in grouped and summary reports. Dozens of Wizards make it easy to get started and get productive.
Top Features
Create and share apps without being a developer
Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.
Customize apps to grow with your business
Tailor your custom apps to your business and your customers, easily editing as needed to meet evolving needs. Using Visual Basic for Applications, automate business processes and create more useful forms and reports.
Integrate with multiple data sources
Integrate data between Access and line-of-business apps using the Access connector library to generate aggregated visuals and insights in the familiar Access interface. Easily store data in SQL Server and Microsoft Azure SQL to enhance reliability, scalability, security, and long-term manageability.
Recommended products
Add tables with fewer clicks
Use the Add Tables task pane, which stays open while you work, to add tables to relationships and queries.
Keep tabs on your database objects
You can clearly see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.
Refresh, relink, or remove linked tables
The updated Linked Table Manager is a central location for viewing and managing all data sources and linked tables in an Access database. From time-to-time you may need to refresh, relink, find, edit, or delete linked tables. This is because of changes to the data source location, table name, or table schema.
The date/time extended data type has better precision
We’ve implemented the DateTime2 data type into Access to enhance syntax compatibility with SQL to increase accuracy and level of detail in records that include dates and times. The DateTime2 data type includes a larger date range (0001-01-01 through 9999-12-31) with higher-specified time precision (nanoseconds, rather than seconds).
Dark theme support
The dark gray and black themes are perfect for those who prefer a softer take on high-contrast visuals.
Improvements to SQL view
Use the Find and Replace dialog box in SQL View to search for and replace text in an SQL statement, which is especially useful for long statements.
Improvements to the query designer
We’ve added new time-saving options for table objects. In Query Design View, right-click to select Open, Design View or Size to Fit.
Improvements to the relationships window
Quickly adjust the table size to reveal additional fields and relationships, select a subset of tables and relationships, and scroll horizontally and vertically by using the mouse scroll wheel.
Additional Information
Terms & Conditions
Terms of Service
https://www.microsoft.com/licensing/docs/customeragreementPrivacy Policy
https://privacy.microsoft.com/en-us/privacystatement