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.Create a new blank databaseStructure of the DatabaseNOTE: 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:Create two tables.Establish table relationships.Create one form.Create two queries.Create one report.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.Create the TablesTables 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.Department TableCreate a table named Department Table. At a minimum, your table should include the following fields:Department IDDepartment NameManager First NameManager Last NameManager Email AddressManager Phone NumberEmployee TableCreate a table named Employee Table. At a minimum, your table should include the following fields:Employee IDDepartment IDEmployee First NameEmployee Last NameEmployee Date of HireEmployee Rate of PayEstablish Table RelationshipsOnce 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:Join the primary key of the Department Table with the foreign key of the Employee Table in a One-To-Many relationship.Enforce referential integrity.Cascade update related fields.Cascade delete related records.Create a FormOnce 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:Create one form named Department Form that can be used to enter data into both tables.Insert a row below the Employee Table subform. Add a button in the new row to perform the Add New Record action with the text: Add Record.Use the form to enter a minimum of four departments (e.g., Concessions, Rides, Business Office, Guest Services) and a minimum of four employees for each department. Include your name as one of the employees in the Business Office department.Apply the Retrospect theme to the form.Create a QueryThe 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:Create a query named Ride Employees Query based upon the Employee Table.Include the Employee First Name, Employee Last Name, and Department ID fields.Use a Number Criteria for the Department ID field to select only the employees in the Rides Department.Hide the Department ID field.Save and run the query.Create a QueryNext, you will design, save, and run a query to show the number of employees per department:Create a query named Number of Employees Query based upon the Department and Employee Tables.Include the Department Name and the Employee ID fields.Use the Total Row to Count the number of employees per department.Save and run the query.Create a ReportReports 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:Use the Report Wizard to create a report named Department Report.From the Department Table, include the Department Name and Managers’ First and Last Names.From the Employee Table, include the Employees’ First and Last Names.Group by Department Name.Sort Ascending by Employee Last Name Part TWO Create an EXCEL Document 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.Create a new blank workbookStructure of the WorkbookYour workbook must contain three worksheets:Employee Data – This worksheet will contain employee home contact information.Bank Account Ledger – This worksheet will show the debits and credits for the Rio Salado Theme Park bank account.Line Chart – This worksheet will contain a line chart depicting the daily balance for the Rio Salado Amusement Park bank account.Employee Data WorksheetOne 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.Import the Employee Table from your RSC_Theme_Park_Database_MEID.accdb database into a new worksheet.Rename the worksheet as Employee Data.Assign the worksheet tab a color of your choice other than the Office default.Resize the table to add the following columns to the right of the Employee Rate of Pay column:Home AddressCityStateZip CodeEmail AddressPhone NumberEnter data into the newly added columns for each employee.Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.Hide the following columns:Department IDEmployee Date of HireEmployee Rate of PayAlign Left the values in the Employee ID and Zip Code columns.Remove Hyperlinks, if any, from the email addresses.Sort the table by Employee Last Name.Apply Outside Borders to the entire table.Apply an appropriate Table Style of your choice other than the Office default.Freeze the column header row of the table.Use the Page Setup Dialog Box to perform the following tasks:Set the Page Orientation to Landscape.Scale to Fit to one page wide by one page tall.Add a Footer to the worksheet:Enter your Name in the left section.Enter your MEID in the center section.Enter the Course Number and your Section Number in the right section.Bank Account Ledger WorksheetThe Rio Salado Theme Park wants you to create a new worksheet to keep track of their bank account transactions using the following specifications:Add a new blank worksheet to the workbook.Rename the worksheet as Bank Account Ledger.Assign the worksheet tab a color of your choice other than the Office default.In the first row, insert the title RSC Bank Account Ledger.In the second row, create a new table with the following column headers:Entry NumberDateTransaction DescriptionDebitsCreditsBalanceMerge and center the title in the first row over the table columns in the second row.Change the Font Size of the title to 18 pt.Apply a Fill Color of your choice, other than the Office default, to the title cell.Make one entry in the table for each of ten consecutive dates. Be sure to include the Entry Number, Date, Transaction Description, and either a Debit or Credit for each entry. Your first entry should be a deposit (make additional deposits as necessary) so that you do not ever have a negative balance.Use a formula (not a function) with cell references based on the Debits and Credits to calculate the first Balance.Use a formula with cell references based on the Debits and Credits and the previous Balance to calculate the remaining balances.Increase the column widths to ensure that you can view the longest data entry in each cell of the worksheet.Using the Table Tools, add a Total Row to your table and use functions to calculate the Total Debits and Total Credits.Apply the appropriate Number Formatting to all cells in your table.Align Center the Entry Numbers.Use Conditional Formatting to identify the Top 2 Debits in your table.Apply an appropriate Table Style of your choice other than the Office default.Resolve any Error Messages you might receive in any cells.Freeze the first two rows of the worksheet.Use the Page Setup Dialog Box to perform the following tasks:Scale to Fit to one page wide .Add a Footer to the worksheet:Enter your Name in the left section.Enter your MEID in the center section.Enter the Course Number and your Section Number in the right section.Line Chart WorksheetThe Rio Salado Amusement Park wants a visual depiction of the daily balances from the bank account ledger:Select the Bank Account Ledger worksheet.Insert a Line Chart using the data from the Date and Balance fields.Using the Chart Tools, move the chart to a new sheet named Line Chart.Assign the worksheet tab a color of your choice other than the Office default.Select a Chart Style of your choice other than the Office default.Change the Chart Title to Bank Account Balances.Add horizontal and vertical Axis Titles and add meaningful titles.Add Data Labels.Use the Page Setup Dialog Box to perform the following tasks:Set the Page Orientation to LandscapeAdd a Footer to the worksheet:Use the Insert File Name button in the center section.Required Worksheets Arrange the worksheets in the following order:Employee DataBank Account LedgerLine ChartUse a Stepped Layout in Landscape Orientation and be sure the report fits on one page.