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 5 sam project 1

07/10/2021 Client: muhammad11 Deadline: 2 Day

Access Module 5 SAM Project 1

Can someone do this for me

attachment
Instructions_IL_AC16_5a.docx
attachment
IL_AC16_5a_LatriceReaves_1.accdb

Illustrated Access 2016 | Module 5: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.pngIllustrated Access 2016 | Module 5: SAM Project 1a

Dive Trips Database

MODIFYING A DATABASE STRUCTURE

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

· Save the file as IL_AC16_5a_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.

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

· Support_IL_AC16_5a_Scuba.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. Open the Relationships window and add the Countries table to it. Create a one-to-many relationship between the Countries table and the DiveTrips table using the CountryName field from the Countries table and the Country field from the DiveTrips table. Enforce referential integrity on this relationship, then save the Relationships window.

1. Create a Relationships Report, save it with the name Relationships, then close it. Close the Relationships window.

1. Open the DiveTrips table in Design View and delete the AverageTemp and Climate fields.

1. While viewing the DiveTrips table in Design View, complete the following tasks:

3. Move the StartDate field between the Location and City fields.

3. Use the Lookup Wizard to change the Rating field to a Lookup field. In the Lookup Wizard, type in the values that you want in the list in Col1: 1, 2, 3, 4, and 5. Use Rating as the label for the lookup field, and limit the entries to the list.

3. Add a new field to the end of the list, after the TripReport field, named Photo with the Attachment data type.

3. Save the DiveTrips table, switch to Datasheet View, and use the Rating Lookup field to change the value for ID 1 from 4 to 5.

1. In the new Attachment field at the end of the first record for ID 1, attach the picture Support_IL_AC16_5a_Scuba.jpg, available for download from the SAM website, to the field. Close the DiveTrips table.

1. Open the Divemasters table in Design View and enter Last Name as the caption for the LName field.

1. While viewing the Divemasters table in Design View, enter Unique ID number as the description for the DiveMasterID field. Save and close the Divemasters table.

1. Open the DiveTrips table in Design View, then complete the following tasks:

7. Set a custom format for the StartDate field of mm/dd/yyyy.

7. Change the Required property for the StartDate field to Yes.

7. Set the Format property of the State field to always display the entry in all uppercase characters. Save the DiveTrips table and click Yes if prompted to confirm that data integrity rules have been changed.

7. Change the Field Size property of the Participants field to Single, and change the Decimal Places property to 0.

7. Change the Default Value property of the Participants field to 10.

7. Add a Validation Rule property to the Participants field that allows values that are less than or equal to 20.

7. Add a Validation Text property to the Participants field that reads Values must be 20 or less. (Hint: Do not include the period.)

7. Save the DiveTrips table, click Yes when prompted to confirm that data integrity rules have been changed, and then close the DiveTrips table.

1. Open the Divemasters table in Design View, then add a field below the PhoneNumber field and update it as described below:

8. Set the field name to AlternatePhone.

8. Set the data type to Short Text and save the Divemasters table.

8. Use the Input Mask Wizard to apply a Phone Number Input Mask to the new AlternatePhone field that requires all 10 digits of the phone number, uses the * (asterisk) as the Placeholder character, and does not store the symbols in the mask.

8. Save the Divemasters table.

1. Switch to Datasheet View for the Divemasters table and complete the following tasks:

9. Move the PhoneNumber field between the Last Name and Address fields. Save the table.

9. Enter (555)111-2233 as the Phone Number value for DiveMasterID 1, Schwartz, and enter (555) 111-2244 as the AlternatePhone number for the same record as shown in Figure 1 on the next page.

Figure 1: Divemasters Table

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:

Engineering Mentor
Assignment Helper
Math Specialist
Essay & Assignment Help
Assignment Hub
Quick Mentor
Writer Writer Name Offer Chat
Engineering Mentor

ONLINE

Engineering Mentor

Give me a chance, i will do this with my best efforts

$20 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

Give me a chance, i will do this with my best efforts

$49 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I have read and understood all your initial requirements, and I am very professional in this task.

$34 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$24 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$48 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

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

Dsdm consortium website - Engineering assignment - Finance and Operations - Literature review of 5G amplification - Address and postcode finder nz post - Hw - Felkin anh model example - Assignment 2 - Ford motor company case study analysis - Nursing care plan readiness for enhanced knowledge - Exercise 2 5 prepare t accounts lo2 5 lo2 7 - Circuit lab report - Operation winback ps2 cheats - Sparknotes nickel and dimed chapter 1 - Burke litwin model of organisational change - Comprehensive medical report - Factor x 2 6x 25 - What does the river symbolize in fahrenheit 451 - Global Crime & Justice - What does a red wristband mean - Dba vs dbc osha - Oral presentation introduction example - Tmod register in 8051 - Mini paper on given topic - Final strategic plan and presentation powerpoint - Activity based costing and Master budgeting - What is rohs compliant mean - Explain how ethical decisions are made - Allied high tech consumables - Week 1 Discussion 1 Diversity through 21st Century Teaching and Learning - U8 - Www bbc co uk guides z3c6tfr - How to write a full sentence outline for a speech - 16 riverview place murarrie - Saint anthony abbot tempted by a heap of gold - Postofficemoney co uk register - Albert einstein critical thinkers - Analogy of the cave meaning - Dramatic Film Score - Meaning of tree agate - Professional accountability in clinical expertise - Discussions - Employee and production worker classes python - Change management courses brisbane - 882 beams road bridgeman downs - Dromana to arthurs seat walk - Ausnet solar pre approval - Blue spruce corp balance sheet - Efficient frontier analysis in srm - S&p 500 index gspc - Essay assignment - Questions on rhetoric and style letter from birmingham jail - Sociology - Brivis evaporative cooler water pump - Bed bath and beyond competitive advantage - The frog song japanese - Sundar pichai leadership style - Sfu math graduate students - Voting! - Resolutions of the stamp act congress - What is a switched wan - Api collapse pressure equations - Hesta unique super identifier - Penguin chick syllable patterns v cv vc v answers - Nursing - Global citizenship and equity assignment - 672 san pedro ave sunnyvale ca 94085 - Introduction To Economics - Topic 6 insolation and the seasons answers - What happens in it follows - Silverado beverly place mc community - What is a perceptual error - Example of behavior modification program paper - Exp 105 week 4 quiz - Personal interest project society and culture - Discussion - Unfolding clinical reasoning case study answers - Cann river free camping - What are some of the changes that ann cooper made - Ifsm 201 excel project 1 rental cars - Difference between deliberate strategy and emergent strategy - Special right triangles find the missing sides - Taxation - Research Paper Assignment - Commercial idps systems comparison spreadsheet - Module assignment 1 - History of California-6 - Mildura senior college staff - Process financial transactions and extract interim reports pdf - Equilibrium of a rigid body lab report discussion - Aqua control pool cleaner manual - Corrective action vs disciplinary action - Bcc city plan mapping - Advantages and disadvantages of wardriving - Common threats against contemporary information systems - South western corporations partnerships estates and trusts - Dictionary using hashing c++ program - I need 1 page on going live Is not the end of the ERP Journey” - Assignment 3 - Lse msc international relations