Infero Training – Business and Technical Courses

You probably get very upset when your Microsoft Office application crashes down (closes down unexpectedly) while you are working on something important. It is not necessarily that the problem is within the Microsoft Office code. Computer viruses (read How to Protect Yourself from Viruses from Your Computer Health Part Two), disk failures, or laziness with respect to installing updates (read How to Stay up to Date Automatically from Your Computer Health Part One) are just a few issues causing this condition.

Microsoft Office Diagnostic is a tool included in Microsoft Office 2007 pack, allowing you to run a series of diagnostic tests that can help you discover why your computer is crashing. These tests will either solve problems directly or may help you with the ways to solve them.

These are the diagnostics that are run:

Setup Diagnostic – Files and registry are checked for errors occurring due to viruses or by hardware that is faulty or incorrectly configured. While running for about 15 minutes, the test may require the original installation source.

Disk Diagnostic – Hard disk is examined for errors logged by the Windows system and SMART (Self-Monitoring, Analysis and Reporting Technology) feature of your hard disk (if provided by disk drive manufacturers) to notice potential hard disk failure.

Memory Diagnostic – Random Access Memory (RAM) is verified for integrity.

Update Diagnostic – Your computer is tested as to whether it has the latest updates installed to make Microsoft Office more stable. You can install updates from Microsoft Office Online.

Compatibility Diagnostic – Different versions of Microsoft Office are checked for conflicts, as two different versions of Office installed on your computer can cause instability.

Check for Known Solutions – The crash report is tested and checked against the database of Microsoft’s crash cases for available solutions.

To find out how to run diagnostics, read How to Fix Errors Using Microsoft Office Diagnostics.

There are many ways you can enter the current date into an Access’s record.

First of all select or click in the Date/Time field. Then do one of the following:

1. Type the date or time

 

Or

 

2. Click the date picker, located to the right or left of the field. From the appearing calendar control click Today

  

Or

 

3. Select a day in the current month.

 

Or

 

4. Press simultaneously <CTRL> and <:> keys on a keyboard

Access will add the current date to the record.

You finally installed Office 2007 and guess what? You cannot find commands you are used to in the Menu!

It will certainly take a while to adjust to a new Menu. So what you can do to locate where your favourite Office 2003 commands are in the new Office 2007 interface?

Microsoft developed visual, interactive reference guides to help you quickly learn where things are. You can download and install them on your computer.

The only downside to it is that you have to download these guides for each of the Office 2007 Applications.

If you are not sure if it will help it, try an online demonstration from one of those listed at Microsoft Office Online.

If you are happy to proceed, use the following links to download command reference guides for each of the Office applications:

Word 2003 to Word 2007 interactive command reference guide

Excel 2003 to Excel 2007 interactive command reference guide

PowerPoint 2003 to PowerPoint 2007 interactive command reference guide

Outlook 2003 to Outlook 2007 Interactive Command Reference Guide

Access 2003 to Access 2007 interactive command reference guide

To ensure optimal performance of your Access database, you can run the Compact and Repair utility within Access. This utility rearranges how the database is stored on a disk if the database is fragmented.

To set an option that automates this process every time the database is closed:

1. Open the Access database that you want Access to compact automatically.
2. Click the Office Button , and then click Access Options.
3. Click Current Database and, from Application Options, select the Compact on Close check box.

PDF is a fixed-layout electronic file format that preserves document formatting. It ensures that when the file is viewed online or printed, it retains exactly the format that was initially intended, and that data in the file cannot easily be changed.

Before the release of Office 2007 we had to either buy Adobe Acrobat for about £450 in order to convert Office files into PDF format, or install a third party software solution.

With the release of Microsoft Office 2007, Microsoft introduced a file format called XPS. It is similar to PDF in that you can save a file to this format and share or print it at a later date. This XPS format is not the global standard, and not many people know what it is when they receive it.

The following Office applications can be used to convert files to PDF format:

• Access
• Excel
• InfoPath
• OneNote
• PowerPoint
• Publisher
• Visio
• Word

In order to convert files, you need to install 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS. 

Let’s use Microsoft Word application to convert a Word file into PDF format.

1. Open a Microsoft Word document you want to save in PDF format
2. Click the Microsoft Office Button , and then navigate to Save As, and click PDF Or XPS.

 

 

3.  In Save as Type, make sure that PDF is selected.

 

 

If you want to open the file immediately after saving it, select the Open file after publishing check box. This check box is available only if you have a PDF reader installed on your computer.

 

4. Click Publish to create your PDF.

Credit control is very important for every business. How Microsoft Access can help you to find all overdue accounts?

Let’s say you have a table in Microsoft Access with your Customer names and Invoice date:

Your invoices should be paid within 30 days of issue. In order to find overdue accounts you can create a filter that compares today’s date with the Invoice Date in the table.

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter <Date()-30

After running the query you will receive records for customers, where the Invoice Date is 30 days before today’s date.