Question

You have been asked to produce a spreadsheet analysis of the percentages of inpatients treated by patient age. You need to communicate the percentage of patients who were ages 1 through 18, 19 through 35, 36 through 55, and 55 and older. The best type of graph to depict this would be:

Group of answer choices

Line graph

Stacked bar graph

Cluster bar graph

Pie chart

A and C

The use of a Database Management System would be best suited for:

Group of answer choices

Producing thematic maps

Creating a financial model

Creating pie charts

Performing “what-if” analysis

Managing the patient records of a physical therapy clinic

As manager you must create an analysis of staffing requirements for multiple departments. You will need to calculate the number of employees needed for each position using a series of complex formulas incorporating factors such as new patient admissions, the projected numbers of procedures to be performed, follow-up appointments, and several other variables. The best program for this effort would be:

Group of answer choices

Microsoft Access

Microsoft Word

ArcMap GIS

Microsoft Excel

None of the above

Which two of the following describe a relational database?

Group of answer choices

A relational database can consist of one single table containing all of the information.

Microsoft Access is not capable of creating a relational database, only flat file databases are allowed

Tables containing names must be sorted in alphabetical order

A relational structure is the often the best design for databases in which a single person-level record must be associated with multiple transaction records for the same individual

Each table in the relational join must contain a unique key field allowing the records to be joined to another table containing the same key field.

In comparison to Microsoft Excel, which one of the following statements with respect to Microsoft Access is true?

Group of answer choices

Access is more flexible since you can enter the data at the same time that you create the database structure.

Access allows you to quickly create complex formulas for specific cells.

Access database fields must be defined prior to any data being input into it.

Due to its capacity limitations, Access should not be used if there are over 1,000 records and the number is expected to grow over time.

Access allows data to be copied from one range to another.

Answer 1

First Question:

Fourth option is the correct answer.

Pie chart graph is the best choice since we have to represent the percentages in the graph.

Other given options are incorrect.

Second Question:

Fifth option is the correct answer.

The use of a Database Management System would be best suited for managing the patient records of a physical therapy clinic.

Other given options are incorrect.

Third Question:

Fourth option is the correct answer.

Microsoft excel is the most appropriate choice since it provides calculation based on complex formulae, effective data representation, etc.

Other given options are incorrect.

Fourth Question:

Fourth and fifth options are the correct answers.

Other given options are incorrect as follows:

A relational database can consist of one single table containing all of the information - There should be multiple tables. Flat file database contains one single table.

Microsoft Access is not capable of creating a relational database, only flat file databases are allowed - No, it can.

Tables containing names must be sorted in alphabetical order - It is not a mandatory criteria.

Fifth Question:

Fourth option is the correct answer.

Due to its capacity limitations, Access should not be used if there are over 1,000 records and the number is expected to grow over time.

Other given options are incorrect.

Hope this helps.