|
| |
 |
On
Site Training |
|
- Training from £300 a day!
-
All
versions of MS Office covered 2010, 2007, 2003,
XP, 2000, 97
- MS
Office 2010 Upgrade Course
- MS Office 2007 Upgrade Course
- Excel
2010, 2007, 2003 Training
- Access
2010, 2007, 2003 Training
- Project
2007, 2003 Training
- Publisher 2010, 07, 03 Training
- Word 2010, 2007, 2003 Training
- PowerPoint
2010, 07, 03 Training
- Visio
2010, 2007, 2003 Training
- Outlook
2010, 2007, 2003 Training
- Dreamweaver
Training
- Adobe InDesign Training
- Introduction to SEO
- Event Photographer Sussex
|
| Free
Training Materials |
|
|
 |
|
|
Web
design |
|
| |
| If you like this site, let us
create a web site for you.
Contact us for a quote. |
| |
| |
| |
|
|
|
|
Corporate
portraits |
|
|
|
|
|
Microsoft
Office Training throughout West Sussex & East Sussex, Surrey and Hampshire: Horsham, Brighton, Burgess Hill, Chichester, Crawley, Eastbourne, East Grinstead, Haywards Heath, Lewes, Littlehampton, Dorking, Farnham, Godalming, Guildford,Redhill, Reigate, Weybridge Woking, Havant, Petersfield, Portsmouth, Southampton, Winchester, Tonbridge & Tunbridge Wells.
|
|
Access Training: Access
Table Tips |
|
| |
|
Access Table
Tips |
|
A miscellaneous list
of Access Table tips suitable
for experienced users.
Not every tip will apply
to all versions of Access!
TechTutorials
- more free tutorials! |
|
|
TABLES |
|
Zoom
Click into the cell that
you want to enter the
data and press SHIFT F2
Shortcuts for
date and time
Current date CTRL; Current
time CTRL:
Right-align Text
in a Table
Type * in the Format Property
for that field.
Carry Data Forward
From One Record to the
Next
In the field that you
want to copy the entry
from the previous record
in type CTRL’
Updating a Table
with Information from
Another Table
To update data in an existing
field – eg a new
telephone list:
1. Create an Update query
and link the two tables
with a one-to-one relationship
2. Add the field from
your original table that
needs to be updated
3. In the Update to row
enter the following
[New Table Name].[New
Field Name]
4. Run the query
To update a
table with an entirely
new field:
1. Create a Make Table
query including the field
from the table that includes
the new data
2. Run the query
3. Delete the original
table and the table that
held the new data
4. Rename the table that
was created with the Make
Table query so that is
replaces the original
table.
Sorting Multiple
Columns in a Table
1. Re-order the fields
that you want to sort
on so that they are adjacent
to each other and in the
order you want to sort
by (left to right).
2. Highlight the fields
that you want to sort
by
3. Use the sort buttons
on the toolbar
OR
Use an advanced filter.
Hide a Table
The table’s name
must start with Usys To
view the table again:
Tools | Options [View]
System Objects
Copy a table
between databases
Normal copy and paste
– then have the
option to paste structure
and data, just structure
or append data to an existing
table.
Custom Number
Formats
Four parts to the format,
separated by semicolons.
1st – positive number
format
2nd – negative number
format
3rd – zero value
format (information does
not apply)
4th – null field
format (information unknown,
but may apply)
Access Query tips
Access Form tips
Access Report tips
|
|
|
|
|
|
|
|
|
Microsoft
Access Training
offerings |
|
|
|
|
Application
resources |
|
|
|
|
|
