PLEASE YOU NEED TO HAVE A GOOD EXPERIENCE WITH ACCESS 2010 SOFTWARE IN AND OUT.

TOMORROW IS MY FINAL DAY OF SUBMITTING THIS DATABASE. SO I NEED YOU TO SAVE ME. I WANT TO RECEIVE THIS ASSIGNMENT TOMORROW AT 9:00 PM CENTRAL TIME. 

 

P.S IF YOU KNOW YOU CAN’T HANDLE THIS PLEASE DO NOT TAKE IT. I’M REALLY WARNING YOU. I DON’T WANT TO HEAR AT THE LAST MINUTE THAT THE WORK IS TOO MUCH AND I CAN’T FINISH IT TOMORROW.

 

PLEASE DO ME A FAVOR AND DON’T TAKE IT!!!

 

sorry for using that uppercase letter. I’m using it to illustrate how serious I am with this project.

 

YOU CAN START IMMEDIATELY.

 

Thename of my client is Lake Shore Community Clinic.

The paragraph below is basically the problem my client is having,

so my job is to create a database that will help solve that problem.

Please USE ACCESS 2010 TO CREATE THIS DATABASE.

My client is a local clinic who has been operating since 1982 and uses file folders to

store patients’ medical information due to lack of basic computer systems.

The process of storing patient’s information is by filling out a form and storing the

information in a folder. Any patients’ record for over five years will be stored in the

backroom to allow space for incoming patients. Most times, when previous patients

will request for their medical records, it has been a hassle for my client to go back to

the backroom to search for a particular patient’s entire record file. Too often, it gets

lost.

Create project database tables and

relationships

1. Create client database. Save database as XXX_Clientname_date.accdb

2. Create tables for client database based on this:

a. A minimum of 5 tables, including intersection tables where necessary;

b. Add fields, data types, and field properties for each table.

c. Specify primary keys for tables. No two tables should have the same primary key.

d. Add foreign keys to tables, where appropriate, to establish relationships.

e. Do NOT add data to tables before enforcing referential integrity. You’ll be sorry if

you

do.

3. Establish relationships–at least four table relationships required for 5-table

project database. No unnecessary relationships. No table should be unrelated to

other tables in

database.

a. Enforce referential integrity on all relationships.

b. Specify appropriate cascading

actions. c. Create relationship report.

d. Save the report as XXX_DatabaseSystem_RR_v1_Date.

e. In the future, if changes are made to the structure of the database, create a

relationship report as documentation. Include version number in report name to

distinguish from

previous versions.

4. Add records to tables—a minimum of 8 records for most

People/Products/Orders/Events tables. Do not add data to the tables until you

have enforced referential integrity.

5. Save changes to XXX_Clientname_date.accdb.

6. Go to File/Compact and Repair.

7. Make a backup of your project database.

a. Select File/Save and Publish. In the right column, under the Advanced

heading, select Back Up Database, then click Save As. Browse to your Project

folder on your computer. Notice that Access has added the date to your project

database name.

b. Save to your Project folder

c. Take a screenshot of the Project folder showing all saved backups of the

database to date. Insert screenshot into a c r e a t e d w o r d d o c u m e n t a n d

n a m e i t XXX_H11_3_Structure_date x.

Create project database queries

1. Open XXX_Clientname_date.accdb. Do not use backup database.

a. Queries for the project database system must meet these minimum

requirements: The Project Database System must contain at least five queries

appropriate to the client’s needs.

2. Of these five, at least one query must prompt the user for input (i.e., parameter

query) and use the input in the criteria for the query. Save the query as

qryParameter.

a. In a Word document, type the name of the query, then answer the following

questions about the query.

(1.) How does this query support the business process under

study? (2.) What results should be expected?

(3.) Which form or report will use this query as a record

source? (4.) Include a screenshot of QBE grid and table

list.

(5.) Save the Word document, as XXX_Query_Justification_date x.

3. Of these five, at least one query must use an aggregate function to calculate a

summary statistic for an appropriate field in a table. Save the query as

qryAggregate.

a. Open XXX_Query_Justification_date x, type the name of the query, then

answer the following questions about the query:

(1.) How does this query support the business process under

study? (2.) What results should be expected?

(3.) If an expression (formula) is calculated in the query results, explain the

elements of the calculation. Use Excel to verify that the Access expression

produces

accurate results.

