There The GCF Learn free Access 2019 Tutorials that I want you to complete are listed below. is not Challenge at the end of tutorial 1 or 2. It is stated, "This tutorial will not teach you how to build a database from scratch. It is designed for people who plan to use a pre-existing database, most likely in the workplace." I still want you to do as much of the hands-on exercise as possible. Use the open labs on campus if you do not have Access 2019 available to you. Download the Access 2019 sample database at the beginning of tutorial 3, Getting Started with Access. Complete the Challenge at the end of the tutorials noted below. You will only need to paste a screen shot of one specified step from the Challenge for each tutorial listed into a Word document to earn the points for this assignment. Completing this Access Tutorials Assignment is worth 25 points.
Create a Word document with your name at the top. You could just do a "Save As," to this document and format the top to delete the directions and type your name. Use the open labs on campus if you do not have MS Office 2019 available to you. Type your name at the top and give the file an appropriate filename. Then log into the GCFLearnFree.org site. Complete each of the tutorials listed below. Take screen shot of your work in Access at each specified step from the end of tutorial Challenge assignment. Paste the screen shot into your solution Word document. Be sure to properly label each screen shot in the solution document to receive full credit. Below the screen shot comment on the tutorial or Challenge assignment. Your comment could be about what you learned, what was difficult or what you found interesting. You must comment on at least 5 tutorials. Save the document with a short descriptive name and submit it into this assignment in Blackboard by the due date listed on your course Detailed Schedule.
Before you attempt this project, you should complete GCFLearnFree.org Access 2019 tutorials:
Access Basics
1. Introduction to Databases
- No action for this tutorial
2. Introduction to Objects
- What are the four main objects in an Access database?
3. Getting Started with Access
- Use the practice database and screen shot step 5 and comment on how you re-sorted the objects
4. Managing Databases and Objects
- Use the practice database and screen shot step 4 showing the objects you opened
Working with Data
5. Working with Tables
- Use the practice database and screen shot step 4 replacing Sula's name with your name
6. Working with Forms
- Use the practice database and screen shot after step 3
7. Sorting and Filtering Records
- Use the practice database and screen shot after step 3, make sure you show your task bar with this screen shot.
Running Queries and Reports
8. Designing a Simple Query
- Use the practice database and screen shot step 6 of the query results in data sheet view
9. Designing a Multi-Table Query
- Use the practice database and screen shot step 8 of the query results in data sheet view
11. Creating Reports
- Use the practice database and screen shot step 4
Database Design Tips
13. Modifying Tables
- Use the practice database and screen shot after step 5
14. Creating Forms
- Use the practice database and screen shot step 5
16. Designing Your Own Databases
- No action for this tutorial
Question 6 (12 marks): You must answer both part (a) and part (b). Paul regularly engages Mike to mow his lawn. One day, Mike parks his truck in the driveway in front of Paul's double garage, which as usual is closed and locked while Paul is at work. While Mike is mowing the lawn at the back of the house, a sudden hail storm causes damage to Mike's truck. Mike insists that Paul compensates him for the damage to the truck, since it occurred while Mike was on Paul's property, and would not have happened if Paul had left the garage door open for him. (a) Assume that Paul owes Mike a duty of care. Did Paul breach that duty of care? Why/Why not? (YOU NEED NOT DISCUSS CAUSATION AND DEFENCES.) (8 marks) (b) Since Mike's truck is in the workshop for repair, he accepts a lift from his nephew, Sam, to go to a party. Sam has had his licence for only two weeks. On the way, it started raining heavily and Sam appears to have trouble keeping his vehicle on the road. Mike asks Sam to slow down, but he continues driving at the speed limit. Shortly afterwards, Sam loses control of the vehicle and hits a tree. Both Mike and Sam are injured. Mike sues Sam in the tort of negligence. Can Sam rely on the defence of contributory negligence? Why/Why not? (4 marks) Please use case law and statute to support your answers.Question 5 (12 marks): You must answer both part (a) and part (b). Bec made a contract to purchase Jule's car. Bec paid a deposit of $1,000 with payment of the balance of the purchase price to take place on 11 May at 10.00 am. On 8 May, Bec lost her driver's licence due to accumulated loss of points. (a) Could Bec terminate the contract and recover the deposit, since she was not permitted to drive the car on 11 May? Why/Why not? (6 marks) (b) Since Bec could not drive for a while, she went on a 21-day holiday cruise. She paid for it in advance. A term of the contract provided that passengers would experience an enjoyable and relaxing holiday. Fifteen days into the cruise, the ship hit a rock and sank. Bec lost all her belongings and was extremely disappointed that the cruise turned out to be such a disaster. Advise Bec if she would succeed in claiming for damages. (6 marks)Simon parks his car on the lower portion of Arbutus Drive, where it is quite steep. He was running late for class and in his haste, did not set the parking brake. Although Simon thought he left the manual transmission car in Ist gear, the transmission slipped and disengaged. The car rolls down the hill scrape a Prius that is driving up the road, crosses the 6th Avenue service drive, breaks through the fencing and smashes into the light rail train. In addition to people on the train sustaining injuries, the impact damages the train and knocks it off its track. In the meantime, the Prius veered off the road into a light post, which fell and sparks from the wiring caught the dry grass on fire. The grass fire spread over Green Mountain and caught a small storage building near C-470 on fire. The building contained a variety of flammable products including propane tanks. The propane tanks and other products exploded causing part of the Analyze the case using the IRAC style of analysis. The pertinent facts are listed above. a. First, identify and state the legal issue in the form of a question. What is the legal issue we are examining? b. For the rule, state each element of Negligence (the questions to be asked). c. For the application, separately identify each element and then apply the facts of this case to that element. That is, first identify each of the required elements of negligence. (Review your PowerPoints, if necessary). Then give me a definition or explanation of each element. Finally, tell me how each element applies to this particular fact scenario. So you will have several paragraphs, at least one for each element. d. Finally, draw a conclusion. Make sure that you answer whether or not you would find Simon negligent (draw a conclusion based on your application), and identify specifically which injuries Simon would be held liable for, if, in fact, he was held responsible. Do not consider any legal claims or defenses other than Simon's negligence. Do not consider the comparative or contributory liability of any other party. Keep it simple and focused onMultiple Choice O Yes, since Bride agreed to the new $25-per-plate price O Yes, since Bride could have counteroffered but declined to do so O No, since the modification is based on an illusory promise O No, since promissory estoppel automatically prohibits the modification O No. since Caterer had a preexisting duty to Cater the wedding for $20 per plate