Haven't upgraded to Office 2007 yet?
We still have lots of Microsoft Office 2003/XP
classes available and great instructors to teach you! Here
are some upcoming courses that you might be interested in...
Access Introduction ($240) - 3/18
Access Intermediate ($255) - 5/6
Access Advanced Forms & Reports ($325) - 4/28
Excel Intermediate ($255) - 3/23 & 4/22
Excel Advanced Functions, Macros &
Scenarios ($325) - 3/26
PowerPoint Intermediate ($255) - 4/8
|
For our Access users...
Here are some tips that may help you when working with
your data...
- In Access, you can
use filtering
techniques, such as Filter
By Selection and Filter
By Form, to filter data. While applying a filter,
certain characters, such as *, %, and ?, have a special meaning
when specified in a filter text box. To disregard the special
meaning of a character, enclose it in square brackets [], like
this: a[*].
- To change a combo box to a
list box (or vice versa) on your form, right-click
the control, click Change To, and then click the control type that
you want.
- After previewing
your reports in
Access, you can export the results to Word 2007, Excel 2007, or
several other Office programs. On the External Data tab, in the
Export Data group, click the button for the format that you want,
and then follow the instructions in the wizard.
- After you open the
property
sheet for a table, query, form, or report, the
property sheet pane remains open for all objects in Design view
until you close it. Likewise, if you close the property sheet in
Design view, the pane is closed for all other objects in Design
view until you reopen it.
|
Contact Full Circle's instructors by email or by phone at 610-594-9510 if you'd
like us to address a specific software challenge in future Trainer Tip
issues or if you'd like to share your own "tip" with the Full
Circle team. We look forward to hearing from you.
|
