Free Essay

Week 5 Uop Mailmerging Checkpoint

In: Computers and Technology

Submitted By bswartz56
Words 319
Pages 2
Robert Swartz

There are quite a few terms used in the Access database for users with little or no knowledge of the program, I would make available to the customer descriptions of those terms and what to do with them.
Identify common Microsoft® Access® database terms
A table is a group of statistics about a particular subject that is kept in rows and columns. Tables sort all available statistics, like personnel and clients, then stores these categories of facts in a separate table. You can build numerous tables in one database, or combine the statistics in different tables for retrieving the data later
To organize the data in a database, you must segregate the available data and then identify the tables that you must have to store this data.

A record is one row of a table. Records contain ordered facts about an individual, a place, or additional real-world things. For instance an Employee table for a business, every record matches to a specific employee of the business. Any numbers of records can be stored on a table

A field is a column in a table. A field denotes a clear characteristic that is kept for all the records in a table. You can direct up to 255 fields in a Jet table. The description of a field consist of the name of the field, the kind of figures that are stored in the field, and any authentication rules that you must have to confirm the stored data.
Data type

Data type decides what kind of figures that the field can store. Jet data kinds consist of the following:
Text, Memo, Number, Date/Time, Currency, Auto number, Yes/no, OLE object, Hyperlink
To make certain that the Wage field in the Staffs table only has numbers and not text, you would set the data type of the Salary field as Currency.…...

Similar Documents

Premium Essay

Mktg 522 Week 5 Checkpoint

...Selective distribution is when the manufacturer distributes its products to customers through various intermediaries willing to carry their product. It is good to those companies that are established or new companies seeking distributors. Intensive distribution is when the manufacturer distributes their products or services to as many outlets as possible. This usually common to products consumers buy frequently or in a variety of locations and can apply to snacks, soft drinks, candies and gum. This distribution works well when a new product is being introduced to the market or a campaign to sell more to meet a set sales target. (Marketing Management, 13th Edition. Pearson learning solutions pg. 419 to 421) Comments: 5. Question : (TCOs E, I) How would you describe retailing? What are the four levels of service? Student Answer: Retailing consists of the sale of goods or services from the fixed location directly to a consumer for personal or nonbusiness use. An example of Retailing can be subordinated services like delivery. The four levels of service are; 1). Self service. This is where the customer without any help from the salespeople, locate, compare, select, checkout, and bag the product solely for the purpose of cost saving. 2). Self selection. Customer searches for their own goods and may ask for assistance. 3). Limited service. The retailer carry more shopping goods and services such as credit and product return privileges.......

Words: 1210 - Pages: 5

Premium Essay

Mgmt Week 5 Checkpoint

...evaluations will exhibit (Points : 2) adverse impact. halo effect. recency effect. opportunity bias. global bias. | 3. (TCO 8) One of the major disadvantages of ranking as an appraisal method is that it (Points : 2) cannot be used to compare people in different work groups. does not measure the employees' motivation to use their ability on a daily basis. has opportunity bias. compares employees to a fixed standard. creates excessive competition among employees. | 4. (TCO 8) Wal-Mart rewards high performers with the chance to model or choose a family member to model, for their sales flyers. Wal-Mart is attempting to meet associate's ____ needs. (Points : 2) esteem physiological belongingness security self-actualization | 5. (TCO 8) Ellen claims her job is so easy she goes to work to relax after a busy weekend. She says she'll never retire. Using Herzberg's theory of motivation (Points : 2) Ellen needs to satisfy her actualization need. existence is the need most important to Ellen. hygiene factors are more important to Ellen than motivators. the need for affiliation motivates Ellen. Ellen has a high effort-to-performance expectancy level. | 6. (TCO 8) Cliff works for the New York Department of Transportation. He perceives that his union's contract is so strong he can't be fired and the only way he will get promoted is if the person above him dies or retires. He has (Points : 2) low effort-to-performance expectancy and low......

Words: 650 - Pages: 3

Free Essay

It/205 Week 5 Checkpoint

