Microsoft Access hints and tips
These tips are for users and developers working in Access 97, Access 2000,
Access XP and Access 2007. Microsoft Access is an easy tool for casual use at the
desktop but is also a powerful relational database. Careful database
design is needed to make the best use of it and we hope that these
tips will help you get the best from Access.
These pages are not an Access tutorial, you will need to know something
about the language to get the most benefit from the tips. They are
provided for your guidance in database development rather than as
solutions to particular problems. Refer to the Access Help system or
MSDN for more detailed information about the commands used.
Hints and tips are listed here alphabetically under seven categories:
Visual FoxPro equivalents
Code and programs
Data and mdb files
Queries and SQL
joins using Access SQL.
with "In" and "Between".
in Access SQL.
records in an Access query.
of Access Query - Modify, Delete and Create Table queries.
Types of join in SQL.
lines on Access reports.
way to make a backup copy of a report or form.
Visual FoxPro equivalents to VBA commands
If you need to know more about working with databases in Microsoft Access
then Alvechurch Data run a series of
to help you.