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.
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.
Post by tomorrow 07/05/2016 a minimum of 550 words with 3 references
1) your question about using Microsoft Access.
2) 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.
Required Resources
• Coronel, C. & Morris, S. (2015). Database systems: Design, implementation, and management (11th ed.). Stamford, CT: Cengage Learning.
• Chapter 7, "Introduction to Structured Query Language (SQL)" (pp. 236-321)
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 https://www.gcflearnfree.org/office
This free resource provides a series of lessons, interactives, and video tutorials to assist in learning how to in the use Access 2010.
• Pollock, A. (2010). Access 2010 essential training. Retrieved fromhttps://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.