...Checkpoint - TJX Companies IT/205 March 1, 2013 Checkpoint - TJX Companies This week’s checkpoint deals with the credit card data theft at TJX companies which occurred in July of 2005. According to the book Essentials of MIS, the thieves used a vulnerable wireless network from one of the department stores on the TJX network to gain access. (Laudon & Laudon, 2011, p. 243) After the thieves had access to the network the installed a sniffer program on one of the main computers of the network. They then were able to download any information that they needed to. The TJX Company was still using outdated weak wireless security encryption called WEP, (Wired Equivalent Privacy), instead of upgrading to a more secure version of wireless security, WPA, (Wi-Fi Protected Access). They also did not have any firewalls or data encryption in place. (Laudon & Laudon, 2011, p. 243). The tools that was needed to be in place to help stop this from happening was, the stronger wireless security of Wi-Fi Protected Access (WPA) standard with more complex encryption, they also needed to install strong firewalls, data encryption on computers, and to transmit credit card data to banks with encryption. This breach had some lasting effects on the TJX Company. One of the first effects was that the company had to strengthen the company’s information system security. They also had to agree to have a third-party auditor review their security measures every two years for the next twenty......

Words: 388 - Pages: 2

Free Essay

Week 5 Checkpoint Hsm 220

...20 Week 5 Check Point: Integrated Information Management Michael Rasmussen HSM 220 August 23, 2013 Kevin Larry Week 5 Check Point: Integrated Information Management In order for organizations to perform at an optimal level data and information of the highest importance and quality must be collected and made available for the best decision making and greatest possible impact on the communities they serve. When it comes to data and information there are two types needed that are important to organizations, external and internal. Within the external and internal data there are certain considerations to be made. External considerations include economic, sociological, political, and technological. The internal data and information considerations include organizational purpose, planning, and operations as well as human, financial, and technological resources. The economic considerations that need to be made include who are the present and future funding sources, developing a reputation with funders to learn their needs, input of demographics and client population, the problems and needs of clients, throughput of resources devoted to each program and service, and output of volume of services provided to each client. Also, output for volume of services provided to each client, dropout/ success rate of clients in each program, and success of the programs defined. Information is collected through input, throughput, output, and outcomes for referral sources, consumers,...

Words: 281 - Pages: 2

Free Essay

Checkpoint Week 5 It

...into consideration to train their techs to anticipate attacks. What people, organizational and technology factors contributed to these problems? Sony's employees have contributed to this problem, the lack of training needed was not provided thinking a cyber attack was unheard of through their system. The (CERIAS) who said the problem at Sony was that they Play station Network was using an older web server known as Apache. What was the business impact of the Sony data losses on Sony and its customers Sony took a huge hit when this attack happened, the cyber attack was so planned and precise that Sony had no idea that this entire situation was happening. Sony didn't notify the customer base that there has been a cyber attack until a week later, a total of 77 million users' information had been infiltrated. Sony has been prepared to pay out an outstanding $170 million in the 2011 financial year for these actions as well as offering free games to it's customers. What solutions would you suggest to prevent these problems? The solutions that Sony would need is better anticipation for cyber attacks; Updating the web server to a more modern web server much rather than the old Apache web server that is well-known for having security issues. Also providing your techs with the proper training will overall increase the defense against cyber attacks. Having the knowledge of the system increases better anticipation of cyber attacks in the future....

Words: 296 - Pages: 2

Premium Essay

Week 5: Checkpoint: System Development Life Cycle

...Week 5: Checkpoint: The System Development Life Cycle A system study needs to be performed on an accounting information system. There are four stages of the system development life cycle (SDLC) of a business information system. The cycles are; planning and investigation, analysis, design, and implementation, follow-up and maintenance. A broad view point needs to be used to perform a system study for planning and investigation. A mission, planning goals, and objectives needs to be placed. A team should be set up that will speak with the management continuously. This team can be outside the IT department for that broad view point. Also, management will need to appoint a steering committee to work with the study team. Problems may appear and the study team should do a crucial investigation of the system. Advising the steering committee of the findings will be done. After finding the source the committee will decide what is to be mended. Either, do nothing, do a further investigation, or execute a formal system analysis. The system analysis stage is organized to examine the system in detail. Goals need to be set, such as; general system goals, top management goals, and operating goals. General system objectives show benefits, decisions, access and flexibility to change. Top management goals provide managers with planning data to assist in creating important decisions for the future. Operating management goals provide specific managers with assistance in present decisions.......

