Access Tips
 Try
this tip to create a clever link to Word, Excel or PowerPoint file. First, make
sure that you have a hyperlink field in your database. Now you can select a
particular paragraph in your other office file, and Ctrl click and drag it to
your hyperlink field in the database. When you click the hyperlink in Access,
the other office document will open with the relevant bit selected.
 To
create a single column report that shows multiple snaking columns, display the
report and go to the File menu and select Page Setup. Click on the Columns
tab and specify the number of columns you need and, if desired, the size of
those columns
 To
automatically add new controls to a form formatted in a particular way, format
an existing control in your chosen format and then go the Format Menu and select
Set Control Defaults
 To
quickly save a record without having to leave it, press Shift Enter.
Sometimes
it can be hard to see what you are doing when entering a large piece of
information into a small field. To give yourself more space, either right click
o the field and choose Zoom, or press Shift F2.
Click OK when you have finished.
To
format fields on a form with conditional formatting, in Form View, click into
the field and select "Conditional Formatting". In the Conditional
Formatting window, select the criteria and then select the formatting you want
on that field if the criteria is true. |
01403 786740
Download course details
Request
a quote for this course
Introduction to the Access Environment