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

Access module 3 sam project 1

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

Illustrated Access 2016 | Module 3: SAM Project 1a

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

Trips Database

USING FORMS

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

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

1. Hint: If you do not see the .accdb file extension in the Save As file dialog box, do not type it. Access will add the file extension for you automatically.

To complete this Project, you will also need to download and save the following support file from the SAM website:

· Support_IL_AC16_3a_House.jpg

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
1. Use the Form Wizard to create a form based on the Customers table with the following options:

a. Include all fields from the Customers table in the form.

b. Select the Columnar layout for the form.

c. Set the title of the form to Customer Entry Form, then open it in Design View.

With the Customer Entry Form open in Design View, change the Default value property of the State text box to CO. Save the form, then switch to Form View.

Use the Customer Entry Form to navigate to the record with the CustNo field value 4. Change the Phone field value of this record to 555-111-7878.

Use the Customer Entry Form to add a new record to the Customers table with the field values shown in Figure 1 below. (Hint: The CustNo field is an AutoNumber field.)

Figure 1: Customer Entry Form

Switch to Layout View for the Customer Entry Form, then change the font color of the Customer Entry Form label in the Form Header section to Automatic (black) and bold. Save and close the Customer Entry Form.

2. Create a split form based on the Trips table, then save the form as Trips Split Form.

Switch to Form View for the Trips Split Form. Navigate to the record with the TripNo field value 7. Change the TripName field value for this record to Aspen Development Project. Close the Trips Split Form.

Use Figure 2 on the next page as a reference when modifying the Trip Schedule form in Steps 8–18.

Figure 2: Trip Schedule Form

Open the Trip Schedule form in Design View, then change the Trip Schedule label in the Form Header section to read Trip and Schedule Form.

3. With the Trip Schedule form still open in Design View, delete the Insert Observation House label in the Form Header section.

4. With the Trip Schedule form still open in Design View, do the following:

a. Insert the file Support_IL_AC16_3a_House.jpg, available for download from the SAM website, at the top of the Form Header section, at the 3" mark on the horizontal ruler.

b. Resize the image to position it at the top of the Form Header section, between the 3" and 5" marks on the horizontal ruler, and between the 0" and 1.5" marks on the vertical ruler.

In the Trip Schedule form, drag the right edge of the form to the left, so that the form is only 5" wide.

In the Trip Schedule form, drag the top edge of the Detail section up, so that the Form Header section is 1.5" tall.

In the Trip Schedule form, select all 10 labels in the Detail section of the Trip Schedule form, then right-align the text within the labels. (Hint: Do not right align the controls in the form.)

5. In the Trip Schedule form, do the following:

a. Delete the Price label

b. Move the Price text box to the right of the TripNo text box.

c. Position the Price text box so that the left edge is at the 3" mark on the horizontal ruler and the top edge is aligned with the top edge of the TripNo text box.

6. In the Trip Schedule form, resize the TripStartDate text box to be approximately the same width as the calculated date for the trip end date. (Hint: The trip end date is a calculated value in the text box just below the Duration text box.)

7. In the Trip Schedule form, change the Tab Stop property for the TripNo text box to No.

8. In the Trip Schedule form, change the tab order for the form so that the Price field is first.

In the Trip Schedule form, add a new text box to the Detail section of the form, to the right of the Duration text box. Modify the new text box and its associated label using the following options:

a. Change the new label text to Cost/Night.

b. Enter the expression =[Price]/[Duration] in the text box.

c. Change the Format property for the new text box to Currency.

d. Switch to Layout View, then move and resize the new label and text box as shown in Figure 2 on the previous page.

e. Save the Trip Schedule form.

9. Switch to Form View for the Trip Schedule form, then navigate to the last record in the form. (Hint: The TripNo field value for this record is 55.) Change the Duration field value for this record to 4.

