NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2

NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2

NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2

NURS 6411: Information and Knowledge Management | Week 6

In the past several weeks, you have been introduced to the database software, Microsoft Access, and have the opportunity to explore its capabilities for creating tables and establishing relationships. To this point, the focus has been on creating the database. Now, you begin to explore how you get the specific information or data you need out of the database. Reflect for a moment on the types of information that you could use to help in your role as a nurse informaticist. Perhaps you need to know how many patients are being treated for a certain condition, or you may be interested in determining which children are behind on their immunizations. Microsoft Access has the capability to generate a wide range of reports. The possibilities are exciting!

This week, you continue to explore functionalities in Access by generating queries and reports. Also, Part 2 of your Team Database Project is due this week.

Learning Objectives

Students will:

  • Generate a suggestion for using Microsoft Access
  • Develop a plan to design a Microsoft Access database

Learning Resources

Permalink: https://eaziessay.com/nurs-6411week-6-…ft-access-part-2/

Required Readings – NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2

Coronel, C. & Morris, S. (2017). Database systems: Design, implementation, and management (12th ed.). Boston, MA: Cengage Learning.

  • Chapter 7, “Introduction to Structured Query Language (SQL)” (pp.246-305)This chapter introduces structured query language and discusses how it is instrumental in performing efficient data extraction and management.

Cox, J. & Lambert, J. (2013). Step by step: Microsoft Access 2013. Richland, WA: Microsoft Press.

  • Chapter 5, “Create Simple Reports” (pp. 135–156)Chapter 5 explores the creation of simple reports, using a Microsoft Access wizard. The authors then demonstrate how to preview, modify, and print the reports.>
  • Chapter 7, “Create Queries” (pp. 197–226)In this chapter, the authors explore the concept of queries, which are used to filter through information to identify relevant data. The authors examine two types of queries; select and action. They then demonstrate how to create queries, calculate and update records using queries, and finally, how to delete records.
  • Chapter 8, “Create Custom Forms” (pp. 227–254)This chapter focuses on creating custom forms to meet unique needs. The authors review the three main sections for forms, and then demonstrate how to customize each of these sections.

Optional Resources

There are a wide variety of online tutorials available to assist with using Microsoft Access. Below are several you might consider, as needed:

Goodwill Community Foundation, Inc. (2010). Access 2010. Retrieved from http://www.gcflearnfree.org/office

This free resource provides a series of lessons, interactives, and video tutorials to assist in learning how to use Access 2010.

Pollock, A. (2010). Access 2010 essential training. Retrieved from http://www.lynda.com/Access-2010-tutorials/essential-training/62642-2.html

This series of videos provides detailed instruction on all aspects of Microsoft Access 2010 use. This resource requires a paid subscription.

Discussion: Microsoft Access Queries and Reports

As you have begun to explore Microsoft Access these past several weeks, you may have encountered challenges with using the software. In these cases, it can be beneficial to share your experiences with colleagues and exchange tips and tricks for using Access.

In this Discussion, you consider your work with Access so far and reflect on the areas that were difficult for you. You also consider areas where you could provide useful advice for others.NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2

To prepare:

  • Review the steps of planning and creating a database using Microsoft Access.
  • Identify an area or step in Access that you have found to be confusing and determine what you could ask a colleague to help clarify the process.
  • Consider an aspect of creating a database, query, or report using Microsoft Access that is easy for you, or a solution to a problem you found on your own. With this in mind, develop a tip for using Access that can assist your colleagues.

By Day 3

Post your question about using Microsoft Access. Describe your challenges and success with creating tables, designing queries, or generating reports in Access, including what you found easy and what areas were the most challenging.

Read a selection of your colleagues’ responses.

By Day 6

Respond to at least two of your colleagues on two different days addressing those questions raised to which you can provide input or assistance.NURS 6411:Week 6: Fundamentals of Relational Databases in Microsoft Access, Part 2