MICROSOFT ACCESS 2021

MS Access 2021 standalone program

Microsoft Access 2021 is a powerful database management system that can be used to create and manage complex databases according to individual requirements. Not only Excel, XML and dBASE files can serve as data sources, but also the contents of PDF documents and e-mails can be used. These are imported via corresponding forms and then evaluated by the tasks defined by means of macros and filters. MS Access can also process large strings of numbers, which are common in professional calculations. Access 2021 also informs the user about all important details with individually configurable reports, thus keeping them up to date at all times, whether for business or private purposes.

For the common work on a data base Access 2021 offers also the comprehensive administration of individual access rights, both for the view or their respective use. Thus it made an efficient project work possible. Optionally, in addition to the local storage of data, there is also the alternative of storing them centrally and at the same time securely in the cloud to provide access via the web.

The program Microsoft Access 2021 is usually an integral part of an Office package and therefore not available singularly - at Wiresoft, however, you can buy it as a standalone program, and at a particularly low price.

Innovations in Access 2021

With the purchase of Access 2021 you receive the current version of this extensive office program, which has many improvements in detail as well as completely new functions in addition to the usual features.

Visualization of Access data with new chart types

In Access 2021 11 new diagram types are available to visualize data in forms and reports. Individual fields can also be easily adapted to the dimensions of a diagram and the changes immediately displayed in the preview. It is also possible to create interactive diagrams, for example by selecting a different category field in a form or report filter. The following diagram types are available in Access 2021 , among others:

• Line chart: This type displays all categories evenly distributed along the horizontal x-axis and all values evenly distributed along the vertical y-axis.
• Barchart: This displays the categories along the horizontal axis (x-axis or property axis), and the values along the vertical axis (y-axis or property values).
• Bar chart: Here the categories are arranged along the y-axis, and the values along the x-axis, with the positions of the "Axis" and "Values" dimensions reversed.
• Piechart: In this chart type, the categories are displayed as individual segments of a circle, and the data values are displayed as a percentage of the total value (complete circle).
• Composite chart: Here two or more chart types are combined to visualize relationships between different data, e.g. as a column chart and as a line chart.

Support of the data type "Big Number" (BIGINT)

With the data type BIGINT - "Big Number" - now also big numbers can be calculated, this stores thereby a non-monetary numeric value, which is added in an Access table as a field, or is imported also by the linkage with a data base of the appropriate type (e.g. SQL server).The data type "Big Number" offers thereby with eight bytes a much larger range (-2^63 to 2^63-1) for computations than the data type "Number" with four bytes (-2^31 to 2^31-1). It should be noted that enabling the BIGINT data type makes an Access database incompatible with earlier versions of Access.

Simple sorting of property sheets

Previously, finding a particular property among many others in the Properties window often presented a problem, especially when contained in forms and reports spread across multiple tabs. In Access 2021 all properties can now be displayed alphabetically by clicking on the sort function, making the search particularly easy and at the same time fast. With the second click, all properties are displayed again in the default setting.

New property "Designation name" in the controls

The "Designation Name" property, which is newly available in Access 2021, now makes it much easier to enter the name of a control in order to assign a designation control to it. This ability to associate a designation name with a control also improves accessibility, as they can now be recognized and specified by assistive technologies.

Optimized repetition of an ODBC connection

Connections between a Microsoft Access database and an external data source, such as Microsoft SQL Server, made using the Open Database Connectivity protocol (ODBC) could previously only be reestablished by first closing the Access database in the event of an interruption, since Access in older versions did not attempt to reestablish the deleted connection to the external data source.

Access 2021 offers an improved solution here, where first an error message is displayed with a description of the error. Then Access automatically tries to reconnect to the data source whenever an operation is performed that reuses such data or objects that require an ODBC connection. As a result, closing and reopening Access is no longer strictly necessary.

Accessibility improvements in Access 2021

The accessibility of Access has also been significantly improved in the new version to facilitate access for as many users as possible. Many of these improvements were made by optimizing individual specific Access functions in detail, but also more general features to make working with Access as efficient as possible, this is done especially by enhancements to speech output and the optimized integration of Assistive Technology.

