Free Essay

Analyzing Data

In:

Submitted By specialkay71
Words 290
Pages 2
Write a 200- to 300-word response that answers the following questions: Based on the article by Samuels and Wood (2007), what are the five basic steps required for analyzing data using Microsoft® Access? How could these steps help you diagnose and troubleshoot Microsoft® Access errors? Which of the five steps presents the greatest possibility for user error and why? Explain your answer.

According to Samuel and Wood (2007) The five basic steps required for analyzing data using Microsoft Access is gather the data, create a database, edit and validate data, connect data files, and perform queries.
I think using the five basic steps helps diagnose problems because if a user is having problems they can always back over each steps to diagnose the problem, for example, let's say you are putting together a shelve and it doesn't look like the picture on the box, most likely you will return to the instruction manual and read the instructions step by step to see where you could have went wrong on your project.

I think Edit and Validate Data could pose a problem for example when a user tries to edit field that has been set using validation rules you cannot edit that field, for example if a field is set to currency, you can’t put text in that field, you will then receive a error message, this can be annoying when Access is being used by multiple users working on the same table, like my assistant works with Access and she often has to edit the tables, if I set validation rules to my liking and she doesn’t have any knowledge that I have done so, she will wonder why she is getting error messages.

Similar Documents

Premium Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data Ballard Integrated Managed Services (BIMS) conducted an internal survey for 440 employees, excluding top management, asking 10 questions on morale and four questions on demographics. BIMS upper management noticed a change in staff morale and an increase in the staff turnover rate, which initiated the survey. Barbara Tucker, General Manager, wants to discover what is making employees want to leave and has enlisted the help of Debbie Horner. Debbie Horner, human resources manager for Ballard, created an internal survey in hopes to calculate descriptive and frequency techniques, and study the data for possible relationships. A total of 78 responses were returned, which is a 17.3% response rate (University of Phoenix Week Two Supplement, 2012). All 78 employees answered on a scale of one to five, with one being very negative and five being very positive. Question #1 of the survey asks employees how well they enjoy working for BIMS. Based on the survey data collected, nineteen percent marked that they were very negative about working at BIMS. Twenty six percent of BIMS employees were negative toward enjoying their work. Over 50% of the participants ranked between being satisfied and very positive about their job at BIMS. Management should communicate with employees to find ways to boost employee morale. Question #2 of the survey asks employees if they enjoyed their assigned shift at BIMS. On the survey on whether the employees enjoyed their...

Words: 2042 - Pages: 9

Premium Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data Leontyne Powell, Omyni, Kahlil Jackson Harrell QNT 351 February 26, 2015 Professor Jonte Lee Analyzing and Interpreting Data Introduction The purpose of this report is to analyze both Ballard Integrated Managed Services, Inc. initial survey and survey B workforce. The first survey results failed to reveal the problems within the workforce that BIMS needs to identify and solve the issues of low morale and high turnover with the organization. This report will analyze B survey, explain the results, and provide a recommendation for the problems uncovered the analysis of BIMS workforce. This report will define statistics and introduce how to analyze and interpret data. The case study used in this report is BIMS LLC, a cleaning, and housekeeping company. This report will present how number data and graphing is used in analyzing data. This report will present an explicit hypothesis. This report will conclude with precise resolutions that will assist the company to move onward to a superior company. Statistics is the science of accumulating and assessing numerical evidence in an enormous measure, especially for the determination of reducing proportions in total from those in a descriptive sample. There are two types of statistics, and one is called descriptive and the other inferential. Descriptive statistics is a technique used to organize, summarize, display facts in a useful manner. Inferential statistics is the procedure used to measure...

Words: 1186 - Pages: 5

Free Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data Jonnerious Gilder, Darryl Hardamon, Tenisha Holman, Simona Lewis, Shawanna Nelson, and Christine Norris QNT/351 July 22, 2015 Huei Holloman Analyzing and Interpreting Data Describe the instrument used for data collection. Data instruments apply “to the levels of measurement of your independent variables and dependent variable” (Lind, Marchal, & Wathen, 2011, p. 5). Survey is a quantitative research approach, not a data instrument. However, “what a scale means and what we can do with it depends on what its numbers represent” (Davis Education, 2015, para. 1). Statistics can be classified into four types or levels, which are nominal, ordinal, interval, and ratio (Lind, Marchal, & Wathen, 2011). Nominal is the easiest of them all. Nevertheless, the ratio is the most complicated of the four type of levels of measurement. Nominal Nominal is hardly measurement. “It refers to quality more than quantity” (Davis Education, 2015, para. 2). A nominal level of measurement is a concerned with differentiating by name. For example, 1 equals male, 2 equals female. Even though, when are using the numbers 1 and 2, they do not symbolize quantity. The two category of 0 and 1 used for the smart cell phone is a nominal level of measurement. They are categories or classifications. “Nominal measurement is like using categorical levels of variables” (Davis Education, 2015, para. 2). Ordinal Ordinal means the order in measurement. “An ordinal scale...

