Apologies for the wall of text. Future edits will likely add screenshots and other visual elements.
Queries in Microsoft Access can be created by any one of four methods
Editing a record value from a query in datasheet view will result in a change in the underlying record value, assuming the query field is not an aggregation or concatenation of multiple sources of information.
Forms and Reports can be used to display information from queries in a form alternative to a simple "Datasheet" view which appears similar to an Excel-style spreadsheet. Forms are targeted to on-screen display, whereas Reports are targeted to those printed on paper.
Microsoft Access is one of the Microsoft Office suite of programs. However, it is only available in some packages of MS Office.
If you wish to obtain Access, please make sure to carefully examine the box or download specifications for each version of Microsoft Office. MS Access is only available for Windows PCs, it is not available on Macintosh systems in the native environment, even through other MS Office programs may be available. Similarly, it is not available for linux operating systems.
In Office 365, Access can be found in the Home, Personal, ProPlus, Enterprise E3 or E5 versions, but not Enterprise E1 nor Business (or B. Essentials, B. Premium).
In Office 2016 it is not included in the Home & Student or Home & Buisness packages, but it is in Professional. It does not appear to be in any versions for the Macintosh.
Microsoft Access has existed since 1992, and older versions continue to see regular use when business-critical database applications have been built on them. A very comprehensive resource summarizing the release history (with links to release notes, where available) is:
Microsoft Access is an Application Generator for developing databases and data-driven applications, primarily for local use. Microsoft Access consists of two main elements:
It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Database applications that have been created with a full version of Microsoft Access can be compiled for distribution and run via a free Microsoft Access Runtime.
The two elements allow Microsoft Access to be used in various ways:
Through Access 2003 (11.0), the built-in database engine was Microsoft Jet. With Access 2007 (12.0), Microsoft introduced a new descendant of the Jet engine, the Access Database Engine (originally called the Access Connectivity Engine and still commonly known as the ACE Engine), and made it the default for new databases. Its feature set and behavior overlaps incompletely with the last version of Jet (4.0). Versions of Access released since have been able to create and work with databases in either Jet (
.mdb ) or ACE (
.accdb ) format, even though Jet has been officially deprecated as a technology.