Date: June 16th, 2008
Author: Mary Ann Richardson
You can make it easier for users to update records by adding an Undo button to a form. The Undo button will allow them to cancel changes made to a record without is generic propecia just as good having to go back and retype or delete entries made to a field. Follow these steps to add an Undo button to a form:
- Open the form in Design view.
- Right-click any toolbar and click Toolbox. Click to activate the Control Wizards button, if necessary, and then click the Command button tool. (In Word 2007, in the Form Design Tools tab, click to activate the Use Control Wizards button in the Controls group, if necessary, and click the Command button.
- Click and drag in the form where you want to locate the command button.
- Under Categories, click Record Operations.
- Under Actions, click Undo Record.
-
Click Next.
-
Click Next.
-
Enter cmdUndoRecord.
-
Click Finish.
Date: June 16th, 2008
Author: Mary Ann Richardson
You can use Excel’s Lookup functions to build a worksheet that can be used to search a database table. For example, say you’ve imported the following table from your Access database to Sheet2 of your Excel workbook:
To build a worksheet that can be used to look up an intern’s pay rate by entering the intern’s ID, follow these steps:
- Open the workbook, click the Sheet2 tab, and select the range A2:H5.
- Click in the Name box, type Interndata, and then press [Enter].
- Click on the Sheet1 tab.
- Click cell D6 and enter Employee ID.
- Click cell D8 and enter Name.
- Click cell E8 and enter the following function:
=VLOOKUP(E6,Interndata,3,FALSE)&" "&VLOOKUP(E6,Interndata,2,FALSE)
-
Click in D10 and enter Pay Rate.
-
Click in E10 and enter the following function:
=VLOOKUP(E6,Interndata,8,FALSE)
-
Change the cell format of E6, E8, and E10 to match the data type of the data in the table.
-
Add a header and formatting as shown here.
how much does propecia cost width=”100%” size=”2″ />
Date: June 16th, 2008
Author: Mary Ann Richardson
At the end of the month, you send out a statement for each customer’s account. You would like to send one statement to customers with outstanding balances and a second one to those with a $0 balance. You do not have to create two different mail merge documents. You can use the same mail merge document for both types of customers. Follow these steps:
- Open how effective is propecia a blank document.
- In Word 2002/2003, right-click any toolbar and select Mail Merge. In Word 2007, click the Mailings tab.
- In Word 2002/2003, click the Select Data Source button. In Word 2007, click Select Recipients and then click Use Existing List.
- Navigate to the Customer database and click Open.
- Select the Customer table and then click OK.
- Click in the document. The figure below shows inserted fields after toggling field codes.
- Click the Insert Merge Field button.
- Select Customer_Number.
- Press Enter.
- Click the Insert Merge Field button and select Name.
- Press Enter.
- Click the Insert Merge Field button and select City. Press Enter.
- Click the Insert Merge Field button and select State. Press Enter.
- Click the Insert Merge Field button and select Zip Code. Press Enter twice.
- Type “The balance for the
- Click the Insert Merge field button and select Customer_Number.
- Type “account is “.
- Click the Insert Merge Field button and select Balance.
- In Word 2002/2003, click the Insert Word Fields button in the Mail Merge toolbar. In Word 2007, click Rules, then click If …Then…Else.
- Enter the fields as shown below and click OK.
- Save the Mail Merge Main document as Monthly_statements. (To check your work, select the text in the document, right-click, and select Toggle Field Codes, as we did in the first figure.)
To produce the statements:
- Open the Monthly_statements document.
- In Word 2002/2003, click the Merge To New Document button on the Mail Merge toolbar. In Word 2007, click Finish And Merge and then select Edit Individual Documents. Click OK.