Words: 697 - Pages: 3

Premium Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data Team B Karl Redmon, Monica McNair, Raymond Jones, Connie Guild, Denise Green, Lisa Holley, Lauren Olmedo QNT351 Lance Milner May 25, 2015 Introduction Overview-Monica Barbara Tucker, General Manager at BIMS recently discovered an increase in the turnover rate and a decrease in employee morale due to an undisclosed dissatisfaction in the working conditions which also resulted in an increase in sick time used, and a decrease in work performance. A survey was constructed and implemented by Debbie Homer, HR Manager analyzing the frequency and descriptive techniques of the data received. The survey’s purpose was to elicit information to gain insight on the employee’s views on working conditions, fair treatment, level of compensation, training, shift hours worked, internal communications and job security of the company. However, the initial survey produced findings that were not useful due to errors in keying in the data by office support, and biased questions that affected how the employees responded. As a result of the poorly constructed questions and bias information sought through the survey, only 17.3% response rate was received which was lower than expected. As a result, Debbie realized further communication was needed to explain why BIMS wanted background information from the employees and reassurance the answers provided would be kept anonymous and confidential to elicit a higher response rate. Moving forward Debbie sought approval...

Words: 1050 - Pages: 5

Premium Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data QNT/351 March 25, 2015 Analyzing and Interpreting Data The company Ballard Integrated Managed Services Inc. (BIMS) made a second attempt to find the root problem of the increase in turnover that the company has experienced. The first attempt failed to give a concrete answer do to the low encouraging to employees to complete the survey, also the confusing wording of the survey and for the small percentage of workers that completed the questionnaire. Only a 17.3% of employees completed the previous study. Also, many of the questions were irrelevant to help find the problem. In this new attempt, the study was first tested by five craft workers voluntarily for them to review and give their feedback on the survey. Another change in the second survey is that it was only given to workers that left the company voluntarily. The survey focuses on asking employees about their experience in the business and why the reason of leaving was. In the first survey, it was revealed that the turnover increase was due to low employee morale, a lack of communication between employee and supervisor and low employee performance. The second survey focused on asking if the employee felt well trained in the job assigned, if they felt a fair treatment, if communication was good, what division, how long did they work for the company and the reason for leaving. There were eleven qualitative questions that were to be answered based on a scale from one to five, one being...

Words: 1364 - Pages: 6

Premium Essay

Analyzing and Interpreting Data

...Analyzing and Interpreting Data Debbie Horner, HR manager of BIMS, had several flaws that made the majority of the result for the first survey questionable. She found out that some question should not ask, and other questions were worded awkwardly. The numbers of errors the happened when keying data led to a reduced accuracy in the results. In future Debbie will pretest the sample instrument before issuing it to workforce. Debbie created a second improved survey effort that was better planned and marketed. Barbara Tucker, general manager of BIMS at the Douglas Medical Center approved the request, while the rest of the top management team was disappointed. In the second survey Debbie circulated it among the senior management team, inviting each person to be sure the survey completed. In the individual work a number of suggestions made as well as adding new items. These changes were included in the survey design. Debbie solicited five craft workers to voluntarily pretest it. These five were all on noncritical medical leave, so they were able to comfortably conduct the review. Debbie suggested interviewing the employees who’s already left the organization by asking them “why?” Debbie’s goal was to use the data to create a regression statement that could be used to predict future resignations. Combine finding Going over the issues that rose in part two of the BIMS, we can see that some changes were administered on the second survey. The main issue was the increase of the annual...

Words: 999 - Pages: 4

Premium Essay

Analyzing Financial Data

