There The GCFLearnfree 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 7 In a saturated solution of a salt in water, the rate of crystallization > the rate of dissolution a. the rate of dissolution > the rate of crystallization b. seed crystal addition may cause massive crystallization addition of more water causes massive crystallization d. the rate of crystallization = the rate of dissolution eQuestion 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 1 (12 Marks) Create the context Diagram and level 1 DFD Ikea Company sells a line of high-quality product. When customers place orders on the company's Web site, the system checks to see if the items are in stock, issues a status message to the customer, and generates a shipping order to the warehouse, which send the shipping information to the manage receivable account module. The check status sends order data to the pending order file. The generate shipping order obtains the order data from pending order file and send the shipping order to the Warehouse. When the order is shipped, the customer is billed. A manage receivable account sends the bill to the customer. The customer sends the payment to manage receivable account module. The account receivable file is updated with accounting data. The system also produces various reports, such as inventory reports for Accounting.Problem #8 (25 points) Western College has two service departments, Campus Safety and Technology Services that assist the Business School and the Law School. Budgeted costs of the Campus Safety and Technology Services are $900,000 and $1,900,000, respectively. Usage of the service departments' output during the year is anticipated to be: Provider of Service User of Services Campus Technology Safety Services Campus Safety 15% Technology Services Business School 25% 60% Law School 75% 25% Required: A. Use the direct method to allocate the costs of the Campus Safety and Technology Services to the Business School and the Law School.Which of the following examples accurately describes a difference in the types of business combinations? (Select the best answer.) a. A statutory merger can only be effected through an asset acquisition while a statutory consolidation can only be effected through a capital stock acquisition. b. A statutory merger can only be eected through a capital stock acquisition while a statutory consolidation can only be effected through an asset acquisition. c. A statutory merger requires the dissolution of the acquired company while a statutory consolidation requires dissolution of the companies involved in the combination following the transfer of assets or stock to a newly formed entity. d. A statutory consolidation requires dissolution of the acquired company while a statutory merger does not require dissolution. e. Both a statutory merger and a statutory consolidation can only be effected through an asset acquisition but only a statutory consolidation requires dissolution of the acquired company