Words: 882 - Pages: 4

Premium Essay

Hsa Week 1 Checkpoint

...Week 1 Checkpoint Jessica Liska AAGG1CBKD7 May 9, 2014 Melissa Ellison Week 1 Checkpoint 1. Communication: According to Kettner, communication is ‘the ability to portray the vision clearly.’ (Kettner, 2002) To me this is an adapt portrayal of what communication is. Without the ability to be a good communicator, a manager would find themselves with workers who were confused on the directions they were told and a manager who is frustrated because work was not done to their standards or the way that they had directed. This is a knowledge characteristic because being a good communicator is something you learn from an early age. There are people out there that no matter what, they will never be good at communicating their feelings or wishes to other people in a way that makes sense to anyone but them. 2. Empowerment: “the ability to create a structure that harnesses the energies of others to achieve the desired result” (Kettner, 2002) Being able to create structure out of chaos is a skill that most people take years in learning. For me this is a knowledge characteristic. Being able to direct others in seeing the same vision you have that enables everyone to work together for the same outcome is even harder. This takes years of learning what works best for the manager. There may be tricks that don’t work for others, but work wonderfully for that individual. 3. Persistence: “the ability to stay on course regardless of the obstacles encountered” (Kettner, 2002)......

Words: 951 - Pages: 4

Free Essay

Soc 120 Uop Week 3 Dq 2

...In this archive file of SOC 120 UoP Entire Course you will find the next documents: SOC120 Entire Course A+ Study Guide.doc SOC120 Week 1 CheckPoint - Sociological Research Methods.doc SOC120 Week 1 DQ 1.doc SOC120 Week 1 DQ 2.doc SOC120 Week 2 Assignment - Prejudice and Discrimination Article.doc SOC120 Week 2 CheckPoint - Culture Shock.doc SOC120 Week 3 CheckPoint - Social Construction of Reality.doc SOC120 Week 3 DQ 1.doc SOC120 Week 3 DQ 2.doc SOC120 Week 4 Assignment - Evolution of Formal Organizations Pape.doc SOC120 Week 4 CheckPoint - Social and Formal Groups Comparison.doc SOC120 Week 5 DQ 1.doc SOC120 Week 5 DQ 2.doc SOC120 Week 6 Assignment - Punishment Research Paper.doc SOC120 Week 6 CheckPoint - Deviant Behavior.doc SOC120 Week 7 CheckPoint - Urbanization Trends.doc SOC120 Week 7 DQ 1.doc SOC120 Week 7 DQ 2.doc SOC120 Week 8 Assignment - Future of Modernization Paper.doc SOC120 Week 8 CheckPoint Social Change and Modernization.doc SOC120 Week 9 Capstone DQ.doc SOC120 Week 9 Final Project - Analyze a Sociological Issue.doc Sociology - General Sociology Relativism . Give an example of something that one culture might regard as a virtue that another culture might not. Explain why this could lead to relativism. Egoism and Altruism . Psychological egoism claims that whatever we do, we do out of self-interest. Give an example of an act you think is not done out of......

Words: 373 - Pages: 2

Free Essay

Uop Acc 561 Week 5 Quiz

