A collection of access tutorials

Building a Data Dictionary in Access 97(access tutorials)

A great deal of information can be stored in table definitions of Access databases. This information can be easily extracted to build documentation for a database or a data dictionary for a query builder. In this article, we demonstrate how to navigate Access Database tabledef structures to build a data dictionary for an Access application.

Access allows a developer to store descriptions of fields in the table design with the field definition. Other useful information that can be stored are the

• caption (which is the default label for the field),
• rowsource for fields that will be edited and displayed using listboxes and combo boxes
  field data type
• field default value
• validation rule
• and many more.

 Full Article

 Adding Custom Filtering and Search Functionality to a Pageaccess tutorials)

Summary: This article explains how to add "group filter control" functionality to two or more drop-down list boxes, and Find dialog box functionality to a data access page. (6 printed pages)

Full Article

Access tutorial

These words are used often in Access so you will want to become familiar with them before using the program and this tutorial.

A database is a collection of related information.
An object is a competition in the database such as a table, query, form, or macro.
A table is a grouping of related data organized in fields (columns) and records (rows) on a datasheet. By using a common field in two tables, the data can be combined. Many tables can be stored in a single database.
A field is a column on a datasheet and defines a data type for a set of values in a table. For a mailing list table might include fields for first name, last name, address, city, state, zip code, and telephone number.
A record in a row on a datasheet and is a set of values defined by fields. In a mailing list table, each record would contain the data for one person as specified by the intersecting fields.
Design View provides the tools for creating fields in a table.
Datasheet View allows you to update, edit, and delete in formation from a table.

Full Article

Working with ASP & MS Access (access tutorials)

Summary:
Learn to add, remove and modify data from an Access database.

Intro:
There have been a lot of requests for this topic, and it won last weeks voting, so here it is.

The code:
Let's start coding! First you will need a populated database. You can download the source code for this demo, and use the included database.

 Full article

 Developer Considerations When Choosing a File Format in Access 2002

Introduction

Unlike the previous versions of Microsoft® Access, users who upgrade to Access 2002 don't need to convert files created with Access 2000 to a new format in order to continue using them. Files in Access 2000 file format—both databases (.mdb) and Access projects (.adp)—can now be used directly in an Access 2002 application by utilizing the default Access 2000 file format. Conversely, files developed with Access 2002 using the default Access 2000 file format can be used in Access 2000 without conversion. This makes developing and deploying applications in a mixed Access 2000 and Access 2002 environment much simpler than in previous versions of Access.

However, there are limitations you should be aware of when using Access file formats earlier than Access 2002 and when developing in this sort of mixed environment. This article describes the rationale behind the two file formats and the issues associated with developing and using files in each of these formats.

Why the New Choice?

When you want to use Access 2002-specific features and ensure that only Access 2002 users can open your files, you should use the Access 2002 file format. For example, in a corporate environment with only Access 2002 installed on all of the desktop machines, you would want to make sure that you developed your applications using the Access 2002 file format.

The primary goal for making Access 2000 the default file format in Access 2002 was to provide Access 2000 users with the ability to upgrade and continue using their existing databases and Access projects without interruptions or conversions. In an environment with both Access 2000 and Access 2002 installations, the default Access 2000 file format ensures that your users will still be able to share files. The following table shows the compatibility between file formats from a particular version of Access and other versions of Access. "Yes" in this case means that the file can be used in the application without conversion.

 Full article