[et_pb_section fb_built="1" specialty="on" _builder_version="4.9.3" _module_preset="default" custom_padding="0px|0px|0px|||"][et_pb_column type="3_4" specialty_columns="3" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="28px|||||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" hover_enabled="0" sticky_enabled="0"]
-
- QUESTION
Navigate to the Running Queries and Reports Tutorials using this link
( https://www.gcflearnfree.org/access2016/ )
Review each tutorial and then write a summary.
8. Designing a Simple Query
9. Designing a Multi-table Query
10. More Query Design Options
11. Creating Reports
12. Advanced Report Options
Write, in your own words, a one-two paragraph summary on the Running Queries and Reports tutorials. Apply critical thinking and an academic writing style that demonstrates your understanding of the difference between a Microsoft Access database and an Excel spreadsheet by comparing the features of each and when they would be used as personal computer applications if applicable.
Scoring criteria-
-Information is correct and written in your own words - 75%
-Academic writing style with correct spelling, grammar, punctuation - 20%
-Outside sources - 5%
[/et_pb_text][et_pb_text _builder_version="4.9.3" _module_preset="default" width_tablet="" width_phone="100%" width_last_edited="on|phone" max_width="100%"]
| Subject |
Uncategorized |
Pages |
2 |
Style |
APA |
[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner module_class="the_answer" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" width="100%" custom_margin="||||false|false" custom_margin_tablet="|0px|||false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop"]
Answer
Running Queries and Reports
In Access, queries can be used to search and compile data from a set of tables. Unlike in the case of Excel whereby search and filter capability is used to obtain information from a table, queries in access are considered as time saving as the information available in multiple tables can be explored to provide a high-level and detailed data, presented in table/datasheet format, which could not be easily retrieved through a search and filter technique from the tables. Multiple-table queries can also be created which enable an Access user to relate contents from different tables in a database to understand the existing association (“Access 2016”). Two related tables can be joined to make it easy to retrieve information in the future. However, adequate planning is essential when it comes to Multiple-table queries.
Queries can also be modified or sorted, an action carried out under the design view option. The data can be sorted in an ascending or descending order. A sum function can also be used to complete the sum of items in a table which can further be queried to provide the quantity after the computation. A report is an important function available in Access which can be used to share the contents of the database without allowing the viewer to make changes to the contents (“Access 2016”). A report is created based on the object and it can be modified to meet user requirements in terms of size and visual appeal. Before sharing a report, one can delete field and even print the contents of the database. Additionally, a user can change the logo, format the color and fonts as needed. Access and Excel applications vary in that Excel offers a spreadsheet that completes calculation and represent the data visually. On the other hand, Access provides a system for data management that aids in the data storage and management. Notably, Excel has unique mathematical functions for computations such as “what-if” functions as well as charting options for visually displaying the computations. On the contrary, Access has queries functionality used for data summary and aggregate values presentation such as sum. The reporting options in Excel is more sophisticated than in Access since it has an advanced PivotTable reporting option and charting features not experienced in the case of Access.
References
|
|
“Access 2016”. GCFGlobal, 2020. Web. 23 May 2020. https://edu.gcfglobal.org/en/access2016/
Appendix
|
Appendix A:
Communication Plan for an Inpatient Unit to Evaluate the Impact of Transformational Leadership Style Compared to Other Leader Styles such as Bureaucratic and Laissez-Faire Leadership in Nurse Engagement, Retention, and Team Member Satisfaction Over the Course of One Year
|
|
|
|
|
|
|
[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop" custom_padding="60px||6px|||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" min_height="34px" custom_margin="||4px|1px||"]
Related Samples
[/et_pb_text][et_pb_divider color="#E02B20" divider_weight="2px" _builder_version="4.9.3" _module_preset="default" width="10%" module_alignment="center" custom_margin="|||349px||"][/et_pb_divider][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner use_custom_gutter="on" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px||" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="13px||16px|0px|false|false"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_blog fullwidth="off" post_type="project" posts_number="5" excerpt_length="26" show_more="on" show_pagination="off" _builder_version="4.9.3" _module_preset="default" header_font="|600|||||||" read_more_font="|600|||||||" read_more_text_color="#e02b20" width="100%" custom_padding="|||0px|false|false" border_radii="on|5px|5px|5px|5px" border_width_all="2px" box_shadow_style="preset1"][/et_pb_blog][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type="1_4" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_sidebar orientation="right" area="sidebar-1" _builder_version="4.9.3" _module_preset="default" custom_margin="|-3px||||"][/et_pb_sidebar][/et_pb_column][/et_pb_section]