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

Lab 1 garden naturally database

03/04/2021 Client: muhammad11 Deadline: 2 Day

I’m working on a Computer Science exercise and need support.

Write my name as SC. Full name Chuyao Shi

Open the Lab 1 Garden Naturally database and open the Customer table in Design view. 2. *See the instructions on pg 136 for using the Lookup Wizard. Save the table, then use the Special Method to print the Design view of the Table. Add a multivalued lookup field, Product Types Needed, to the Customer table. The field should appear after the Postal Code field. Table 3-2 lists the Product Type abbreviations that management would like in the multivalued field as well as a description. Save the change to the table. 3. *Add a calculated field named Total Amount (Amount Paid + Balance Due) to the Customer table. The field should follow the Balance Due field. Save the change to the table. Print the Customer table normally (i.e.; use the print command) so we can see the changes. 4. ****Create the following rules for the Customer table and save the changes: a. Ensure that any letters entered in the Customer Number field appear as uppercase. Print the current Design view b. Make Customer Name a required field. Print the current Design view. c. Ensure that only the values DE, NJ, and PA can be entered in the State field. Include validation text. Print the current Design view d. Assign a default value of NJ to the State field. Print the current Design view 5. **Use the basic filter button on the home tab ribbon to find all records where the city is Gaston and the balance due is $0.00. Do not save the filter. You should only see one record. a. If only 1 record shows, use special print to show the record to be deleted then delete it. If this worked, go to step 5c. b. If more than 1 record shows, go back and fix your filters, re-apply the filter operation again and retry step 5a. c. When you have only deleted the 1 record, SAVE the changes to the table. Now to undo the filter and see all the records from the table again, click the highlighted “toggle filter” button. Print the table, showing that the record has been deleted. Access Module 3 Maintaining a Database 6. Open the Customer table in Datasheet view and add the data shown in Figure 3-83 to the Product Types Needed field. Resize the field to best fit and save the changes to the layout of the table. For the Customer Number with XX and your initials, set the Product Types Needed to Frtl, Grdn, Watr. T 7. Open the Sales Rep table in Design view and change the field size for the Address field to 25. Save the changes and close the table. 8. Open the Sales Rep table in Datasheet view, find the record for sales rep 32 and change the address to 982 Victoria Station Rd. Resize the column to “best fit”. 9. Skip this step, as you already changed “Pat Jones” to yourself. If requested to do so by your instructor, change the last name for sales rep 35 to your last name. If your last name is longer than 15 characters, simply enter as much as you can. (This step saved as a place-holder to match with the steps in the book) 10. Save the changes to the layout of the table and close the Sales Rep table. 11. *Establish referential integrity between the Sales Rep table (the will be the table with the “1” at the end of the connector-line) and the Customer table (this will be the many table, with the infinity symbol “∞”at the other end). See the book for how to do this. Cascade the update but not the delete. If you do not have the 1 and ∞ on the line, you have a problem with your DB. When it is correct, create and print the relationship report, so we can see this result. 12. **Open and print your 2 tables in Datasheet (List) view. 13. The State field currently has three possible values. How would you add MD to the State field list?

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:

High Quality Assignments
Top Academic Tutor
Financial Solutions Provider
Instant Assignments
Professor Smith
Innovative Writer
Writer Writer Name Offer Chat
High Quality Assignments

ONLINE

High Quality Assignments

I have read your project details. I can do this within your deadline.

$47 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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

$32 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$38 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

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

$18 Chat With Writer
Professor Smith

ONLINE

Professor Smith

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

$41 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

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

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

Define velocity potential function and stream function - Barmah national park map - Kp's speech class monroe's motivated sequence - Get homework answers free online - Example of case note - Abb sace tmax motor operator wiring diagram - Namma kalvi 12th study material - Https www mindtools com pages article common communication mistakes htm - Gloucester royal hospital map - Did fev catch the ball - Please see the attached - Stealing carol ann duffy poem - Fawkham manor hospital history - Acids bases and salts worksheet answer key - Assignment: Evidence-Based Project, Part 3: Advanced Levels of Clinical Inquiry and Systematic Reviews - Marketing management orientation concept - Intentional learning essay - Ally from fish in a tree - How to create a cost benefit analysis in excel - Domestic containment - Social psychology definition paper psy 400 - Baa baa black sheep keyboard - Suncorp wealth cash management account - ¿cuáles son tres formas de decir headset? - Bca green mark residential building - Alexandra wing broadgreen hospital - Konica minolta pagescope enterprise suite - The self unseeing analysis - Sierra 18 7946 cross reference - Asian to white makeup transformation - Kaizen japanese bar & grill campbell ca - Nib levels of cover - Tax withholding declaration form - 200 WORD RESPONSE - Ram 2500 tow capacity chart - SLP 1 IT 590 - History of Art through the Middle Ages Week 4 discussion - Chcccs011 learner guide - Walmart unethical business practices case study - WE2 - Needed in 8 hours - Gap big data case study - Ward 7d royal north shore hospital - 900 x 600 paving slabs jewsons - Jcpenney everyday low pricing - Approved b double routes queensland - Is revenue an asset or equity - My cousin vinny law questions - What year was shakespeare born - State the following observations indicate an acid or a base - Coca cola human rights issues - Light spectrum lab - What were the main causes of the great depression - Informatica version control best practices - Acc 250 week 1 assignment - Insurance institute of ireland - Monash imaging consultant roster - 7.COURSE NAME - MARKETING MANAGEMENT - Southworth company uses a job order costing system - The story of an hour literary devices - Arc of justice kevin boyle sparknotes - Britten pears baroque orchestra - 1 2-dichlorobutane structural formula - Why is alessi successful - Derive linear density expressions for - NEED IN 6 HOURS or LESS - The devil the sinner and his journey harmony korine - Lord bernstein v skyviews and general ltd [1978] q.b. 479 - International dimensions of organizational behavior 5th edition pdf - Total cost total fixed cost total variable cost - Mcgraw hill connect anatomy and physiology answer key - Jeannette walls and john taylor - How do you become a chegg tutor - Little red riding hood play script ks1 - Chopin's étude in c minor - River system worksheet answers - Hrmt - Cisco wlc multicast ip address - Executive Practical Connection Activity - Please complete the outline assignment. Use the Point/Counterpoint Outline Instructions for directions. - Elements of therapeutic communication - Vortex spa control panel manual - Nestle ice cream in cuba case study - Agrium advanced technologies u s inc - Flight v booth case - Professional ethics in computer science ppt - I attach to your hip and babble all day - Radioactive cats sandy skoglund meaning - Week 4 Discussion Prompt 1 Pharmacology - General electric meters catalog - External and Internal Environments - Gy6 ac cdi wiring diagram - Mcgraw hill marketing game - Why do tightrope walkers carry a long narrow beam - Applying Current Literature to Clinical Practice - English 122 english composition i - Iodine clock reaction lab answers - Should cellphones be used in school - Johnson and johnson case study strategic management - Atar bonus points for illness