Reference no: EM132446501
Instructions
Create the Clients Database
1. Start Access and create a new Blank database named "Clients."
2. Name the new table "Clients," and then display it in Design view.
3. Edit the ID field to be Client ID. Verify that it's data type AutoNumber and that it has been selected as the primary key.
4. In Design view, add the remaining fields and corresponding data types:
|
Field Name
|
Data Type
|
|
Company Name
|
Short Text
|
|
First Name
|
Short Text
|
|
Last Name
|
Short Text
|
|
Job Title
|
Short Text
|
|
Address
|
Short Text
|
|
City
|
Short Text
|
|
State
|
Short Text
|
|
Zip
|
Short Text
|
5. Save and then close the Clients table.
6. Create a Clients form that looks similar to the figure below.
7. Use the Clients form to populate the Clients table with the records listed below.
8. Close the Clients database.
Create a Letterhead
1. Start Word and create a new Blank document.
2. Type "ABC Engineering Company" and then press Enter.
3. Type "1552 Carbondale Road" and then insert a bullet character.
4. Type "Any Town, FL 33334" and then press Enter.
5. Format the first line of the letterhead as Verdana 16-point bold and center the paragraph.
6. Format the second line of the letterhead as Verdana 12-point italic and center the paragraph.
7. Format the last, blank paragraph as Times New Roman 12-point with No Spacing paragraph style. Your letterhead should look similar to the figure.
8. Save the document, naming it "Letterhead."
Create the Estimates Letter
1. With the insertion point in the blank paragraph below the letterhead, type the text shown in the figure below, inserting merge fields where indicated.
2. On the File tab, click Save As and then save the document with the name "Estimates."
Embed an Excel Worksheet Object
1. With the insertion point in the second blank paragraph after ". . . costs for three scenarios:", insert an Excel worksheet object to embed a new spreadsheet.
2. Enter data as shown in the figure below. Center and bold column labels and format Site data to display commas with 0 decimal places.
3. Format cells C3 through F4 as Currency with 0 decimal places.
4. Enter formulas in column C to calculate Equipment costs as 15 times the site size.
5. Enter formulas in column D to calculate the Labor costs as 10 times the site size.
6. Enter formulas in column E to calculate the Overhead and Profit (O & P) as 0.25 times the sum of equipment and labor costs.
7. Use a function in a formula to calculate the total costs in column F for each scenario.
8. Size the worksheet object so just the cells with data are displayed, as shown in the figure(attached).
Merge Field Data
1. Use the appropriate command to merge the field data and create a document containing the individual letters.
2. Save the merged document, naming it "Merged Estimates." Your first letter should look similar to the figure below(attached).
Attachment:- Clients Database.rar