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

Servant leadership vs followership venn diagram - If you're irish come into the parlour lyrics chords - Blink mink lashes bloomington mn - Essay - Explain how the discussion of moneyball - Discussion - The lady of shalott worksheet - Maiden lane community centre - Crytographic Attacks - Leadership communication case study - How to solve integer word problems - Cua esaver reward account - Simpson cast in place anchors - Fire drill powerpoint templates - Mission impossible measuring social media return on investment case study - Initiation phase in negotiation - Living philosophy by lewis vaughn pdf - The term discrimination is defined in the text as - Stoichiometry of a precipitation reaction lab - Magill senior citizens hall - Gambling has evolved into a multi-faceted industry - Marshall rosenberg making life wonderful - Natural order hypothesis krashen ppt - Fire rated cables australia - Psychosocial theories of aging - Reclaiming social work aberdeen - Persuasive speech on health care - Bus 377 last assignment - Demeter and persephone myth summary - Creditors claims on the assets of a company are called - You can grow your intelligence author - Ethics character and authentic transformational leadership behavior pdf - Online voting system along with biometrics - Market competitive pay system - Personal experience speech outline - How to write a positionality paper - Certificate iv in professional writing and editing rmit - Cisco mpls l2vpn configuration example - John rowles wind beneath my wings - Jamun fruit wine recipe - Business process blueprint template - How to calculate sa to volume ratio - Pest analysis of computer shop business - Personal experience speech - Friedrich nietzsche the madman - Unit weight of clay pcf - The book of nahum relates the destruction of edom - 2pave paler due by Sunday on early Muslim Society including the roles of women based on the surah readings . - COMPUTER SECURITY_Week8 - Where is nimpha ong now - Reply to this discussion - Fetch decode execute cycle diagram - Hampshire hospital blood test - In a speaking outline subpoints are - Duke's aldridge academy show my homework - What is a research background - Mpsj parking saturday need to pay - 100 pair telephone cable color code - Altistart 22 usf fault - Which of the following transactions occurred in the marketspace - Four types of cyber crimes - Questions1 - 2212 ridge lane grapevine tx - Sn1 reaction order of reactivity - The minstrels care home boston - D2lpdx - Gummy worm mitosis worksheet answer key - Organisational structure of ikea - Apple retail iphone upgrade program - Blackboard mobile learn ios - Starbucks financial ratio analysis 2011 - How do impurities affect boiling point - Interprofessional Organizational and Systems Leadership - Data - Logbook sample for student - Sample of article critique using apa format - Week. 3 death - 362 wellington road mulgrave - Saint lucian creole french - Https www thebalance com obamacare pros and cons 3306059 - Hypotenuse of non right triangle - 7-1 Activity: Multimedia Presentation Planning Worksheet - Criminal typology for shoplifting - Alwaysrain irrigation inc would like to determine - Factor tree of 72 - Chemical reaction lesson plan - Csestudy - D1 d2 d3 d4 situational leadership - Corporate IT Security Audit Compliance - Bone processes and depressions - Macquarie university withdraw without academic penalty - Opposable thumb lab answer key - 495 Discussion and journal week 3 - 1002 beddards crossing drive grimesland nc - What is ethical issue intensity - JOURNAL REPORT - Rb 61 ii bookshelf speakers - Marketing Strategies - What are you grateful for - +91-8306951337 love marriage specialist astrologer IN Dhanbad