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

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. The Database should contain the following tables: Patient, Physician, Clinic, etc. Unique keys need to be included for each table like a medical record number. Create joins/relationships between tables as needed using the unique key/foreign key. Write a simple Select query that uses the Where clause to select a subset of records. Build a simple form to add, delete, or update a patient. Tips – Use the Relationship button on the Database Tools menu to create relationships between tables as needed. – 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 Sample Select Query (do not use this query): Select ClinicName, TIN From Clinic Where TIN = ‘123456789’ – Use the Form Wizard on the Create menu to create the form. o Select the Design view and add Text boxes and Buttons to the form for adding, deleting, or updating patient information.

"Looking for a Similar Assignment? Order now and Get a Discount!

Place New Order
It's Free, Fast & Safe

"Looking for a Similar Assignment? Order now and Get a Discount!

Get better grades effortlessly,
It’s cheaper than you might think

Effortlessly get the essays and grades you need. You can now get any essay, on any subject and at ANY deadline with just 10 minutes of your time (or less). Your professor will love you for it!