...i MS Access Exercise You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft Access questions. On this particular day, you are presented with the following three situations: Situation 1: Jack, a veterinarian, has experienced tremendous growth within his business. All animal records are shelved in folders and are sorted alphabetically by the owner’s name. Jack is ready to rid himself of the time and space these files take and has inquired about Access. He wants to know about the key functions of using Access and how a table, query, primary key, and a report are important to his database needs. For this person exploring about the Microsoft Access and the key functions, I would start with clarifying that Microsoft Access is used to make databases for all the animal records. Microsoft Access users can make tables with the customer’s advice, forms, reports on the animals, their care, and the customer’s payment history. Microsoft Access puts all the information combined composing a relationship between all the data entered. The tables made within the Microsoft Access database can include the information on the animals, and all the records of care given to each person’s animal. Microsoft has the capability to make these reports to provide an analysis of the data. The Microsoft Access database contains a query interface that lets the data to be inserted, and reports for printing. With Microsoft Access the person can...
Words: 721 - Pages: 3
...Databases in use:- 1. Mysql What is MS SQL? It is a relational web hosting database that is used to store web site information like blog posts or user information. MS SQL is the most popular type of database on Windows servers. It is not free but it has many advanced features that make it suitable for businesses. What is MS SQL capable of? In basic terms, an MS SQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MS SQL have the following features: • Buffer management • Logging and Transaction • Concurrency and locking • Replication services • Analysis services • Notification services • Integration services • Full text search service • Stored procedures • Triggers • Views • Sub-SELECTs (i.e. nested SELECTs) What is MS SQL used for? MS SQL is the database of choice for web applications on a Windows platform (using .NET or ASP). These languages make is extremely easy to connect to a MS SQL database. It is also used for many popular content management systems and other scripts. Learn more about what is MS SQL on its official website. They have comprehensive learning material. You should also check out the SQL tutorial on W3Schools and some articles on the SQL Community Server blog. If you are looking for a web host that supports MS SQL, look at...
Words: 2647 - Pages: 11
...1.2 What is the most commonly used type of database? Ans. The most commonly used type of database is Relational Database. 1.7 Define the terms data and information. Explain how the two terms differ. Ans. There is a subtle difference between data and information. Data are the facts or details from which information is derived. Individual pieces of data are rarely useful alone. For data to become information, data needs to be put into context. 1.22 Define the term database. Ans. Database is a collection of data in an organized form which allows a user for fast storage and retrieval of required data. 1.27 Is Microsoft Access a DBMS? Why or why not? Ans. Microsoft Access is not just a DBMS it is also an Application Generator. Although Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query components that are the Microsoft Access application Generator. 1.33 Name the components of an enterprise-class database system. Ans. These are the components of an enterprise-class database system: 1. Applications Running Over Corporate Network 2. E-Commerce Applications on Web Server 3. Web Portal with Reporting Applications 4. XML Web Services Applications 5. Mobile Apps 1.37 List several consequences of a poorly designed database. Ans. These are the consequences of a poorly designed database: 1. Redundancy 2. Improper Tables or Many Tables for same Object 3. Null Values...
Words: 462 - Pages: 2
...of Party Plates Converting to Microsoft Access Party Plates is a rapidly growing institution and an outstanding plate and napkin supply pioneer, now again, newly poised to guide the direction of special event markets. The increase of company supply paired with the current high demand for said product presents the need for upgrades to the current information system software. Current software is somewhat out-of-date which could result in regression of company growth. Party Plates must acknowledge the ever-changing status of technology and invest in the implementation of new information systems, or current system upgrades. Team C suggests investing in software which will convert current data from Microsoft Excel into a relational database using Microsoft Access. The usefulness of the conversion software will improve internal communications while assisting to streamline some of the work processes for sales departments. This will also increase efficiency in both communications and sales; thus, creating a solid platform for each resulting smoother communications and an increase in sales. Sales will increase because the department can use Microsoft Access with much more facility, which permits more time to focus primarily in sales, not wasting time on dealing with outdated software issues. Systems often crash leaving employees to return to working manually and on their own until the system is restored; the employees at Party Plates using Microsoft Access, can be sure support will be available...
Words: 848 - Pages: 4
...e-business to economic infrastructure, traditional brick and mortar businesses are finding it difficult to compete with more streamlined businesses that are outsourcing their products and services via the Internet. Streamlining Rock Bottom Records by adding a relational database management system (RDMS) and a website will increase productivity and cost savings by reducing the amount of time it takes for analyzing productivity, ordering and shipping, financial, and payroll. Adding a website with a RDMS and offering digital music downloads the company will be able to compete with other companies worldwide. The most popular affordable RDMS’s that are in use today are Microsoft Access that comes with Microsoft Office (Professional) is popular with most small businesses ("Microsoft Access Database: The Pros With Less Cons When Using Microsoft Access As Your Database", n.d.)., PostgreSQL which runs on multiple operating systems and is an open source database, meaning it is free (“PostgreSQL”, 1996-2012)., MySQL is also an open source database that runs on multiple operating systems ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., MSSQL is a closed, propriety database that works great with Microsoft programs ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., and Fire Bird which works well with Window and is also...
Words: 1026 - Pages: 5
...with all data. In order to improve the efficiency of the current information systems used in Party Plates, the antiquated system needs to be upgraded to a much more efficient system such as Microsoft Access. The upgrade will benefit the company in terms of better data tracking and the ability of producingto produce useful reports in relation to customer sales. Microsoft Access is a database software that allows a user to manipulate large amounts of data. Unlike Excel, Access can hold more than 65 thousand records, which can be converted and viewed in various forms depending on what is needed. Microsoft Access offers two main benefits, its user friendly friendliness and its ability to hold large amounts of data without sacrificing performance. Microsoft Access functions in different ways that tie together …what? . Tables are used to store data from which queries can pull information from and perform calculations against the data. Forms can be used to enter information into tables. Reports will allow the information to be displayed in a printer-ready format. The reports can also be exported to other Microsoft Office programs, such as Excel or Word. Finally, macros allow for the automation of database tasks. Modules are an area for advanced programming language within the database. The last sentence does not support the topic - Refer to grammar guide for details on how to avoid dependent clauses and run-on sentences https://ecampus.phoenix.edu/secure/aapd/grammar/writing_style/thesis...
Words: 1402 - Pages: 6
...Microsoft Access or Microsoft SQL Server: What's Right in Your Organization? SQL Server Technical Article Writers: Luke Chung Technical Reviewer: Matt Nunn Published: December 2004, revised July 2006. Applies To: SQL Server 2005 Summary: This paper explains how Microsoft® Access is used within an organization. It also explains when to use Access and when to use Microsoft SQL Server™. Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering...
Words: 6412 - Pages: 26
...I would start out by explaining to the customer what Microsoft Access is. Microsoft Access is software that manages databases. The database collects, organizes, and stores information about things. The second thing I would do is introduce some basic terms of Microsoft Access. A database table looks a lot like a spreadsheet. There are rows and columns like a spreadsheet, which makes it easier to convert a spreadsheet into a database. Each row and column in a table is referred to as a record. Records are where the information that you are entering is stored. The rows hold one type of information; the columns hold a different type of information. Reports are the data that is processed in the tables. Basically, if you have a datasheet made for yearly spending, you can look up a report for whatever year you’re looking for or the current year. Macros in Microsoft Access are a type of programming that helps add functionality to a database. Macros can help simplify things if you have enough experience with it. One example of how Macros can help is, when a person types a certain command, a report can open, a query can be ran, a report can be closed and so on. This programming basically makes life easier by using simple commands. The description of these would vary because depending on how much they know about technology, they may or may not be able to understand these explanations. In order to determine their experience level, one can generally tell by the way the...
Words: 275 - Pages: 2
...Abstract This plan details the components necessary to develop a low-cost inventory control system to replace a frustrating manual tracking and reordering process. The hardware and software needed to implement the system is detailed as well as the cost associated with creating it. Furthermore, administrative functions associated with operation and maintenance of the system is provided with high-level descriptions. Critical counts can be adjusted to meet business specific requirements for any product detailed in the database. The system works in a circular process, from purchase tracking to inventory monitoring to re-ordering and back around again. This design allows a simple and efficient method to produce and inventory control system with the flexibility to manage many product types and suppliers. We all interact with inventory control systems on a daily basis. Rather it is at your local grocery stores checkout line or products purchased from your favorite online retailer, inventory control systems are at the center of our supply and demand chain. These systems ensure when we place our orders for products that the in stock, on order and committed quantities are accurate and monitored. It’s very common for large companies to use these types of systems is also becoming more common for small businesses. The following plan presents a low-cost alternative to the manual processes currently used by a small clothing store. The systems capabilities allow frustrating task such as...
Words: 832 - Pages: 4
...Company Profile Star Wire (India) Limited, one of the leading Mini Steel Plant is engaged in the manufacturing of Alloy Steels, Stainless Steel and Special Steels for diversified engineering application in shape of castings, forging and rolled products. Plant is fully equipped with modern equipment and testing facilities which have created confidence and ability for manufacturing various sophisticated grades of steel conforming to international and National standards. It has its own research and development center to facilitate the manufacturing activities and also catering to engineering and manufacturing industries for failure analysis and other analytical activities. The plant is situated in Ballabgarh, about 37 KMs from Delhi - Capital of India on Main Mathura Road (NH No. 2). The location is at easy approach by Air, Rail and Road. ABSTRACT The project “Counseling Management system” is to exploit the computer technology with Internet Facility and all its aspects as necessity arises. The proposed project will be a web-based portal to provide support and services to the Students of participating in university counseling. The project will make available the Students care services of member colleges to its Students through the Internet. Through this proposed website the Students can register herself and take Admissions and support accordingly. The project “Counseling management system” is specially associated with online Admission procedure of...
Words: 9525 - Pages: 39
...evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can...
Words: 2026 - Pages: 9
...Using Microsoft Access Getting Started Using Microsoft Access Microsoft Access is a computer application used to create and work with databases. In computer jargon that means it’s a Database Management System or DBMS. So what is a database? A database is basically a collection of data or pieces of information. Whether you know it or not, you use databases all of the time. Some examples of commonly used databases might be: • • • • Address book Library catalogue Telephone directory Stock list A database isn’t necessarily contained on a computer. A telephone directory is still a database even if it’s in the form of a huge book sitting next to your phone. However, for the purpose of these exercises, we will assume that the term database refers to an organised collection of information stored on a computer. Databases are intended for storing and maintaining large amounts of information. The following are examples of the sort of information that can be kept in a database: • • • • • Inventory control Payroll systems Personnel records Music collection catalogue Phone and address lists In the exercises that will follow you will create a simple database while you learn the basic features of Access. Later on, you will create a more complex database as you learn more advanced features in addition to some of the principles of database theory. In these exercises it is assumed that you are familiar with Windows use and have experience in using other applications such as Word or...
Words: 4436 - Pages: 18
...Abstract: Performance and scalability are two omnipotent factors determining database availability and reliability. This is especially true for modern computer systems due to the inclusion of the Internet in Online transaction processing (OLTP) and E-commerce applications which use databases. This evolution gave birth to an enduring need for high throughput, good response time, excellent data consistency and concurrency control. This paper evaluates SQL server 2000 and Oracle 9i with respect to performance and scalability. Initial performance tests showed that at low to medium workload both database systems behaved in a similar fashion in terms of throughput and response time. At high load however Oracle 9i emerged victorious in both cases. market and use of the Internet in databases. The first point has lead to competition between commercial and open source database vendors while the second has resulted in a need for high performance database systems. This whole controversy has in the past lead database vendors to employ numerous tricks in bid to improve the processing speed of their systems during benchmarking and thus falsely prove that their databases products are superior to other competitors. Some of their tricks include using high-speed CPUs and clusters, caching up data rows and storing SQL execution plans into RAM prior to testing thus bypassing disk I/O access and tremendously increasing performance (Burleson D, 2002).AS a result the...
Words: 3061 - Pages: 13
...evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can be exported...
Words: 2025 - Pages: 9
...Microsoft Office Microsoft Office is an office suite of desktop applications, servers and services for Microsoft Windows and OS X operating systems. It was first announced by Bill Gates of Microsoft on 1 August 1988 at COMDEX in Las Vegas. Initially a marketing term for a bundled set of applications, the first version of Office contained Microsoft Word, Microsoft Excel and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand. On 10 July 2012, Softpedia reported that Office is used by over a billion people worldwide. The current versions are Office 2013 for Windows, released on 11 October 2012; and Office 2011 for OS X, released 26 October 2010. On 24 October 2012, the RTM final code of Office 2013 Professional Plus was released to TechNet and MSDN subscribers for download. On 15 November 2012, the 60-day trial version of Office 2013 Professional Plus was released for download. A touch optimised version of Microsoft Office is available pre-installed on Windows RT tablets. A mobile version of Office,Office Mobile, is available for free on Windows Phone, iOS (with separate versions for both iPhones and iPads), and Android. A web-based version of Office called Office Online, (formerly...
Words: 1292 - Pages: 6
