Tech

Convert your Access 2007 app from design to runtime mode

Microsoft Access

When you’re ready to move your Access application from development to production, you need to ensure that it runs in Access runtime mode when opened.

Access runtime mode prevents users from modifying or deleting objects from the application; users have access only to the objects you make available to them in the Startup form.

After specifying your Startup, you simply need to change the Access 2007 database filename extension to put it in runtime mode.

For example, to put the Employee.accdb database in runtime mode, follow these steps:

1. Open the Employee.accdb database.
2. Click the Office button.
3. Click the Access Options button.
4. Click Current Database on the left side of the window.
5. Under Application Options, click the drop-down arrow of the Display Form text box.
6. Select the name of the form you want to be your Startup form for your application, then click OK.
7. Click the Office button.
8. Click Close Database.
9. Use Windows Explorer to navigate to the Employee.accdb icon.
10. Right-click the icon and select Rename.
11. Type Employee.accdr and then press Enter.

This creates a locked-down version of your Access 2007 database.

To open it in runtime mode, you can double-click its icon in Windows Explorer, open it using a shortcut on the desktop, or use the /runtime command-line switch.

To open the file again in Access in design mode, you need to rename it with an .accdb filename extension.

Microsoft Word

You've just created a table at the end of the first page of your Word document, but would like the table to appear in the middle of your page instead.

Your first instinct might be to click and drag the table into position, but no matter how many times you move the mouse to adjust the table's position it never seems quite right--either the table is not exactly where you want it, or the text runs up against the table borders.

If you try reformatting the text on the page, the table moves out of its central position.

Rather than use the mouse, just tell Word to position it for you. Follow these steps:

1. Select the table.
2. Right-click the table and select Table Properties.
3. In the Table tab, under Text Wrapping, click Around.
4. Click the Positioning button.
5. Under Horizontal, click the drop-down arrow in the Position box and select Center.
6. Click the drop-down arrow in the Relative To box and select Page.
7. Under Vertical, click the drop-down arrow in the Position box and select Center.
8. Click the drop-down arrow in the Relative To box and select Page.
9. Under Distance From Surrounding Text, click the up arrow once in the Top text box.
10. Click the up arrow once in the Bottom text box.
11. If necessary, clear the Move With Text check box, then click OK twice.

Word positions the table exactly in the middle of the page; the table will remain in place even if you later make formatting changes.

Microsoft Excel

It is the end of the month and you need to write a quick memo to report on last month's sales.

You have a spreadsheet listing 100 invoices for the month, including the Invoice Number in Column A, the Customer Name in Column B, and the Product Name in Column C.

Because most of your customers place orders several times a month, you need a quick way to generate a listing of each customer that ordered from you last month.

Before Excel 2007, you would obtain this data using either Excel's Advanced Filter or Pivot Table feature. With Excel 2007's new Remove Duplicates feature, you have an additional, even quicker, way to produce this list. Follow these steps:

1. Select the Customer Name column.
2. Copy the data to a blank section of the worksheet. (You should leave at least one blank column between the original data and the copied data.)
3. Click inside any cell within the copied cells.
4. Click the Data tab.
5. In the Data Tools group, choose Remove Duplicates, then click OK.

Excel removes all duplicate customer names from the copied list. You can also use Remove Duplicates to produce a list of unique values for more than one field. For example, to generate a list of customers and the products they ordered, follow these steps:

1. Select the Customer Name and Product Name columns.
2. Copy the selected data to a blank area of the worksheet.
3. Click inside any cell within the copied cells.
4. Click the Data tab.
5. In the Data Tools group, choose Remove Duplicates, then click OK.

Excel generates a list of each customer and the products ordered, excluding duplicate orders for the same product from the same customer. You can then use the Sort function to make the list easier to read by following these steps:

1. Click any one of the cells in the Remove Duplicates results list.
2. Click the Data tab.
3. Click the Sort button.
4. Click the My Data Has Headers check box.
5. Click the Sort By drop-down arrow and select Customer Name, then click OK.

Latest from Blog Central

Today's corporate landscape ain't Sesame Street

Read more »

What's important from our sponsors

SOA Whitepapers

Sponsored by

Cutting-edge technology from premium sponsors

HP Simply StorageWorks D2D Backup System

Explore this disk-to-disk backup system that is fully automated and provides reliable data protection for your business.