(4.) Which form or report will use this query as a record

source? (5.) Include a screenshot of QBE grid and table list.

(6.) Save XXX_Query_Justification_date x

again.

4. Of these five, at least two queries must retrieve data from multiple tables. Save the

queries as qryMultiple1 and qryMultiple2.

a. Open XXX_Query_Justification_date x, type the name of the query, then

answers the following questions for each of the two queries:

(1.) How does this query support the business process under
study? (2.) What results should be expected?

(3.) If an expression (formula) is calculated in the query results, explain the

elements of

The calculation. Use Excel to verify that the Access expression produces

accurate results.
(4.) Which form or report will use this query as a record

source? (5.) Include a screenshot of QBE grid and table

list.

(6.) Save XXX_Query_Justification_date x again.

5. Add one more required query that can be used to meet the client

requirement for information.

a. Open XXX_Query_Justification_date x, type the name of the query, then
answers the following questions for each of the two queries:

(1.) How does this query support the business process under
study? (2.) What results should be expected?

(3.) If an expression (formula) is calculated in the query results, explain the

elements of the calculation. Use Excel to verify that the Access expression

produces accurate results.

(4.) Include a screenshot of QBE grid and table list.

(5.) Which form or report will use this query as a record

source? (6.) Save XXX_Query_Justification_date x

again.

6. Save changes to the project database system using the name

XXX_Clientname_queries_date.accdb.

7. Make a backup of your project database system.

a. Select File/Save and Publish. In the right column, under the Advanced
heading, select Back Up Database, then click Save As. Browse to your Project
folder on your computer. Notice that Access has added the date to your project
database name.

b. Take a screenshot of the Project folder on your Cloud folder showing all saved

backups of the database to date. Insert screenshot into

XXX_H11_4_Queries_date x.

c. Save to your Project folder.

8. Save file in one folder XXX_Query_Justification_date x and the backup of your

client database

Create project database forms

1. Open latest version of XXX_Clientname_queries_date.accdb. Do not use backup

database.

2. Forms must meet these minimum requirements

a. All the necessary forms for inputting and displaying the data in your database as

required by your client. One form per table for data entry. Include buttons on the

forms to move to the next record, last record, previous record, and first record.

Save each form with the syntax frmTableName.

b. At least one form displaying data from a query based on a parameter query.

The form should allow the user to select a value from a dropdown list, to run

the query, and to close the form. Save the form as frmParameter.

c. At least one form displaying data from a minimum of two related tables. Save

the form as frmMultiple. Include appropriate command buttons on form.

d. Open a Word document and make a screenshot of the two-table form. Save the

Document as XXX_H11_5_Forms_date x to your Project folder.

3. Add additional forms that are necessary to meet the client requirements.

4. Save changes to the project database system using the name

XXX_Clientname_Forms_date.accdb.

5. Make a backup of your project database system.

a. Select File/Save and Publish. In the right column, under the Advanced
heading, select Back Up Database, then click Save As. Browse to your Project

folder on your Cloud location. Notice that Access has added the date to your

project database name.

b. Save to your Project folder, and then email a copy to yourself.

c. Take a screenshot of the Project folder showing all saved backups of the

database to date. Insert screenshot into XXX_H11_5_Forms_date x.

Create project database system reports

1. Open XXX_Clientname_forms_date.accdb. Do not use backup database.

2. Reports must meet these minimum requirements

a. At least four reports (total) for data output that display valuable information;

b. Of these four, at least two reports should be based on a multiple-table query.

Name the reports, rptMultiple1 and rptMultiple2. Reports should be titled properly

including organization name, tables used, and the object type (report).

(1.) Open a Word document and make a screenshot of one of the reports

based on a two-table query. Indicate which query the report is based on.

(2.) Save the document as XXX_H11_6_Reports_date x to your Project

folder. c. At least one report should display grouped data. Name the report,

rptGrouped.

3. Add additional reports that are necessary to meet the client requirements.

4. Save the project database as XXX_Clientname_reports_date.accdb.

5. Make a backup of your project database.

a. Select File/Save and Publish. In the right column, under the Advanced
heading, select Back Up Database, then click Save As. Browse to your Project
folder on your Cloud location. Notice that Access has added the date to your

project database name

c. Take a screenshot of the Project folder showing all saved backups of the

database to date. Insert screenshot into XXX_H11_6_Reports_date x.