| The name of the base system (platform): | Microsoft Office |
| Developers: | Microsoft |
| Last Release Date: | 28 April 2010 |
| Technology: | DBMS |
Content |
About Product
Microsoft Office Access or simply Microsoft Access is a relational database of Microsoft Corporation. It has a wide range of functions, including related queries, links to external tables and databases. With the built-in VBA language, Access itself can write applications that work with databases.
Versions
- 1993 Access 2.0 для Windows (Office 4.3)
- 1995 Access 7 для Windows 95 (Office 95)
- 1997 Access 97 (Office 97)
- 1999 Access 2000 (Office 2000)
- 2001 Access 2002 (Office XP)
- 2003 Access 2003 (from the Microsoft Office 2003 suite)
- 2007 Microsoft Office Access 2007 (from the 2007 Microsoft Office Suite)
- 2010 Microsoft Office Access 2010 (from Microsoft Office 2010)
2022: Block macros by default
On February 8, 2022, it became known that Microsoft will block the execution of VBA macroscripts in five Microsoft Office applications by default. Since the beginning of April 2022, users of Microsoft Access, Excel, PowerPoint, Visio and Word will not be able to include macro scripts in unreliable documents downloaded from the Internet. More details here.
2012: MS Access Essentials
As of January 2012, among the main components of MS Access:
- Table Builder
- Screen Form Builder
- SQL Query Builder (SQL language in MS Access does not comply with the ANSI standard)
- Report Builder to print.
They can call scripts in VBA, so MS Access allows you to develop applications and databases almost from scratch or write a shell for an external database.
MS Access is file-server DBMS and therefore only applicable to small applications. There are no a number of mechanisms required in multi-user databases, such as triggers.
Significantly expands the ability of MS Access to write applications, the mechanism of communication with various external DBMS: "related tables" (connection with the DBMS table) and "queries to the server" (query in the SQL dialect, which "understands" the DBMS). MS Access also allows you to build full-fledged client-server applications on the DBMS. MS SQL Server At the same time, it is possible to combine with the inherent simplicity of MS Access tools for management DB and development tools.
Platforms
Programming languages
Links
| The site content is translated by machine translation software powered by PROMT. The machine-translated articles are not always perfect and may contain errors in vocabulary, syntax or grammar. Read original article If you find inaccuracies or errors in the results of machine translation, please write to editor@tadviser.ru. We will make every effort to correct them as soon as possible. |