The management of data in any organization is of critical importance. Hence the knowledge of how computers store information and how to access it quickly has become a performance hallmark.
The role played by databases should be highly appreciated because they allow organizations to create management information system that supports their operational, tactical and strategic decision-making. Databases are used to analyze management information for effectiveness and efficiency. Microsoft access allows creation of records from which data forms and reports can be derived for managerial and other uses.The Microsoft access has Office Web Components, which provide a set of tools that can be used to include interactive Table lists, spreadsheets, and charts on Web pages. (Amber, Sadalage, 2006). Each component has features and capabilities that suit it to particular uses.
This paper provides some analysis to determine whether tables, list, spreadsheet, or charts are optimal choice for the tasks users are expected to perform within Web pages in organizations and possible improvements. The access allows the user interface to display information from databases using tables.According to Amber and Sadalage, these tables give lists when one want to provide information from a database such as Microsoft Access or SQL Server records or OLAP data from a Microsoft SQL Server. OLAP Services database is usually in a form that users can interact with and analyze databases from within the Web browser or in a run-time environment.
Some government departments require optimal amount of security to be ensured for example the finance department. Users ought to be provided with an interface, which allows limited amount of control for example viewing and analyzing, but not updating, data.Users of a PivotTable list cannot update or change the underlying source data in any way in the browser. They use a PivotTable list for needs to enter changes to the data, to perform their own calculations, to view and analyze existing data.
Examples of such situations are, from Microsoft Access, one needs a PivotTable list to publish cross tab-style data on a Web page. Secondly, a good applications for PivotTable lists is one that make a database of sales figures available to users who want to compare sales for different products and regions.Thirdly the tables publishing stock price figures from a database that's updated frequently so that users can view and compare the performance of stocks that interest them. Lastly is one that provides a product catalogs that customers can filter to find the products they want and view the price, availability, and shipping cost information. If users will need to enter changes to the data or enter formulas to calculate values, an interactive spreadsheet on the Web page instead of a PivotTable list is used.
For example, a loan payment calculator, where users can enter an amount to be financed and change the interest rate calculations, would be a better application for a spreadsheet than for a PivotTable list. You cannot access database data from a spreadsheet, however, in the ways in which you can from a PivotTable list. (Amber, Sadalage, 2006) Some design programs allows for Web page control that can be used to access and update records in a database. Microsoft Access, for example, provides database controls, available in data access page design view that one can use for data entry tasks.
If users will view data without interacting with it, a non-interactive table might be a simpler way to display static data. A PivotTable list is an interactive table that one can use to analyze data dynamically from within the Web browser. It is possible to use a PivotTable list to view and organize data from lists or databases, look for information or details, and create personalized summaries and reports. However, it is impossible to add, edit, or delete the data values that are displayed in a PivotTable list.A simple PivotTable list displays a summary of data from a database. When creating a PivotTable list, a selection of data from an external database or other source to be made available to viewers on your Web page is made.
This data becomes the source data in the PivotTable list. It can set up an initial presentation or view of the data, such as the summary that analyzes the data in one of the many possible ways. A simple PivotTable list presents a table of records from a database as a set of detail fields.Conclusion We can view a Database Management System (DBMS) as a software and hardware system for managing databases.
A typical database management system consist of data stored in tables, data dictionaries or metadata that describes the structure and content of each database, indices and application metadata (structure and format of reports, queries, and forms). A good DBMS ought to allow for dynamic update by users and full security of information as per requirement.
