Office Databases Essay

847 words - 3 pages

The need for databases is the heart of running an organization. Databases will provide an organization with an edge over the competition. The databases we use hold all the information about the daily transactions and important customer information. Databases use structured query language, SQL Server, to run security and transactions. The SQL server provides users with fast and efficient access to files on the database. The use of database programs has become a necessity to almost every business big or small. About.com stated, "Databases are designed to offer an organized mechanism for storing, managing, and retrieving information," (http://databases.about.com, 2006). There are many server-based database programs that are available. Some of these databases include IBM, Informix, Microsoft, Oracle, and Sybase, (Whiting, 2000). Server-based databases help to manage customer and employee records, inventory, and financial transaction records along with many other types of business information.Databases are vital for almost every company in today's business world. Databases can help us track inventory, billing, pay role, and much more, (www.devshed.com, 2006). Without the use of databases, work will take infinity longer to accomplish. If the database did not exist, we would have to revert to paperwork, which will slow down productivity. Employees would then have to hand-write everything down and make phone calls and faxes to accomplish simple tasks. Since we use a database, all users from customers to employees, will have access to the information.My company has hundreds of databases that are all connected together in one way or another.Information in one database is linked to another database or a spreadsheet on another network or system. Access to these databases is very limited because of security. Since these databases are linked together in many ways, each department can only see what he or she need to access to complete their work. The only person or group that has total control of the relationship of the databases would be the IT department, mainly the Database Administrator (DBA). This group adds the users to the groups for access and security. They also assign what the user will and will not see once logged on the network.My department uses several types of databases; from Microsoft Access to the server-based SQL server. Microsoft Access is a database system that is part of the Microsoft Office package. Access has a graphical interface combined with the Jet relational database engine. According to tecnolopedia.com, "This combination makes it possible for beginner programmers and non-programmer 'power users' to build sophisticated 'front-ends' to complex databases", (www.technolopedia.com, 2004). Our Microsoft Access databases are custom-built to suit my organization's...

Find Another Essay On Office Databases

Databases Essay

962 words - 4 pages Databases in My Organization Abstract      Databases have been in use since the early days of computing programs. An Information Technology services company, such as Getronics, not only utilizes databases for information and record management, it earns revenue by providing database management services. Getronics uses Microsoft SQL Server 2000 as its database software. The clients that contract Getronics for

Essay

923 words - 4 pages There are many different types of Searchable databases on the internet that can be used to retrieve all types of data. To under stand how different databases work we must first understand what a Searchable database is. A database is a collection of data or information organized for rapid search and retrieval, especially by a computer. Databases are structured to facilitate storage, retrieval, modification, and deletion of data in

CIS 319 Database Memo

684 words - 3 pages Microsoft Office Fluent user interface overview Retrieved March 5, 2008http://ohttp://office.microsoft.com/en-us/suites/HA101679411033.aspxffice.microsoft.com/en-us/suites/HA101679411033.aspxConvert Excel To Access Databases Retrieved March 5, 2008http://www.pcapps.com/home/services/Excel_To_Access.aspx?

Database usage Memo

1162 words - 5 pages claimant information that we store and track; we also have to a database system for the tracking of office supply inventory and employee travel expense claim information. Using multiple types of databases, allows for staff to identify the location of data by the software that it was created and saved in. The most popular software used to store data at EDD is Microsoft Excel. Excel allows for easy analyzing and organization of information into a

Databases at Wachovia

885 words - 4 pages database is a collection of information that can be easily accessed, managed, and updated. (www.whatever.com) Regardless of the type of information that is stored in a database, it is categorized and filed. And every type of business utilizes a database for information and record management.A banking company, such as Wachovia, not only utilizes databases for information and record management, it earns revenue by providing database management services

Office Automation Software

526 words - 2 pages Microsoft Access appears to provide the easiest and fastest means to displaying data from a SQL server database. The most regular object used to perform data entry is a form. One of the strengths of MS Access is that, by using a wizard to create a form, you can still redesign or customize it however you want. It also has it's limitation typically for managing limited amounts of data. Access is not commonly used for databases hundreds of

Database Comparison of SQL Server 2000, Access, MySQL, DB2, and Oracle

1075 words - 4 pages issues from arising. These databases can be found in client/server applications, as well as applications that utilize internet or intranet pages as a front end. Cost      The cost for the different DBMS varies widely (in fact, from nothing, to millions of dollars). A standalone version of Access (without an upgrade), costs about $339. It is also included with the Office XP Professional and Developer Editions. MySQL is

Department Of Fisheries And Oceans Dealing With IT

635 words - 3 pages most serious problems addressed first. We were told that this list is very long and that there is a substantial wait to get something fixed.· The next issue that they are dealing with is Database Reporting. DFO is a very large organization with several databases full of relevant information. Small Craft Harbors would like to ensure that all information currently being used is consistent with that which the main office has.&middot

Department Of Fisheries And Ocean Dealing With IT/

635 words - 3 pages most serious problems addressed first. We were told that this list is very long and that there is a substantial wait to get something fixed.· The next issue that they are dealing with is Database Reporting. DFO is a very large organization with several databases full of relevant information. Small Craft Harbors would like to ensure that all information currently being used is consistent with that which the main office has.&middot

Managing Information Systems In Organizations

2544 words - 10 pages as computer-aided design, software engineering, and office automation; new research and development in database systems has been necessary. (Cattell 1991) The very nature of these new object oriented databases has caused changes right down to the programming level. As we near the end of this century, designers are now looking at databases that can predict the side effects of medicines, eliminating the need for human trial subjects. Other

Information Security in Mobile Databases

2068 words - 8 pages mobile database really is so this paper tries to explain what mobile database is. The paper begins with explaining why mobile database has gained popularity and what are its features that has attracted so much attention from the business industry. The paper also explains the requirement for a database to be considered a mobile database. The paper also discusses about some of the currently in use mobile databases in the market. it also looks into some

Similar Essays

Analyzing Office Databases Essay

1122 words - 4 pages databases within Karta Technologies; including the database applications used proposing the suggested improvements for such applications. While working in the Accounting and Contracts Department, I had the opportunity to work with the company's integrated database called Deltek."Deltek is the leading provider of enterprise applications software that is built specifically for project-focused businesses" (Deltek, 2008). Deltek is known for providing

Cis 319 Computers And Information Processing Analyzing The Use Of Databases In The Workplace

904 words - 4 pages . Microsoft Access is a database management system from Microsoft, packaged with Office, which combines the Jet relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmer "power users" to build sophisticated "front-ends" to complex databases (http://www.technolopedia.com, 2004). Our Microsoft Access databases are custom built to suit the business needs. Access is a powerful

Organization Databases Essay

843 words - 3 pages not see once logged on the network.My department uses several types of databases; from Microsoft Access to the server-based SQL server. Microsoft Access is a database management system from Microsoft, packaged with Office, which combines the Jet relational database engine with a graphical interface. This combination is intended to make possible for beginner programmers and non-programmer "power users" to build sophisticated "front-ends" to complex

Databases Essay

841 words - 3 pages not see once logged on the network.My department uses several types of databases; from Microsoft Access to the server-based SQL server. Microsoft Access is a database management system from Microsoft, packaged with Office, which combines the Jet relational database engine with a graphical interface. This combination is intended to make possible for beginner programmers and non-programmer "power users" to build sophisticated "front-ends" to complex