...details? Download now ACC 561 Week 5 Quiz 3. Which of the following statements about budget acceptance in an organization is true? • The most widely accepted budget by the organization is the one prepared by top management. • Budgets are hardly ever accepted by anyone except top management. • The most widely accepted budget by the organization is the one prepared by the department heads. • Budgets have a greater chance of acceptance if all levels of management have provided input into the budgeting process. 4. What is budgetary control? • The process of providing information on budget differences to lower level managers • Another name for a flexible budget • The degree to which the CFO controls the budget • The use of budgets in controlling operations Quiz Answers just a click away ACC 561 Week 1 Quiz 5. The comparison of differences between actual and planned results • is done by the external auditors. • appears on the company's external financial statements. • is usually done orally in departmental meetings. • appears on periodic budget reports. 6. A static budget • should not be prepared in a company. • is useful in evaluating a manager's performance by comparing actual variable costs and planned variable costs. • shows planned results at the original budgeted activity level. • is changed only if the actual level of activity is different than originally budgeted. Want more details? Download now ACC 561 Week 5 Quiz 7. A responsibility......

Words: 615 - Pages: 3

Premium Essay

Hcp 220 Week 5 Checkpoint Prescription and Drug Labels

...HCP 220 Week 5 Checkpoint Prescription and Drug Labels HCP 220 Week 5 Checkpoint Prescription and Drug Labels Prescriptions are similar to medical orders containing vital information for the care of patients. Pharmacy technicians must understand how to read, transcribe, profile, and fill prescriptions. This CheckPoint provides an opportunity to practice analyzing prescription and drug labels. Resource: Ch. 7 of Pharmaceutical Calculations for Pharmacy Technicians: A Worktext and Appendix B Referto the illustration of the prescription label in Appendix B and the drug label for Allegra® on p. 56. Answerthe following questions: 1. In what ways are the labels similar? 2. In what ways are they different? 3. What accounts for the difference in information between the two labels? Post your answers as an attachment along with a signed copy of the Certificate of Originality under the Assignment link. HCP 220 Week 5 Checkpoint Prescription and Drug Labels HCP 220 Week 5 Checkpoint Prescription and Drug Labels Prescriptions are similar to medical orders containing vital information for the care of patients. Pharmacy technicians must understand how to read, transcribe, profile, and fill prescriptions. This CheckPoint provides an opportunity to practice analyzing prescription and drug labels. ......

Words: 3323 - Pages: 14

Free Essay

Acc 227 Week 5 Checkpoint Flexible Budgets

...ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS To purchase this visit here: Contact us at: ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS ACC 227 Week 5 Checkpoint Flexible Budgets Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 227 Week 5 Checkpoint Flexible Budgets in order to ace their studies. ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS To purchase this visit here: Contact us at: ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS ACC 227 Week 5 Checkpoint Flexible Budgets Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 227 Week 5 Checkpoint Flexible Budgets in order to ace their studies. ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS To purchase this visit here: Contact us at: ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS ACC 227 Week 5 Checkpoint Flexible Budgets Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 227 Week 5 Checkpoint Flexible Budgets in order to ace their studies. ACC 227 WEEK 5 CHECKPOINT FLEXIBLE BUDGETS To purchase this visit here: Contact us......

Words: 433 - Pages: 2

Free Essay

Uop Week 5 Appendix B

...coordinated program and promotes the senior center as a model for the aging and aged. Continental Senior Center promotes successful aging. The organization’s tagline, "In the Heart of Things," not only refers to its downtown location, but also emphasizes that the senior center is actively involved in community activities, especially those geared toward seniors. It provides information and referral services for those seeking help with taxes, health, housing, and other concerns; as well as case management services 3 days per week; and computerized information assistance to help seniors and family members access available area services. Brief Community Description The community of Westminster is a historically rich community founded nearly 200 years ago. Approximately 60% of the population of Westminster is over the age of 60 and have lived in Westminster all of their lives. Of these senior residents, approximately 50% have a poverty-level income. Within the past 5 years, the community of Westminster has begun to expand with the building of new homes attracting younger families, all following the technology firms that have recently located to the community. Funding Opportunity The Wesley Foundation supports multi-issue community organizing groups that work in low-income neighborhoods that are accountable to neighborhood residents, and through which people are empowered to have a major voice in shaping decisions that affect their lives. The foundation supports......

Words: 1618 - Pages: 7

Premium Essay