Optimization of speech output functions

Speech output now recognizes additional controls that are called in forms, reports and data sheets:

• Reading column names in table and query and form data sheets using speech output has been simplified.
• The expanded or reduced status of lookup fields and combo boxes is also recognized and can thus be read.
• The "Lookup field" or "Combination field" rows can now also be recognized and read for multiple columns.
• In a dialog box, names of option groups with the status "selected" or "deactivated" are now recognized and read.
• In a datasheet, the arrow symbol of a filter for a column can also be recognized and read.
• The comment function of controls in a specific form section has been improved.
• In scan mode, navigation by clicking left or right to get to a radio button has been improved; pressing the space bar toggles it.

Improvements when using the High Contrast mode in Access 2021

• The Filter button is displayed in the navigation bar of a record or form.
• In the Manage Data Tasks dialog box, the External Data tab displays saved imports.
• Column headers as well as command buttons are now displayed in datasheets.

Other accessibility enhancements in Access 2021

Using keyboard shortcuts when working with Access databases not only helps users to work more efficiently. Especially for users with limited vision or mobility, they are a great help and indispensable alternative to mouse-based work. The execution of individual actions inAccess 2021 is further enhanced by the use of new keyboard shortcuts:

• The key combination alt + H creates a table.
• Clicking Q opens the filter of a table column.
• The key combination FD opens the Find and Replace dialog box.
• Clicking the key combination shift + F6 scrolls through all sections in a popup form.
• Editing a new value list item is easier: to do this, the Lookup Wizard creates three different types of lists to choose from: a lookup field, a value list field, or a multi-value field.
• The key combination ctrl + E opens the Edit List Items dialog.

dBASE files are supported again

Access 2021 supports .dbf type files again, they can now be re-imported or linked or exported.

Improvements in the "Tell me" wizard

Access 2021 also offers the possibility to receive suggestions from Access for certain tasks or queries. By entering appropriate terms in the "Tell Me" field in the top ribbon, corresponding options are displayed. Simple questions are answered directly in the window; for more complex questions, "Tell Me" suggests those helps that best match the search term.

System requirements for Access 2021

Access 2021 is available in both 32 bit and 64 bit versions. As a result, individual hardware requirements may differ.

• Operating system: Windows 10, Windows 11, Windows Server 2019 or Windows Server 2022
• Processor: min. 1.6 GHz or faster
• RAM: min. 4 GB RAM
• Hard disk: min. 4 GB available space
• Graphics: min. 1280 x 768, DirectX 9 or higher with WDDM 2.0 or higher for Windows 10

Buy Access 2021 as a standalone office program at a reasonable price from Wiresoft

MS Access is usually an integral part of the respective Microsoft Office suites and therefore not easily available individually as a purchase version. At Wiresoft you can buy MS Access 2021 as a stand-alone program - unlike many other software retailers - and at a very low price!

Your further big advantage: When purchasing this single user license, you neither have to enter into a long-term and usually expensive subscription commitment, nor do you have to accept a time limit on usage. Therefore, it is definitely worthwhile to purchase Access 2021 as a single user program from Wiresoft, as you will not have to download any updates at a later date that are subject to a charge.

The Access single-user license offered is identical in terms of functionality to the version included in Office Suite 2021. This means that not only smaller companies but also freelancers can benefit from all the advantages of the new Access 2021 - and save money in the process.

In addition to Access 2021, you can buy not only older previous versions of it, but also many other Microsoft software licenses in the Wiresoft Software Shop at a special price. These are always original Microsoft products. They were usually part of a volume license from a company or their usage rights were released again with the resale. However, this does not restrict their usability, nor do you as a buyer enter a legal gray area. Because with the purchase by Wiresoft the previously installed software including license was deleted, so that this is free again and usable by a new user. As a serious software dealer Wiresoft offers all Microsoft products exclusively as pure full versions, which are therefore unlimited and 100% usable.

If you have any questions about Access 2021 or any other Office program, please contact us by e-mail, phone or chat and benefit from our competent advice.