Difference between revisions of "Microsoft Access"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search
 
(format updating & tidying)
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Computing]]: [[Software]]: [[Microsoft Access]]{{seedling}}
+
<hide>
[[Microsoft Access]] is a software application that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)|IDE]], and forms designed to allow easy display and editing of database records.
+
[[page type::article]]
==Weaknesses==
+
[[thing type::software]]
The following apply to Access 97 and may not apply to later versions:
+
[[category:software]]
* Although it is possible to write functions to translate source data into a different display format, it is not possible to write corresponding routines to translate user data-entry back into source data. It is not possible, therefore, for the user to edit data in a form or query if it has been manipulated in certain ways, including fields in queries above a certain level of complexity as well as any data which is the result of a function.
+
[[category:Microsoft]]
* Data from some sources (tentatively: queries of a certain complexity or higher, or possibly certain types of JOINs) cause data in continuous forms to be formatted improperly. The user has to manipulate the form in certain ways in order to restore the display.
+
</hide>
* There are no tools for recovering data from a corrupted database file (.mdb)
+
==About==
 +
[[Microsoft Access]] is a software application published by [[Microsoft]] that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)|IDE]], and forms designed to allow easy display and editing of database records. Access projects use the [[.mdb]] file extension for storing data and other project information, and [[.ldb]] for file-locking data.
 +
==Related Pages==
 +
* '''Versions''':
 +
** [[Microsoft Access 97]] (8.0)
 +
* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition|Professional Edition]] [[office suite]], though it can also be purchased separately
 +
* [[MS Access and MySQL]]: using MS Access with [[MySQL]] as a back-end
 +
==Links==
 +
* {{wikipedia}}

Latest revision as of 19:35, 11 October 2019

About

Microsoft Access is a software application published by Microsoft that combines a database engine, a programming language (VBA) and IDE, and forms designed to allow easy display and editing of database records. Access projects use the .mdb file extension for storing data and other project information, and .ldb for file-locking data.

Related Pages

Links