...Analyzing Financial Data Dereca Akins ACC/230 August 15, 2014 Jean Petrie Analyzing Financial Data | Alternative 1 (Debt) | Alternative 2 (Equity) | Debt ratio | | | Times interest earned | | | Operating profit | 18 million | 18 million | Interest expense | 6.3 million | 4.8 million | Earnings before tax | 11.7 million | 13.2 million | Income tax expenses (40%) | 4,680,000 | 5,280,000 | Net earnings | 7,020,000 | 7,920,000 | Earnings per share | $8.78 for 800,000 shares | $7.92 for 1,000,000 shares | Return on Equity | = 0.1404 or 14.04% | | Adjusted Return on Assets | = 0.108 or 10.8% | or 10.8% | Financial Leverage Index | | | I think that the board should take a look at both scenarios before deciding on which financing route they decide to take. They should consider the change of the ratios in comparison to the numbers that they already represent prior to investing. For instance the debt ratio would decrease 4% if Laurel decided to use the equity financing, proving it to be the better choice based on possible debt (Fraser & Ormiston, 2007, 232). On the other hand earnings per share is higher when using debt financing than it previously was ($7.65) or would be with the equity finance ($7.92) (Fraser & Ormiston, 2007, 232). Likewise, in both cases the financial leverage index is greater than one, which means that the company’s ability to handle debt is well managed. Overall the board should...

Words: 309 - Pages: 2

Free Essay

Analyzing Security Data

...I. Purpose The purpose of this paper is to define and explain the core components of the Windows Server Networking operating system. The following components will be explained: Active Directory, Domain Controller, Tree, Forest, Distinguished Name, Client Services for Netware, Gateway Services for Netware, Microsoft Management Console, Striped Set, Scheme, Global Catalog Server, Native Mode, DHCP, Default Gateway, Emergency Repair Disk, hardware Disk, hardware Compatibility List, Resource Kit, and IP sec. II. Scope of Work This paper discusses the definitions of core components of Windows Server Networking operating system. III. Windows Terminology A. Active Domain The Active Directory is a directory service designed by Microsoft that acts as a universal distributed information service point from which all network objects, including users, processes, configurations and services can be utilized at any entry point to the network. B. Schema The Schema is the formal set of definitions for all object classes and their attributes contained in the Active Directory. Microsoft designed the Schema to be programmable, allowing the system administrator to create new object types and their attributes and modify attributes of existing objects. C. Domain, Tree and Forest The Active Directory structure is comprised of several different levels: the domain, the tree and the forest. The domain consists of the rational grouping of computers operating Microsoft Windows that share...

Words: 571 - Pages: 3

Premium Essay

Analyzing and Interpreting Data: Bims Week 5

...Analyzing and Interpreting Data: BIMS Week 5 QNT/351 November 1, 2015 Analyzing and Interpreting Data: BIMS Week 5 In the aforementioned survey that Ballard Integrated Managed Services created and conducted it was found to have lacked important material making the survey not as accommodating as it could have been. Ballard Integrated Managed Services had asked that recommendations be made about needed information on the survey that will help in the research of the increase of employee turnover. The previous survey covered elements of the proper training, ethics, and demographics but it likes a few more elements. First the survey was given to active employees and not to employees that were leaving the job. Another element of information that needs to be included is safety, such as do the employees feel like the work environment is safe. One more area that may be helpful information is to give the employee the opportunity to make a comment in a section set for additional comments that the survey may not include. For Ballard Integrated Managed Services to conduct a complete survey it is important the survey includes the information needed to acquire the results needed to help resolve the issues. When looking at the results from the exit interview, it is easy to see that the survey gave BIMS a better idea of why the member of the company was leaving, and not how the employee was feeling about his or her job. The questions were re-worded so not to be leading or easily misconstrued...

Words: 455 - Pages: 2

Free Essay

Acc 230 Week 8 Analyzing Financial Data

...ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial Statements Complete Problem 6.6 on p. 232 (Ch. 6). Submit your answers to questions A and B. Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 230 Week 8 Analyzing Financial Data in order to ace their studies. ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial Statements Complete Problem 6.6 on p. 232 (Ch. 6). Submit your answers to questions A and B. Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 230 Week 8 Analyzing Financial Data in order to ace their studies. ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial Statements Complete...

Words: 481 - Pages: 2

Premium Essay

Mkt Chap 8

...opportunity, systematically collecting and analyzing information, and recommending actions. The five step marketing research approach is a way of making decisions in marketing. The five steps include Defining the problem, developing the research plan, collecting relevant information, developing findings, and taking marketing actions. Constraints in a decision are the restrictions placed on potential solutions to a problem such as limitations on time and money. The difference between primary and secondary data is that primary data are facts and figures that are newly collected for the project, while secondary data are facts and figures that have previously been recorded. Some advantages of secondary data are the time savings, and the low cost. disadvantages of secondary data include that the secondary data may be out of date and the categories might not be right for the researchers project. The difference between observational and questionnaire data are that observational data can be collected by mechanical, personal, or neuromarketing methods, while questionnaire data are facts and figures that are obtained by asking people. Personal Interview provides the greatest flexibility. The difference between a panel and experiment is that a panel is a sample of consumers or stores from which researches take a series of measurements, while an experiment obtains data by manipulating factors under controlled conditions to test cause and effect. Data mining differs from traditional marketing...

