Databases are vital for almost every company in today's business world. Databases can help us track inventory, billing, pay roll, and much more. Without the use of databases, work will take longer to accomplish. A database system, such as Microsoft Access, would help increase the productivity of all users on the system. (Chapple, M., 2005)
The need for databases is necessary of running business in my company. The databases we use hold all information about the daily transactions and important customer information. In the IT department, we use several types of databases, from Microsoft Access to off the shelves software. Our Microsoft Access database was custom built to suit the business needs of our company. The databases utilize the Structured Query Language (SQL) Server to run security and transactions. The SQL server provides client computers with highly efficient access to database files (The Structured Query Language, 2005).
My company has many databases that are all connected together in one way or another.
Microsoft Office Access 2007
Microsoft Access
databaseInformation 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 see only what they 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.
The databases we use hold information such as pay roll, schedules, invoices, purchase orders, faxes, e-mails, and much more. Each section of the database has its specific function. If the database did not exist, we would have to revert to paperwork, which would slow down productivity. We would then...