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

Reiki licensing commission - Romeo and juliet references in songs - Mhhe equipment cost - Steps in becoming a saint - Usaver reach interest rate - Create a scenario summary report excel 2013 - Gmo persuasive speech outline - Week 3 assignments - 2 paragraphs 10/24/2020 - Story of the hour pdf - Nurs 561week 2 paper and 2 discussion borad - Queensland industrial award for teacher aides - Dis 4 - Introduction to java programming 11th edition free - Distribution management system applications - Exponential growth calculator with steps - How to read paired t test results spss - Presented below are certain account balances of paczki products co. - The global pharmaceutical industry case study answers - Answer these questions - Fluid mechanics lab report example - Biology of osmosis jones worksheet answer key - Math Assignment - Where the mountain meets the moon vocabulary - How to write a chemistry lab report introduction - How Can a Good Assignment Be Written? - How to write a biographical narrative - Bd accuri c6 software download - Discussion - Sapo in my soul pdf - What is a trend analysis in healthcare organizations - Blaine company had these transactions pertaining to stock investments - Translate from Spanish to English - Community Advocacy - Www householdresponse com telfordwrekin - Tiempo - Abina and the important men characters - Mice of men american dream - In order for something to be considered deviant - Ikea vidga ceiling fitting - Business is a poker game and we are all bluffing - Accounting - Nick bottom character description - Qianlong on chinese trade with england - The whole class completing - H lloyd cycles decals - Public law outline flowchart - Patience taught by nature elizabeth barrett browning - Following are selected transactions of danica company for - MKT 630 DQ2 - Normative leadership theories chapter 7 - Module 2 Discussion BHA415 - Case Study (for Dr. Noorfatima) - Hook for cell phone essay - Sylvestrian centre holiday club - Whose bones were buried in the promised land at shechem - To siri with love judith newman summary - Why are information systems typically used at the operational level - Ensure team effectiveness answers - Data Visualization Project - Soylent Looks to Shed Techie Image With 7-Eleven Store Expansion By Craig Giammona - 0.192 as a fraction - Orthogonal trajectories x 2 y 2 cx - 63 divided by 7 - Ian inglis the beatles - Wolf hollow study guide - Unsymmetrical fault analysis in power system - Magazine ad experimental design - Renaissance art literature and science - The financial detective case study - Adobe bridge cs3 update - How might emission spectra be used in studying stars - 3643-3 - Lenten song michael john poirier lyrics - What is an implied shape - Junebug by alice mead comprehension questions - Molar mass of nitrogen gas - Case study - The carnivore connection to nutrition in cats - Determinant attributes marketing definition - Economy Quiz - Analysis of a pertinent healthcare issue - Discrete time fourier transform examples - A lens produces a real image of a real object. - Market research - My Best Customer Experience and Why - Math 123 quantitative reasoning answers - Head injury assessment form - WK 8 SOCW 6443 Assignment: Addressing Ethical Implications in the Treatment of ADHD - Henry hub erath louisiana - Bike data project - Discharged for off duty behavior case study - How did eva smith die - Fear in the dressmaker - Maria ivanova umass boston - A class divided video questions answers - Kfc swot analysis ppt - Lottery commission washington state - 29 october 1986 award transport payment - Microbiology