Managerial Statistics Checkpoint 5

...Checkpoint 5 Complete Exercise 9.13 (The Video Game Satisfaction Case) on page 357 in your textbook A. H0 ≤ 42 versus Ha >42 b: z = (42.954 - 42)/(2.64/√64) = 2.891 Z values at 0.10 = 1.28 - Reject 0.05 = 1.64 - Reject 0.01 = 2.33 - Reject 0.001 = 3.09 - Accept Since we are dealing with the right side of the curve the z values are positive. c: Z = 2.891 therefore right side = 0.0019 Left side = 0.9981 Since p is = 0.0019 it less than 0.10, 0.05. 0.01 but greater than 0.001 D. Very strong evidence Complete Exercise 9.19 on page 358 in your textbook. ( A. H0 = 16 versus Ha ≠ 16 b. α = 0.01 S = 0. 1 b.1 Xbar = 16.05 b.2 Xbar = 15.96 b.3 Xbar = 16.02 b.4 Xbar = 15.94 two tailed critical value rule requires we split α in 2, Therefore (Z 0.01/2)= 2.576 Z = (xbar – 16)/( 0.1/6) B.1 Critical Value Z = (16.05 – 16)/( 0.1/6) Z = 3.0 – therefore readjust P value = 2 time the area to the right of z 2(1- Z) = 2(1- 0.99865) = 0.027 0.027 < 0.01 – therefore reject and readjust CI Xbar ± (2.576)( 0.01/6) 16.05 ± 0.0429 = [16.007, 16.093] readjust B.2 Critical Value Z = (15.96 – 16)/( 0.1/6) Z = -2.40 – therefore do not reject do not readjust P value = 2 time the area to the right of z 2(1- Z) = 2(1- 0.9918) = 0.0164 0.0164 > 0.01 – therefore do not reject and do not readjust CI Xbar ± (2.576)( 0.1/6) 15.96 ± 0.0429 = [15.917,16.003] – reject and readjust B.3......

Words: 788 - Pages: 4

Premium Essay

Week 5 Checkpoint - Xbis/219

...JetBlue Airlines. Their reputation has probably been permanently tarnished because management skipped several key information systems they should've installed early on. When creating a company in the airline industry, the correct thing and create a business model that takes into account disaster strategies and scenarios. There are plenty of other companies they could have modeled themselves after whose experience situations like this before. It would make better sense to play it safe when the storms rolling in to divert flights to other cities, and offer free flight back to the in convenience passengers to help lessen the hassle and inconvenience many of them were going to experience. Being forced t and information infrastructure within a week of major disaster does not give JetBlue Airlines proper testing of the infrastructures to see what works and what doesn't, but I do believe they have learned a great deal from this experience. References Rainer, R. K., Jr., & Turban, E. (2009). Introduction to information systems: Supporting and transforming business. Chapter 8 (2nd ed.). Hoboken, NJ: Wiley....

Words: 266 - Pages: 2

Premium Essay

Week 2 Checkpoint

...Week 2 Checkpoint/Organizational Data and Information Daniel Barr XBIS/219 July 6, 2012 Shawn Rieder Week 2 Checkpoint/Organizational Data and Information Based on the information located on the BIRT Sample Database website, the software allows the user the ability to track many aspects of the defined business. It includes eight different tables. Offices, employees, customers, orders, order details, payments, products, and product lines. By using this software program the user can generate reports based on the data entered. The website also includes an ER-diagram which shows the different departments or types of data and how they are tied to other departments. The software allows for data to be entered by multiple sources, such as different stores and incorporates that data and combines that information to give the company a better picture of the entire company. Of course, information generated by data entry is only as good as the data entered. It is critical that companies train employees to correctly enter data into the system. Incorrect data entered into the system will generate reports that will not be accurate. There are several options available for companies. One option would be to purchase software for data management. Another option which is steadily growing is hiring a firm to store your data as well as manage the data as well. References: UOP Library An Overview of Business Intelligence Technology. Communications Of The ACM [serial......

Words: 280 - Pages: 2