
Home	Excel	Access
\| Feedback \| Books about Access \|

Help using Access databases

This site contains examples of Access queries and also various visual basic functions and procedures which can be incorporated within a database. Some of the procedures are linked to particular event properties on forms and reports. This is not intended to be a complete Access tutorial but will hopefully stimulate some interesting ideas and possibilities.

	Access queries Examples of many queries for selecting, grouping, joining, modifying and totaling data.	Would you like to learn more? Access 2000 developers handbook volume 1
	Reports A reports manager form to allow users to select a report and choose whether to preview, print or export it. Creating a report template which can save time and give your new reports a consistent appearance. Some visual basic code linked to report events
	Bits and Pieces Using an Open dialog box in VBA to select and open other files Defining some program variables such as a department name or default file locations Various bits and pieces Setting status bar messages to be displayed while VBA programs are running Identifying or removing postcodes from addresses An application to record and display bookings of staff absence for an Office - a leave planner	This site also contains detailed help with using Excel spreadsheet functions, charts and exporting data
	Exporting data into applications Creating HTML web pages from access queries Generating XML files to export data Distributing reports via email

You should not place any reliance upon these programs and always thoroughly test all of the code in your databases.

Office
Leave
Planner

an Access database for
recording and displaying
planned staff absences

[View details]

file:accessintro.htm

Page last updated Sep 08

Help using Access databases

Access queries

Examples of many queries for selecting, grouping, joining, modifying and totaling data.

Reports

A reports manager form to allow users to select a report and choose whether to preview, print or export it.

Creating a report template which can save time and give your new reports a consistent appearance.

Some visual basic code linked to report events

Bits and Pieces

Using an Open dialog box in VBA to select and open other files

Defining some program variables such as a department name or default file locations

Various bits and pieces

Setting status bar messages to be displayed while VBA programs are running

Identifying or removing postcodes from addresses

An application to record and display bookings of staff absence for an Office - a leave planner

Exporting data into applications

Creating HTML web pages from access queries

Generating XML files to export data

Distributing reports via email