Microsoft Access Database with mock data - Easy to do

Create a Microsoft Access database with mock data including creating relationships between tables, creating a query, and creating a form that allows you to add, delete, or update a record. 1. The Database should contain the following tables: Patient, Physician, Clinic, etc. 2. A unique key field needs to be included for each table like a medical record number for a patient record or a NPI for a provider/practice. 3. Create relationships also known as joins between tables using any related unique key fields. 4. Write a simple SQL Select query that uses the Where clause to select a subset of records. 5. Build a simple form to add, delete, or update a record in any table. Tips - Use the Relationship button on the Database Tools menu to create relationships or joins between tables with related unique key fields. - Use the Query Design button on the Create menu to create the query. Once the Design View screen loads, right click on the query tab and select the SQL View to type in your SQL Query o SampleSelectQuery(donotusethisquery): Select ClinicName, TIN From Clinic Where TIN = ‘123456789’ - Use the Form Wizard on the Create menu to create the form. o SelecttheDesignviewandaddTextboxesandButtonstotheformforadding,deleting, or updating patient information. Microsoft also has a good support site at https://support.office.com/en-us/access. Upload to Blackboard or e-mail Microsoft Access file along with a short description of the database. Evaluation Criteria Evaluation for grade 1. Correct use of database tables 2. Correct use of unique key/foreign key 3. Successful join created between alike fields in at least two tables 4. Successful query written to select a subset of records from the table(s) of your choice 5. Successful form built to add, update, or delete a patient