MICROSOFT ACCESS

Domain	Definition
Computing	Microsoft Access 1. A relational database running under Microsoft Windows. Data is stored as a number of "tables", e.g. "Stock". Each table consists of a number of "records" (e.g. for different items) and each record contains a number of "fields", e.g. "Product code", "Supplier", "Quantity in stock". Access allows the user to create "forms" and "reports". A form shows one record in a user-designed format and allows the user to step through records one at a time. A report shows selected records in a user-designed format, possibly grouped into sections with different kinds of total (including sum, minimum, maximum, average). There are also facilities to use links ("joins") between tables which share a common field and to filter records according to certain criteria or search for particular field values. Version: 2 (date?). Usenet newsgroup: news:comp.databases.ms-access. 2. A communications program from Microsoft, meant to compete with ProComm and other programs. It sucked and was dropped. Years later they reused the name for their database. [Date?] (1997-07-20). Source: The Free On-line Dictionary of Computing.
Source: compiled by the editor from various references; see credits.

Specialty Definition: Microsoft Access

Microsoft Access is a database management system from Microsoft, packaged with Office which combines the "Jet" relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmer "power users" to build sophisticated "front-ends" to complex databases.

One of the major benefits of Access from a programmer perspective is its relative compatibility with SQL--queries may be viewed and edited as SQL statements. Otherwise, it uses VBA for programming forms and logic. The report writer in Access is similar to the other popular database report writer - Crystal Reports but the two products are vastly different in their approach. MSDE (Microsoft SQL Server Desktop Engine) 2000, a cut-down version of MS SQL Server 2000, is included with the developer edition of Office XP and may be used with Access as an alternative to the Jet Database Engine.

Access is commonly used by small businesses and hobby programmers to create customised systems for handling small tasks (Microsoft Access Development). Its cut and paste functionality can also make it a useful tool for connecting between other databases (eg Oracle and SQL Server) during data or database conversions.

Unlike complete RDBMSs it lacks Triggers and Stored Procedures.

See: Microsoft Office

Microsoft Access was also the name of a communications program from Microsoft, meant to compete with ProComm and other programs. It proved a failure and was dropped. Years later they reused the name for their database.

[Date?] Part of this article was originally based on material from FOLDOC, used with permission. Update as needed.

Commercial Usage: MICROSOFT ACCESS

Domain	Title
Books	Microsoft Access 2002 for Dummies (reference) Microsoft Access Developer's Guide to SQL Server (reference) Microsoft Access Version 2002 Step by Step (reference) Special Edition Using Microsoft Access 2000 (reference) (more book examples)

Periodicals	Working Smarter With Microsoft Access - 2000 (reference) (more periodical examples)

Theater & Movies	Microsoft Access 97 (reference) (more DVD examples; more video examples)

High Tech	Microsoft Access 2002 (reference) (more camera examples; more video game examples; more computer examples; more electronic examples; more software examples)
Source: compiled by the editor from various references; see credits.

Frequency of Internet Keywords: MICROSOFT ACCESS

Anagrams: MICROSOFT ACCESS

Scrabble® Enable2K-Verified Anagrams
	Words within the letters "a-c-c-c-e-f-i-m-o-o-r-s-s-s-t"
	-5 letters: costmaries, misfeasors, ostracises, ostracisms, sarcosomes.
Source: compiled by the editor from various references; see credits. SCRABBLE® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro.

Alternative Orthography: MICROSOFT ACCESS

Hexadecimal (or equivalents, 770AD-1900s) (references)

4D 49 43 52 4F 53 4F 46 54 41 43 43 45 53 53

Leonardo da Vinci (1452-1519; backwards) (references)

Binary Code (1918-1938, probably earlier) (references)

01001101 01001001 01000011 01010010 01001111 01010011 01001111 01000110 01010100 00100000 01000001 01000011 01000011 01000101 01010011 01010011

HTML Code (1990) (references)

&#77 &#73 &#67 &#82 &#79 &#83 &#79 &#70 &#84 &#32 &#65 &#67 &#67 &#69 &#83 &#83

ISO 10646 (1991-1993) (references)

004D 0049 0043 0052 004F 0053 004F 0046 0054 0041 0043 0043 0045 0053 0053

Encryption (beginner's substitution cypher): (references)

Expression	Frequency per Day	Expression	Frequency per Day
microsoft access	2,045	microsoft access sample	19
microsoft access tutorial	241	microsoft access program	18
microsoft access help	162	microsoft access software	18
microsoft access 2000	156	microsoft access example	18
microsoft access training	115	microsoft access class	17
microsoft access template	95	microsoft access manual	16
microsoft access database	75	learning microsoft access	16
microsoft access 97	65	learn microsoft access	15
microsoft access 2002	62	microsoft access database template	15
microsoft access download	47	free microsoft access database	15
free microsoft access tutorial	39	microsoft access report	14
microsoft access xp	35	microsoft access code	14
microsoft access tip	32	microsoft access password	14
microsoft access web	31	microsoft access viewer	14
microsoft access sample database	26	microsoft access runtime	13
microsoft access form	25	microsoft access query	13
free microsoft access	24	microsoft access 2000 tutorial	12
use microsoft access	23	microsoft access consultant	11
free download microsoft access	22	microsoft access downloads	11
microsoft access programming	21	microsoft access for dummy	11
Source: compiled by the editor from various references; see credits.

MICROSOFT ACCESS

Specialty Definition: MICROSOFT ACCESS

Specialty Definition: Microsoft Access

Crosswords: MICROSOFT ACCESS

Commercial Usage: MICROSOFT ACCESS

Books

Periodicals

Theater & Movies

High Tech