Create a form with a sub-form that the center can utilize

Assignment Help Computer Engineering

Reference no: EM133739858

Assignment: Programming- Making table queries in MS Access Excel Project

Feel Better Now Physical Therapy Center has recently had its grand opening. The center offers variety of different therapies. Patients sign up for a session and they are assigned to a therapist for that session. The therapist determines the session length based on the patient's needs at the time of the appointment. Most therapies can be done by any available therapist.

The center is using Excel for data keeping but they realized that the approach may become troublesome and inefficient in the near future. Therefore, they decided to use an intern to migrate their data from Excel to Access before it is too late.

Task I: Import the Excel worksheet into Access as a table. Name the table as tblPhysicalTherapy.

Task II: Using Make Table queries, normalize the tblPhysicalTherapy table. Make sure that each resulting table is in the third normal form.

Task III: Assign a primary key to each table and create one-to-many relationships between the tables.

Task IV: Create a form with a sub-form that the center can utilize. Make sure that the form is professionally designed.

Task V: Using a Make Table query, re-create the original tblPhysicalTherapy table from the normalized tables. Name this table as tblPhysicalTherapy2. Name your Make Table query as qryReCreate.

Reference no: EM133739858

Questions Cloud

How and why is this a risk for the company : SCS 0986 University of Toronto- The risk you are discussing how and why is this a risk for the company, and how does it affect the company and their objectives?

Company asks for new hires to complete several documents : As part of the onboarding process for new employees, a company asks for new hires to complete several documents.

Long-term and relationship : Long-term and relationship-focused approach Provides guidance, support, and wisdom to the mentee Involves a mentor

Academic success and career advancement : Name one service or resource provided by Purdue Global that you can utilize to assist with academic success and career advancement

Create a form with a sub-form that the center can utilize : Import the Excel worksheet into Access as table. Create a form with a sub-form that the center can utilize. Make sure that the form is professionally designed.

What does material feel like and how does it make you feel : Process of creatively playing with and experimenting with one material - Choose one material and the chapter on it in the Encounters with Materials book

Structured and task-oriented approach : Structured and task-oriented approach Focuses on improving specific skills or achieving targeted goals Involves a coach who provides guidance,

Design a poster to promote saving energy aimed : Design a poster to promote saving energy aimed at college students. Concentrate on one action a person can take, such as when to turn off your personal computer

What are factor that one need to consider in making decision : How should marketers choose between these approaches and what are the factors that one needs to consider in making these decisions?

User Account

All Pages