Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

West coast outdoor advertisers sam project

22/11/2021 Client: muhammad11 Deadline: 2 Day

Shelly Cashman Access 2016 | Module 4: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Shelly Cashman Access 2016 | Module 4: SAM Project 1a

West Coast Outdoor Advertisers

CREATING reports and forms

GETTING STARTED
Open the file SC_AC16_4a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as SC_AC16_4a_FirstLastName_2.accdb by changing the “1” to a “2”.

· If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS
Open the Basic Billboards List report in Layout View. Group the report by the State field, and then sort the report by the BillboardID field in ascending order. Do not add any additional grouping or sorting options to the report. Close the Group, Sort & Total pane. (Hint: Click the Group & Sort button.) Save and close the Basic Billboards List report.

Modify the Advertiser Financial Report to match Figure 1 on the following page by performing the following tasks:

a. Open the Advertiser Financial Report in Layout View.

b. Sum the values in the Amount Paid column and the Current Due column for each state’s advertisers and for all advertisers.

c. Switch to Print Preview to view the report and to check that the values in the subtotal control and the total control are displayed completely.

d. Return to Layout View and, if necessary, expand the size of the subtotal control and the total control so that they are displayed completely.

Save the report without closing it.

With the Advertiser Financial Report still open in Layout View, apply conditional formatting to the Current Due column. If the amount currently due is greater than $6,000, display the value in bold, Green font (7th column, 1st row of the Standard Colors palette).

Save the report again, and then close it.

Figure 1: Advertiser Financial Report

Open the Advertiser by AdRep Report in Layout View, and then create a summary report. (Hint: To create a summary report, hide the detail lines.) Save and close the report.

Open the AdRep Phone List report in Layout View. Apply the Office theme to this object only. Save and close the report.

Use the Label Wizard to create mailing labels for the AdRep table, and include the following options:

e. Use Avery C2163 as the label size.

f. Use Arial font, 11 pt. font size, Light font weight, and Black (1st column, 6th row of the Basic Colors palette) font color with no special font styles for the labels. (Hint: These formatting options may be the default settings for your label.)

g. On the first line of the label, include the FirstName field, a space, and the LastName field.

h. On the second line of the label, include the Address field.

i. On the third line of the label, include the City field, a comma (,), a space, the State field, a space, and the PostalCode field. Your label should match Figure 2 below.

Figure 2: Prototype AdRep Label

j. Sort the labels by the PostalCode field.

k. Save the Labels as Labels AdRep (which is the default name).

Confirm that your labels match Figure 3 below, and then close the Labels AdRep report. (Hint: If a message appears warning that some data may not be displayed, click OK.)

Figure 3: Labels AdRep Report

Use the Report Wizard to create the report shown in Figure 4 on the next page. The report is based on the Advertiser and Rentals tables and should include the following options:

l. Include the AdvertiserID and AdvertiserName fields from the Advertiser table.

m. Include the RentalID and BillboardID fields from the Rentals table.

n. The data will automatically be grouped by the AdvertiserID field, but do not add any additional grouping levels.

o. Sort the report by the RentalID field in ascending order.

p. Use the Stepped layout and Landscape orientation.

q. Save the report as Advertisers and Rentals Report. (Hint: Do not include the (.) period following Report.)

Preview the report, and then close it.

Figure 4: Advertisers and Rentals Report

Open the AdRep Contact Form in Layout View, and then modify the form by performing the following tasks:

r. Select all the labels and controls in the Detail section of the form. (Hint: Do not select the form title label in the Form Header section.)

s. Place the selected controls in the Stacked control layout.

t. Add the DateHired control after the PhoneNumber control as shown in Figure 5 on the next page.

u. Move the LastName control after the FirstName control as shown in Figure 5. (Hint: Be sure to select both the label and the control for the LastName field.)

Save and close the form.

Figure 5: AdRep Contact Form

Open the Rentals Update Form in Layout View, and then bold the BeginDate control. Save and close the form.

Open the States Entry Form in Layout View, and then add the current date to the form. Use the option button for the second date format. Do not include the time on the form. Save and close the form.

Open the Advertiser Address Form in Form View, and then use the Advanced Filter/Sort option to create a filter with the following properties:

v. The records in the form should be sorted in ascending order by the AdvertiserName field.

w. The form should only return records where the State field contains “OR”.