Words: 358 - Pages: 2

Premium Essay

Medialogic, Tracking Tv Viewership Through People Meter

... | |1/29/2011 | | | Identify the Problems Analysis of gathered data Medialogic Pakistan Ltd. is currently not analyzing the gathered data. Although at the current stage gathering first hand information is very useful for companies, but a lot further analysis can give more valuable insight for the channel operators. User profiles may be inaccurate For identification of different viewers is determined by different buttons. In many cases the operator of the remote is not watching a channel of his/her liking instead is changing the channels on someone else’s behalf. This may misinterpret the information gathered. According to the case there are a total of 4200 people’s data gathered by the company representing 10 million urban users. The sample size in comparison to the population size is far more stretched. Within this sample there is less room for such errors....

Words: 881 - Pages: 4

Free Essay

Qnt 351 Week 1 Paper

...science of collecting, organizing, presenting, analyzing, and interpreting data to assist in making more effective decisions” (p.5). Types and levels of statistics There are two major types of statistics, descriptive and inferential. Descriptive statistics is defined by Lind (2011) as “methods of organizing, summarizing, and presenting data in an informative way” (p.6). An example of descriptive statistics would be a high school report showing that it had 300 graduates in 1990 and 450 graduates on 1991. The information that they provided described the amount of graduates that they had for each year. Inferential statistics is defined by Lind (2011) as “the methods used to estimate a property of a population on the basis of a sample” (p.7). If the same high school sent out a report showing the graduate numbers for 1999- the present to estimate the number of graduates that they would have for this school year, those statistics would be inferential because they are used to estimate future outcomes. There are four levels of statistical data: nominal, ordinal, interval and ratio. The nominal level deals with qualitative variables such as colors and blood types that can only be counted and classified. Ordinal data measurement is a variable rating system that ranks data according to predetermined categories that have only relative values such as poor, average, and good. Data can be ranked and ordered using this method. Interval data measurement adds to the ordered level by adding...

Words: 651 - Pages: 3

Premium Essay

Statistics in Business

...Statistics in Business Statistics is the science of collecting, organizing, analyzing, interpreting, and presenting data. Some experts prefer to call statistics data science, a trilogy of tasks involving data modeling, analysis, and decision making. In contrast, a statistic is a single measure, reported as a number, used to summarize a sample data set. Knowing statistics will make you a better consumer of other people’s data. You should know enough to handle everyday data problems, to feel confident that others cannot deceive you with spurious arguments, and to know when you’ve reached the limits of your expertise. Statistical knowledge gives your company a competitive advantage against organizations that cannot understand their internal or external market data. And mastery of basic statistics gives you, the individual manager, a competitive advantage as you work your way through the promotion process, or when you move to a new employer. Nominal Level of Measurement The nominal level of measurement is the lowest of the four ways to characterize data. Nominal means "in name only" and that should help to remember what this level is all about. Nominal data deals with names, categories, or labels. Data at the nominal level is qualitative. Colors of eyes, yes or no responses to a survey, and favorite breakfast cereal all deal with the nominal level of measurement. Even some things with numbers associated with them, such as a number on the back of a football jersey, are nominal since...

Words: 844 - Pages: 4

Premium Essay

Factors Affecting Academic Performance of Working Students

...working students. In addition, this paper aims to provide encouragement and motivation to all students especially to those who are financially distressed to pursue and finish a college degree in order to competitive in the future and be able to realize their goals and aspirations. It may also provide learning experiences and information to other students who are not working. In order to accomplish our objectives, we adopted several methodologies in obtaining data and information such as conducting surveys by providing questionnaires to our subjects, getting information in the internet and conducting interviews personally and honestly with our target subjects to get assurance that our data, information and values gathered were correct and accurate. Conceptual framework INPUT PROCESS OUTPUT Analysis of the input through 1. Distribution of questionnaires 2. Data gathering 3. Statistical treatment 4. Analyzing 5. interpreting | Determined Factors Affecting Academic Performance of Working Students of EARIST | Profile of the respondents: a....

Words: 1519 - Pages: 7