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.
	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 Document an Access macro to export and list the actions 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 Putting random numbers into query results 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 Using Google Forms to collect survey data
	Exporting data into applications Create an HTML web page with expanding or drill down sections from an Access query Creating HTML web pages from access queries Generating XML files to export data Exporting charts and saving as image files	This site also contains detailed help with using Excel spreadsheet functions, charts and exporting data