Use Access to create a database in which you can store and retrieve information about the Rio Salado Theme Park operating departments, their managers, and their employees.
NOTE: Read the requirements for the database and be sure you understand how it should work before creating your design.
You will need to complete the following:
As you work on the project, remember to follow best practices for creating databases as described in your TestOut materials and the online lesson content.
Tables and their relationships form the backbone of a relational database. In this database, you will create a table for the Rio Salado Theme Park operating departments and their managers, and a table for employees in each department. When creating fields for your tables, it is important to break down your data into the smallest chunks you can (fine granularity) to make it easier to extract data from the database later. Remember to assign the most appropriate data type to each of the fields and that one of the fields in each of your tables must be set as the Primary Key using the AutoNumber data type. You do not need to enter data records into your tables at this time; you will create a form later in this project for data entry.
Create a table named Department Table. At a minimum, your table should include the following fields:
Create a table named Employee Table. At a minimum, your table should include the following fields:
Once the design of the tables has been completed, the next step is to establish relationships between the tables. You will join the Department Table with the Employee Table on common fields through the following tasks:
Once the tables have been designed and the relationships have been established, it is time to enter data. You will use one form to enter and edit data in the two tables:
The ability to extract data from one or more tables is one of the most important functions provided by a database. You will now design, save, and run a query to show only the employees in the rides department by following these tasks:
Next, you will design, save, and run a query to show the number of employees per department:
Reports are used to generate printouts from the tables in a database. The Report Wizard can be used to access multiple tables, select fields, and group data in a report:
Save and close your RSC_Theme_Park_Database_MEID.accdb database.
Use Excel to create a workbook containing three worksheets. The Excel workbook will include employee home contact information and a bank account ledger for the Rio Salado Theme Park.
Your workbook must contain three worksheets:
One of the best features of Excel is how easily it can work with data from other programs. Because you already created employee data in Access, you can import that data into Excel to reduce time and effort in creating this worksheet.
The Rio Salado Theme Park wants you to create a new worksheet to keep track of their bank account transactions using the following specifications:
The Rio Salado Amusement Park wants a visual depiction of the daily balances from the bank account ledger:
Arrange the worksheets in the following order:
Save and Close your RSC_Theme_Park_Workbook_MEID.xlsx workbook.
After completing both sections of the project, submit your Access and Excel files following the instructions in the lesson.
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
Why Hire Safehomework.com writers to do your paper?