...Database Records and Relational Data Worksheet Complete Parts A and B of this worksheet. Cite any outside sources consistent with APA guidelines. Part A: Database Records l Answer the following patient information questions using the table provided. Refer to figure 4-10 on p. 83 of Health Information Technology and Management for assistance. 1. What patient resides in California? What is the patient number? Sofia Yakaria Pallares is the patient who resides in California. Her patient number is 10259. 2. Who is the provider of Sofia Yakaria Pallares? What credentials does her provider have? Ruth Ann Raymond is the patient’s provider. Ruth Ann Raymond has her MD license. 3. What patient was seen on 11/05/2010? What is the patient’s date of birth? John Peters with a date of birth 05/25/1965 was seen on 11/058/2010. 4. What date and time did patient #1298 visit the doctor’s office? What is the patient’s name and date of birth? Lucy Ann Johnson, date of birth 06/12/1975 visit the doctor’s office on 06/04/2011 at 17:15 (5:15pm). 5. What patient lives in 1704 N. Atlantic Ave Ontario, AZ 85320? What is its encounter number? John Peters lives at 1704 N. Atlantic Ave Ontario, AZ 85320. His encounter number is 111218. Patient Info Table Pat# Last_Name First_Name Middle_Name Birthdate 10259 Pallares Sofia Yakaria 9/18/1985 30528 Peters John 5/25/1965 1298 Johnson Lucy Ann 6/12/1975 Patient Address Table Pat# Address City State...
Words: 570 - Pages: 3
...beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes. Microsoft Excel Microsoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). A workbook is a collection of one or more related worksheets contained within a single file; by default, new workbooks contain three worksheets (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Storing multiple worksheets within one workbook helps organize related data together in one file and enables you to perform calculations among the worksheets within the workbook (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Business typically uses Microsoft Excel to store simple information. Microsoft Access Microsoft Access consists of seven main components: tables, relationships, queries, forms, reports, macros, and modules. Tables are the backbone of a database (Simply Access, 2012). They are look similar to a spreadsheet...
Words: 631 - Pages: 3
...easy to learn, relational database application for Microsoft Windows. This tutorial is designed for users who are new or only have little experience using Access 2003. It introduces fundamental database concepts and operations and illustrates how they are performed in Microsoft Access 2003. This tutorial does not cover all of the features and functions of Microsoft Access 2003; emphasis will be on basic and frequently-used features, such as the creation of tables and queries, or importing spreadsheet into Access. Please be aware that Microsoft Access is only available for Windows users; Mac users may want to seek out a FileMaker Pro Tutorial. Objectives By using this tutorial, you will learn to perform the following operations in Access 2003: • • • • • • Launch Access and identify the parts of the screen. Define fields and field properties constructing table structures. Enter and edit records in a table. Find, sort data. Design custom queries to display data. Import and export data between Excel and Access. Definitions These words are used often in Access so you will want to become familiar with them before using the program and this tutorial. Relational Database: in relational databases such as Access, data is stored in tables made up of one or more fields (Access calls a column a field). The data stored in each 1 column must be of a single data type such as Character, Number or Date. A collection of values from each column of a table is called a record or a row in...
Words: 3238 - Pages: 13
... The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes. Microsoft Excel Microsoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). A workbook is a collection of one or more related worksheets contained within a single file; by default, new workbooks contain three worksheets (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Storing multiple worksheets within one workbook helps organize related data together in one file and enables you to perform calculations among the worksheets within the workbook (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Business typically uses Microsoft Excel to store simple information. Microsoft Access Microsoft Access consists of seven main components: tables, relationships, queries, forms, reports, macros, and modules. Tables are the backbone of a database (Simply Access, 2012). They are look similar...
Words: 691 - Pages: 3
...Relational Databases and Multi-Table Queries Designing Databases and Using Related Data bjectives After you read this chapter you will be able to: 1. Design data (page 607). 2. Create tables (page 612). 3. Understand table relationships (page 625). 4. Share data with Excel (page 626). 5. Establish table relationships (page 630). 6. Create a query (page 642). 7. Specify criteria for different data types (page 645). 8. Copy and run a query (page 649). 9. Use the Query Wizard (page 649). 10. Understand large database differences (page 653). Hands-On Exercises Exercises Skills Covered 1. TABLE DESIGN, PROPERTIES, VIEWS, AND WIZARDS (page 618) Open: a new blank database Save as: chap2_ho1-3_safebank_solution.accdb Back up as: chap2_ho1_safebank_solution.accdb • Create a New Database • Create a Table by Entering Data • Change the Primary Key, Modify Field Properties, and Delete a Field • Modify Table Fields in Design View • Create a New Field in Design View • Switch Between the Table Design and the Table Datasheet Views 2. IMPORTS AND RELATIONSHIPS (page 635) Open: chap2_ho1-3_safebank_solution.accdb (from Exercise 1) and chap2_ho2_safebank.xlsx Save as: chap2_ho1-3_safebank_solution.accdb (additional modifications) Back up as: chap2_ho2_safebank_solution. accdb • Import Excel Data into an Access Table • Import Additional Excel Data • Modify an Imported Table's Design • Add Data to an Imported Table • Establish Table Relationships •...
Words: 29542 - Pages: 119
...BIT 200 FINAL STUDY GUIDE • What is the difference between data and information: o Data is a set of discrete, objective facts about events. In an organizational context, data is most usefully described as structured records of transactions. o Information is a message to change the way the receiver perceives something to have an impact on his or her judgment or behavior. • Ex. Your doctor tells you are on the verge of being obese. If you do not want to increase your risk of heart disease or diabetes, then you need to change your eating habits. • What are the reference disciplines in information systems: o Computer Science- Computer Science is the discipline that seeks to build a scientific foundation for topics like computer design, computer programming, information processing, algorithmic solutions or problems, and the algorithmic process itself. o Management Science-The discipline using math and other analyzed methods to help make better decisions in business. Field includes- decision analysis, probability, and math modeling. • Management Science body of knowledge – uses quantitative approaches to decision making and is referred to as management science, operations research, and decisions science. • What do processors do: o A processor interprets computer program instructions and processes data. • Moore’s Law- Moore’s Law state that processor speeds will double every 18 months • The different kinds of storage memory are: kilobyte, megabyte, gugabyte, terabyte...
Words: 6356 - Pages: 26
...University of Phoenix Material Database Records and Relational Data Worksheet Complete Parts A and B of this worksheet. Cite any outside sources consistent with APA guidelines. Part A: Database Records l Answer the following patient information questions using the table provided. Refer to figure 4-10 on p. 83 of Health Information Technology and Management for assistance. 1. What patient resides in California? What is the patient number? Sofia Yakaria Pallares live in California. Her patient number is 10259. 2. Who is the provider of Sofia Yakaria Pallares? What credentials does her provider have? Sofia’s provider is Ruth Ann Raymond, her credentials are; MD. 3. What patient was seen on 11/05/2010? What is the patient’s date of birth? John Peters was seen on 11/05/2010. His date of birth is 5/25/1965. 4. What date and time did patient #1298 visit the doctor’s office? What is the patient’s name and date of birth? Lucy Ann Johnson was born on 6/12/1975. She was seen by a doctor on 06/04/2011 5. What patient lives in 1704 N. Atlantic Ave Ontario, AZ 85320? What is its encounter number? John Peters lives on 1704 N. Atlantic Ave in Ontario, AZ. His encounter number is 111218. Patient Info Table | Pat# | Last_Name | First_Name | Middle_Name | Birthdate | 10259 | Pallares | Sofia | Yakaria | 9/18/1985 | 30528 | Peters | John | | 5/25/1965 | 1298 | Johnson | Lucy | Ann | 6/12/1975 | Patient Address Table | Pat# | Address | City...
Words: 901 - Pages: 4
...1. a) What is a database? A database is an organized collection of related data. b) How does an RDBMS store data? An RDBMS stores related data in tables. 2. What is one benefit of dividing data into tables? Dividing data into tables eliminates unnecessary data duplication, or data redundancy. 3. a) What is a database schema? A database schema is a description of the data and the organization of the data into tables in a relational database. b) Explain the considerations for dividing data into related groups. Considerations for dividing data into related groups includes grouping information so that there is little or no data redundancy. However, each table must have data related to at least one other table, which will require data duplication. This is not considered data redundancy. A table with no relationship to any another table does not belong in the database. 4. a) What is a field? A column in a table. Used to store data. b) Explain why a field that stores more than one piece of data is considered poor design. A field that stores more than one piece of data limits the sorting and searching capabilities of the database. 5. List four guidelines to follow when choosing field names. 1. Make field names unique. 2. Choose the shortest possible...
Words: 1840 - Pages: 8
...Question 1 A small green triangle in the upper-left corner of a cell indicates that Select one: a. the cell contains a comment b. the cell has been changed by a user c. the cell contains a circular reference d. the cell may contain an error Question 2 A ___ is a numeric description of a single item on a scatter plot Select one: a. data series b. outlier c. catagory label d. data point Question 3 A ___ is a symbol used to compare one cell's contents to another cell or a value Select one: a. Linear Regression b. Relational Operator c. Range Criteria d. Integrator Question 4 A(n) ___ is a preconstructed formula that makes difficult computations less complicated Select one: a. syntax b. argument c. formula d. function Question 5 Add, enter, or delete records in an Access database table by using the Select one: a. Relationship view b. Import view c. Design view d. Datasheet view Question 6 Field properties are shown in Select one: a. Design view b. Datasheet view c. Both Design and Datasheet views d. Neither Design nor Datasheet view Question 7 Given a single data series, what kind of chart visually indicates the relative size of each entry? Select one: a. line chart b. bar chart c. pie chart d. histogram chart Question 8 Given the function =VLOOKUP(C6,D12:F18,3) Select one: a. the entries in cells D12 through D18 are in ascending order b. the entries in cells D12 through D18 are in descending order...
Words: 1789 - Pages: 8
...is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team D will demonstrate this by explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process. Usefulness Depending on whom you speak with you will get a different response when asked, which software is better Microsoft Excel or Access. They are both very powerful and unique software used by tremendous amount of individual’s worldwide. Just know that both are used to make our day at work or even at home easier by recording and organizing important data. However, how they store, organize, or display that data is completely different from each other making it one of the major differences between the two. For example, excel offers what is known as the what-if analysis, which can forecast the outcome of the worksheet. Although they may seem completely different visually, they are very similar in the information that can be stored. Microsoft access can store data in tables that look similar to those of a worksheet but function quite differently. Microsoft Excel on the hand displays flat-file database, which instead of...
Words: 684 - Pages: 3
...Database Concepts Name Institution Date Database Concepts Database is essential in an organization for the management of records and other important office work in the organization. I would stick with the current database management software in my current career for future tasks unless there is a good version for comprehensive data management. The database should have a friendly user interface to facilitate quality data management by all employees in the organization. This database has a list of features that range from the client/server architecture, speed, triggers, foreign key constraints to platform independence that work harmoniously in creating a good relational database for an organization. On the database, the field will act as the smallest unit of data input (Zawodny, & Balling, 2004). It allows the user to write numerical or alphabetical characters for data management. The field is related to a record because they combine to create meaningless data that can be manipulated for meaningful information. A table will contain several records, which will then form the whole database of information for the organization. Managing data in Access is better than using Spreadsheets because of several reasons. Access is a true database and contains several features that guarantee data security over Spreadsheets. Spreadsheets only allow users to perform automated calculations on data than can be handled by a single user at a time. Access is essential in data filtration...
Words: 349 - Pages: 2
...What is Access? Simple databases store information in only one table. These simple databases are often called flat file databases, or just flat databases. More complex database programs, such as Access, store information in multiple related tables, thereby creating what are referred to as relational databases. If the information in a relational database is organized correctly, you can treat these multiple tables as a single storage area and pull information electronically from different tables in whatever order meets your needs. Tables are one of the types of database objects you work with in Access. Other types include forms, queries and reports. Of these object types, only tables are used to store information. The others are used to enter, manage, manipulate, analyze, retrieve, or display the information stored in tables—in other words, to make the information as accessible and therefore as useful as possible. Table – data storage, the actual location of data Forms – used to enter, to change or to delete data Queries Reports Starting Microsoft Access If you are using an IT Services machine, login as usual by entering your username and password. Then, to start up the program: 1. Open the Windows Start button and choose All Programs 2. Select Microsoft Office 2013 then Access 2013 Tip: If you right click on the Microsoft Access entry in the menu and choose Send To then Desktop (create shortcut) you’ll have an icon on the Desktop for future easy access. You can...
Words: 1697 - Pages: 7
...majority of crimes is committed by company insiders Typically covered up or not reported to authorities to avoid embarrassment According to a 2001 survey of over 500 companies and government agencies: 85% detected computer security breaches in the preceding 12 months Financial losses due to security breaches topped $377 million 70% reported that Internet connections were frequent points of attack Only 31% said that internal systems were frequent points of attack. Theft by computer Theft is the most common form of computer crime. Computers are used to steal Money Goods Information Computer resources One common type of computer theft today is the actual theft of computers, such as notebook and PDAs Notebook and PDAs are expensive Data stored on a computer can be more valuable Denial o f Service ( DOS) Attacks bombard servers and Web sites with so much bogus traffic that they are effectively shut down networks, denying service to legitimate customers and clients. Computer security Protecting computer systems and the information they contain against unwanted access, damage, modification, or destruction Two inherent characteristics A computer does exactly what it is programmed to do, including reveal sensitive information Can be reprogrammed Any computer can do only with it is programmed to do Cannot protect itself from malfunctions or deliberate attacks Physical access restrictions...
Words: 7438 - Pages: 30
...also is easier to change data that has previously been entered. Access gives the ability for more than one user to update tables at the same time, and gives the option to create more than one report from the same data. Access stores data in tables that look like worksheets, but are designed for complex querying in relation to data stores in other tables and locations. Access also allows you to use structured query language, to quickly retrieve just certain rows and columns of data that you may want for a report, even if that particular data is part of another table. By converting our data that we currently have in Microsoft Excel to Microsoft Access it will give us the opportunity to track different areas of our business in more ways than one. It will also allow us to effectively maintain our reports to ensure better production and customer satisfaction. Using Microsoft Access as the database for our company is beneficial for so many reasons. For instance, with an access database file, several users can work in the same file at the same time, multiple users, from different computers; can work on an Access database simultaneously. One person could add records to the Customer table while another could create a query based on the Product table. Access also provides two utilities to help protect the data within a database: Compact and Repair and backup. These two functions both help protect our data, Compact and repair reduces the size of the database. Backup creates a duplicate...
Words: 527 - Pages: 3
...IS 1800 Fall 2015 Study Guide for Final 1. 2. Computer defined 3. -4 major functions/operations of a computer- Input: gathering info, Processing: managing/ making decisions about data, Output: display of info, Storage: location of data on computer 4. Information system 5. Hardware/software 6. System software 7. -Application software: software to accomplish specific tasks like word processing or surfing the internet 8. Input/input devices: 9. Peripherals 10. -Data vs. information: data: raw unorganized facts, Info: organized data 11. Output/output devices 12. Types of computers 13. Ethics 14. Data mining 15. Fair use 16. Digital divide 17. –Clipboard: memory location maintained by the operating system used to copy or move text, objects, etc 18. “-grayed out” options: tinted grey indicating it’s disabled and can’t be selected 19. Ctrl + home 20. -Save or save as: Save as allows you to change name and location of file 21. File extensions and Office 2013 extensions 22. -Files and folders: File: collection of data that is saved, opened, and changed, Folder: container that stores files 23. Drive/drive letter and Path 24. My Computer/Windows Explorer 25. -File compression utility: software used to compress/decompress files 26. -Copying or moving a file: 27. Inbox 28. Contacts folder 29. E-mail defined 30. -Spam 31. –Phishing: attempting to acquire...
Words: 1320 - Pages: 6
