Write a simple select query that uses the where clause

Reference no: EM131869284

Assignment: Healthcare Informatics

Instructions for Database Project

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.

Upload to Blackboard or e-mail Microsoft Access file along with a short description of the database.

Reference no: EM131869284

Questions Cloud

State the purpose of the article : Review the journal article. During your discussion, post a link to the article and identify the following: (1 Page).

Martin and maria deduct on their tax return : What amount may Martin and Maria deduct on their 2017 tax return?

Define the root causes of racism and inequality in the us : Provide an explanation for what you would define as the root causes of racism and inequality in the United States.

Discuss how the policy influences clinical practice is used : Discuss how the policy influences clinical practice and is used to promote best outcomes?

Write a simple select query that uses the where clause : 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.

Capital loss carryover is available to the estate : final return, $3,000 of his net capital loss can be deducted against ordinary income in year 20x1, and no capital loss carryover is available to the estate.

Identify the ethical culture problem : Based on the facts in the case and what you have learned in this chapter, evaluate the culture change effort that is under way.

Which projects should firm select if it has unlimited funds : Which projects should the firm select if it has unlimited funds?

Explain the states potential stance for rejecting policies : Explain the state's potential stance for rejecting each of the three federal policies or proposals .

User Account

All Pages