Microsoft Access Database and its Query Using Global Variable

type="text/javascript">programming language.
Microsoft Access Database supports the makingBesides query application of Microsoft Access
of queries that can be linked to external dataDatabases you are going to learn how to select
sources through the use of ODBC connections ondata in one form and open another form with
the local computer. This enables users to interactmore data related to the field you just selected
with data stored outside the Microsoft Accessby taking advantage of global variables in the
database without using linked Tables. Thequery design form. To help get this, you will use a
Pass-Through is another queries are written usingglobal variable entered in the criteria of a field
the Structured Query language (SQL) syntaxwhile creating the query in the Microsoft Access
supported by the external data source. MicrosoftDatabasequery design form. The result is a
Access Database also offers the ability forpowerful user interface function that allows a user
programmers to create Database driven webto look up more data, or enter more data related
applications by help of the programming language.to a selected record. Users can use it to look up
Access databases offer a Query Designer, apricing histories, addresses, inventory locations,
graphical user interface that allows users toreally anything where you would have more data
create queries without knowledge of the SQLabout a key field in your database.