Monthly Promotions

Monthly Promotions

GO19_AC_CH09_GRADER_9G_HW – Monthly Promotions 1.1

 

Project Description:
In this project, you will import tables to a blank database from Excel and text files. You will create a report and export it as an HTML format. Additionally, you will make a screenshot of the HTML document and paste it into a new Access form.

 

Start Access and open the file Student_Access_9G_Monthly_Promotions.accdb downloaded with this project.

 

Create a table in the database by importing the downloaded Excel workbook named a09G_Customers.xlsx. Indicate that the first row contains column headings. Change the data type for the Postal Code field to Short Text and let Access add the primary key.

 

Continuing with the wizard, name the imported table as 9G Customers. Do not save the import steps.

 

Open the 9G Customers table, apply Best Fit to all columns. Save and Close the table. Merge it with the existing Microsoft Word document a09G_Promotions_Letter.docx. The recipients will be selected from the existing list in the 9G Customers table. Verify that Show/Hide is active. Place your insertion point at the beginning of the fifth blank line after the current date. Add the Address Block, and click OK. Insert the First Name and Last Name fields between the space and the colon in the salutation line. Place a space between these fields.

 

Preview your letters and Complete the merge for only the eighth record. With the Word document displayed, use the Snipping Tool to create a screenshot of the screen, and then Save the file as a JPEG using the file name MergeLetter. Close the document, and Close Word.

 

In the database, on the Create tab, click Form Design to create a new form in Design view. Under Form Design Tools, on the Design tab, in the Controls group, click Insert Image, and then click Browse. Navigate to the location where you saved the MergeLetter screenshot, and double-click it to insert the image file in the Detail section of the form. Save the Form as 9G Merge. Close the Form.

 

Create a table in the database by importing the downloaded tab-delimited text file named a09G_Monthly_Promotions.txt. Use the first row of the file as field names, and let Access add the primary key.

 

Continuing with the wizard, name the imported table as 9G Monthly Promotions. Accept all other default options.

 

Create a simple report based on the 9G Monthly Promotions table that will open in Layout view.

 

Add the downloaded a09G_logo.jpg file as a logo to the report header. In the Title of the report, add Liberty Motors in front of the title, and then move 9G Monthly Promotions to a second line.

 

View the report in Design view. Set the Size Mode property of the logo control to Zoom. Set the width of the control to 1.5 inches and set the height to 0.5 inches. Delete the Date and Time controls. Resize the report to 6.5 inches wide. Save the report with the default name.

 

Export the report as an HTML Document. Open the destination file after the export is complete, accepting all other default options. Use the Snipping Tool to create a screenshot of your screen, and save the file as a JPEG using the file name HTMLReport.

Create a blank form in Design view and then, in the Detail section, insert the image file, HTMLReport, into it. Save the form as 9G Promotions HTML.

 

Save and close the database, and then submit for grading.

How do you place an order?

It takes a few steps to place an order with Us:

  • The first step is to place your order. You will need to provide us with some basic information about your project.
  • Once you have placed your order, you will be taken to our secure payment page.
  • Once we receive your order, we will carefully review it and match you with a writer who has the skills and experience.
  • Stay in contact with the writer and discuss vital details of research.
  • Your completed proposal will be delivered via email within the specified deadline.

You are secure when using our service

It's critical for each client to feel secure. As a result, we at Research Proposal Writing take precautions to secure your data.

Financial security You may securely pay for your purchase using a variety of secure payment methods.
Personal security The personal information of our clients is secure. Nobody else will have access to it.
Academic security We use a specialized program to check every completed paper to ensure that we deliver no-plagiarism samples.
Web security This website is safe from unauthorized breaches. We maintain our privacy management in line with the latest laws and regulations.

You can get help placing your order. If you have any questions about our services, please contact us. Our support staff is accessible 24 hours a day, 7 days a week.

If you're still looking for a way to improve your grades and hire expert writers, we've got you covered. Place an order on our website, and we'll help you with any paperwork you want. We will exceed your expectations.

Order now Get a quote