10. Using the Trip Schedule form, navigate to the second record in the form. (Hint: The TripNo field value for this record is 9.) Change the Trip Name value for this record to Biking for Ecology.

11. In the Trip Schedule form, use the Find feature to find the trip record where the City field value equals Islamorada. Change the Duration field value for this record to 5. Close the Trip Schedule form.

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

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:

Pro Writer
Math Specialist
Academic Master
Phd Writer
Helping Engineer
Homework Guru
Writer Writer Name Offer Chat
Pro Writer

ONLINE

Pro Writer

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$47 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$45 Chat With Writer
Academic Master

ONLINE

Academic Master

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$28 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$41 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

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.

$38 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$18 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

Maximo rest api documentation - Dyson case studies - Zbigniew karas us financial ltd - Due today - Emirates insurance claim form - Phet vectors simulations lab answer key - Microsoft official academic course microsoft project 2013 pdf - Country club management style - Intermediate accounting chapter 23 statement of cash flows solutions - Sulfate gravimetric analysis post lab questions - Southwest airlines in 2014 case study - Resaerch paper questions from Journal - In which sea has connell set ship trap island - Avid trf filled out - To his coy mistress poem annotations - Values of a filipino family - Accounting theory - Compare and contrast the three types of responsibility centers - Electron configuration of boron - Unity pro schneider electric - (Block Chain) BLCN532 Lab2: Writing chaincode - Journalizing liability transactions - Writing human resource Essay - Domain model in ooad tutorialspoint - MGTDISC 2 REPLIES - Open studypool account - Organisational Theory - DISCUSSION - Post office directories queensland online - When balance sheet credits exceed the debits on the worksheet - Agilent 5973 msd parts - What challenges did mary face - How to draw a sankey diagram on graph paper - Who wrote i am the dreadful menace - Vark analysis paper - The Innovator's Method - How to use space gass - Assignment 3 cultural activity report - Developmental reading assessment 2 - Assignment on reducing burden of digitalization - 63.6 kg in lbs - Case study write up for columbia's fina - Three types of survivorship curves - Widney ctc - Positive rational numbers symbol - There are many ways to train a fly- 2009 Pitman - It business requirements document - Waves and vibrations lab answer key - Snowy river caravan complaints - Geology Week 1 - Cloud Computing - Transport pdus are typically called - C# windows form application exercises - Moray coast vet group forres - Pius ix syllabus of errors - It is common to progressively elaborate the network diagram - Christopher lowell office furniture - Discussion Board International Business - Carriage in lathe machine - Why chinese mothers are superior - A sunday on la grande jatte analysis - 1769 l19er bb1b user manual - Is discrete data categorical - System analysis and design tools and techniques - Possessive pronouns practice worksheet - Child case study assignment - Who can complete this assignment by 11:59pm tomorrow August 4th? - Cloud Computing - How to interrupt a conversation politely - C11E Assignment 8 - 12 imams family tree - Critical review or analytical review realy - Tillage king machinery centre bunbury - Bright star would i were stedfast as thou art - The cost of an asset less accumulated depreciation equals - Contour representation of landforms - Ae engine parts catalogue - Long service nsw gov au bci workers record update form - Contract management maturity model cmmm - Assume that adults have iq scores - PUB 6 - American history 6th ed.vol.2 Eric foner - Maths - What primary goal does kroger company's quevision system help accomplish? - Give me liberty brief 5th edition pdf free - The classic experiments on insightful problem solving were done with chimpanzees by _________. - White card tafe sa - Ib economics ia cover sheet - Marketing - Portrait of madame matisse. the green line - Paradox in macbeth act 2 - Chapters 1 3 sam capstone project 1a - How are authentication and authorization alike - Ohm's law lab report sample - Explain why disorders caused by dominant alleles on - Excel wssi example - Person vs society definition - Working principle of solar water heating system - Evaluate own working relationship with colleagues - Yves rocher los angeles - The virtue of courage should enable one to face danger