Fordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am. Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership. All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate. To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car. Members whose membership has expired can also pay for the visit or the full renewal fee at this point. Each member has a 7-character Membership Code used as a unique identifier and can register up to three cars. Only one of these cars is permitted to use the car park at a time. The registration form includes the following details for each car: Car Registration Number + Make + Model + Date and Time Registered Car Park Usage Data recorded by the smart system is as follows: Car Registration + Arrival and Departure Date and Time + [Payment Made] At each visit, Member details are automatically assigned based on the Car Registration Number with non-member visits assigned to member code ZZZ999. Attendant details are based on linking the Exit Date and Time to the attendant shift clock in. In addition to Car Details, Member details captured by the Registration Form are as follows: Member Code + Member Name + Member Address + Membership Start Date + [Member Email] + [Member Phone 1] + [Member Phone 2] + Membership Payment The records also keep track of Membership Renewal Dates and Times which also include any updates (removal or addition) to registered cars. Attendant details include: Company Email Address used as a unique identifier for the attendant + Attendant Home Address + [Attendant Home Phone Number] + [Attendant Cellphone/Mobile Number] Attendant Shift records include a Date and a Time. Attendant Shift records include a Date and a Time.     End user development. It has been suggested that an internal Microsoft Access database may be created to handle membership, dynamically interact with the parking system, and generate management reports. The Senior Administrator who is in charge of creating and maintaining the suggested system has invited you to serve in that capacity. The administrator is knowledgeable about Microsoft Office suites.   Can somebody help please:( Apply the following to the word document for this question • Styles • An automatically generated table of contents • Automatically generated index list Create a membership table using Microsoft Excel. Add a second sheet containing test data that would be imported from the smart parking system for each visit. When creating the tables, include calculated fields where necessary and take care to ensure that the data structure can be used to extract data for sending MailMerge letters to members. Create a ONE (1) page MailMerge letter template that will send a renewal reminder only to members whose membership has expired. The reminder must also include a list of car park visits based on sample data held in the spreadsheet plus total number of usage hours and calculation of what the usage would have cost if charges had been based on nonmember rates. Add at least TEN (10) test members with varying number of visits and membership periods. Produce a test plan with THREE (3) test cases for the MailMerge and use them to document test results. Provide instructions for sending letters once a week by email.