|
|
|
|||||||
|
FREE OFFICE EBOOK TUTORIAL DOWNLOAD LINDA'S OFFICE SAMPLER see screenshots and instructions here
|
|
Access |
|||||||
|
If you want some good instruction in Access, check out James La Borde's articles in my newsletter, ABC ~ All 'Bout Computers. Getting ready for Access 2007? Check out Microsoft's Access 2007 Interface Guide, which will show you what to expect. Need to view an Access report and you don't have Access installed? You can download Microsoft's free viewer here. Want to add a title page to a report in Access 2000? If your report needs a title page, don't go to the trouble of typing one up separately--use the report's header. First, add any text and graphics you need for your title page in the report's header section. Then set the section's Force New Page property to After Section. By doing so, you'll force Access to print the report's header on a separate page instead of at the top of the first page, as is the general rule. Remember, a report header appears just once, at the beginning of the report, so Access won't print your title page information on any other pages.
When
importing Excel data into an Access table, you may frequently find that data is
missing. You know the worksheet cells contain data, but the data simply doesn't
survive the import process. More than likely, you're trying to import formulas
instead of static data. You see, if what you're seeing in Excel is really the
result of a formula, Access will import those worksheet cells as blank data
cells.
This
problem has a simple solution. First, save the Excel worksheet that contains the
data you're importing in a new workbook. Next, select the range you want to
import and press Ctrl-C. Then, choose Edit, Paste Special; select the Values
option; and click OK. Now, import this sheet into your Access table, instead of
the original sheet that contains formulas. Visit these additional sites which offer support for Access users: |
|||||||||
.
