Microsoft Access Tips

Protect your design

You can compile your database so that users cannot see the design of your tables, forms or reports. This makes a file with extension MDE.

Unmatched query

You can use the Find Unmatched query wizard to show where items occur in one table and not in another.

Create a custom format form

When you create a form design that you like, you can save it as a custom format and use it again and again.

If you like your form and want to use the same set of colours and styles again on another form, you can select Autoformat and click on Customise. With a single action you can create a style from your form, which will be added to the list of available styles when you use the wizard or autoformat.