x. Toggle the filter to confirm it is working. (Hint: There should only be nine records included in the form.)

Save and close the form.

Use the Form Wizard to create a form based on the Billboard table with the following options:

y. Include the BillboardID, Location, City, State, Type, and DEC fields (in that order) on the form.

z. Select the Columnar layout for the form

aa. Save the form as Basic Billboard Form. (Hint: Do not include the (.) period following Form.)

Close the form.

Save and close any open database objects. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

2

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Maths Master
Engineering Solutions
Quality Homework Helper
Essay Writing Help
Financial Analyst
Quick Finance Master
Writer Writer Name Offer Chat
Maths Master

ONLINE

Maths Master

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$50 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$47 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$24 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$34 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$33 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$29 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Misty and yesenia have a group of base ten blocks - 1610 abyss drive odessa fl - They say i say chapter 2 exercise 1 answers - Worksafe early intervention physiotherapy fee schedule - HR - In a 4 page project proposal written to the leadership of your healthcare organization, propose a nursing informatics project for your organization that you advocate to improve patient outcomes or patient-care efficiency. This must be - Wbai live stream apple device - Balloon circumference vs temperature experiment - Exploring the Influence of the APA Within the Psychology Profession - Cisco 2960 x poe configuration - Hilux brake controller wiring - How to find the angles of a rhombus - Netflix global expansion strategy - Call of cthulhu 7th edition occupations - When inductors are connected in parallel - Jane a successful store manager leads her employees - Bourke high school staff - Assonance worksheets with answers - Play script writing format - Iec 61850 logical nodes list - Baby's brain wider than the sky - What is pluto's speed at the most distant point in its orbit, where it is 7.30×109km from the sun? - Case study - Primary source of the black death - 150 words - Unit one study guide - Uwa approved calculator list - The art of the commonplace - Sales of people magazine are compared over a 5-week period at four borders outlets in chicago. - Roband bain marie spare parts - Greenbelts can provide vital ecosystem services, such as ________ . - Risk based thinking ppt - Key agencies regulating and enforcing rsa in nsw - Pinicol - As1170 3 free download - Cec testing and commissioning sheet - Sqa marking instructions maths - 3 - Absolute neutrophil count calculator - Siemens hmi data logging - Ryerson excel download - Carrefour sa case study solution - Depth research on a web browser - Pictures of camp green lake - Class 1 cost estimate - Assignment 1 - Select characteristics exhibited by exotoxins but not exhibited by endotoxins - Conclusion of a final paper 2 pages. - Transactions affecting owner's equity include - Lingual arch space maintainer indications - 12 angry men group dynamics - Hatsune miku high notes - Importance of ethics and values in social work - Stealth ebay account guide - Difference between traditional goal setting and mbo - Brief history of toyota motor corporation - How many inches is 3 yards - Molykote 3402c data sheet - PS490 Assignment 8 Research Proposal - The patriot reverend oliver - Selling Quillbot premium account - What is the role and purpose of a historian - Crazy eddie case study solution - Rles rit - Tesch 8 steps of data analysis - Poem past present future emily bronte - The case for the contingent exclusionary rule - Shmuel boy in striped pyjamas - What passage of scripture gives insight into the routine activity of the early church? - CHRISTIAN SERVANT LEADERS - Orientation to the counseling profession 3rd edition - Ramsay horton treatment centre - Discussion 250 words apa format need proof in turnitin apa format - Iron nitrate and potassium thiocyanate - St helens hospital phlebotomy department - Development Economics - Quiznos hiring age - Multi channel audio recorder - Learning experience plan for early childhood examples - Trevor noah tickets tulsa river spirit casino resort march 13 - The right thing to do rachels ebook - The loved one by evelyn waugh summary - Ideal pasta price philippines - Naming carboxylic acids practice problems - The ethical no free lunch rule states that - The investment detective - Lennox g24m3 4 100a 2 parts - 3kg in pounds and ounces - Shintoism method of reaching paradise - Property valuation report pdf - Gyg $3 taco calories - How many onto functions are possible - ORGANIZATIONAL CRISIS - What is chocolate rain about - Siop model lesson plan format - Create a diagram that shows the challenges of perseus - Jig and fixture ppt - Map of europe 1799 - Qnt 351 week 2 individual assignment - The two methods of accounting for uncollectible receivables are