Posts

Exporting Tables, Queries, Forms and Reports to web pages

Image
Objective: Exporting Tables, Queries, Forms and Reports to Web Pages using simplest steps in MS Access    MS Access allows users to built a powerful integrated platforms of inserting, saving, retrieving the information into the database. There are many platforms for these facilities in MS Access for example  Tables ,  Quires ,  Forms ,  Reports , etc.    In previous posts we have learnt how to create the  Tables ,  Quires ,  Forms  and  Reports , etc. But if we want to open the data into another application then it provides  a way to do the same. We can export the table, queries, etc. into another format such as XML, web pages.    In this tutorial, you will come to know how to export the tables or queries into the web page format which allow you to open the table in web browsers.   If you don't know how to create the data tables, queries, and reports then please  read those articles  before it. We just follow some easy steps to do the same as follow: Procedure: 1. Open a database

Exporting Tables, Queries, Forms and Reports to XML pages

Image
Objective: Exporting Tables, Queries, Forms and Reports to XML Pages using simplest steps in MS Access     Tables , Quires , Forms and Reports generation in the features supported by the MS Access in order to influence more convenience and beneficial data insertion and retrieving to the database. It is used in many professional, social and professional works and Also in many companies to manipulate the data.    It is important to backup some date  or to export  these data. In today's tutorial you will come to know about how to export the table. queries and reports in the XML format.     If you don't know how to create the data tables, queries, and reports then please read those articles before it. Procedure: 1. Open a database table that is created previously or create a new database table. 2. Go to the External Data ribbon and click on  XML File from the Export group. 3. Now Click on browse to specify the destination of the XML file where you want to save it in your comp

Concept of Information Systems and Software

Concept of Information Systems and Software : Information gathering, requirement and feasibility analysis, data flow diagrams, process specifications, input/output design, process life cycle, planning and managing the project. Information Gathering Information Gathering Strategies The strategy consists of identifying information sources, evolving a method of obtaining information from the identified sources and using an information flow model of organization. Information Sources The main sources of information are users of the system, forms and documents used in the organization, procedure manuals, rule books etc, reports used by the organization and existing computer programs(If Any). Feasibility Analysis Feasibility analysis is used to assess the strengths and weaknesses of a proposed project and give directions of activities that shall improve a project and achieve desired results. Requirements Determination Sub-activities : Requirements Anticipation. The systems analyst hypothesiz

Creating and working with queries in MS Access

Image
Objective: Creating and working with queries in MS Access Introduction    A query is a request for data results, for action on data, or for both. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data. Queries that you use to retrieve data from a table or to make calculations are called select queries. Queries that add, change, or delete data are called action queries.   You can also use a query to supply data for a form or report. In a well-designed database, the data that you want to present by using a form or report is often located in several different tables. By using a query, you can assemble the data that you want to use before you design your form or report. Creating a Query Open the database that you previously set up by using these steps . If not, then create a database. We are having a previously created database here.  On the Create tab, in the Queries group, click Query

Drug information storage and retrieval using MS Access

Image
Drug information storage and retrieval using MS Access      The storage, retrieval, and dissemination of information constitutes a major function of any drug information service (DIS). We developed a computerized system for the storage and retrieval of data from drug information requests (DIR) using a MUMPS-based information system. In the past, DIR forms were stored in looseleaf binders and filed chronologically. Due to the success and increased use of our DIS, this manual filing system became inadequate and awkward to use. Our solution was to develop a computer system where data could be entered from DIR forms and retrieved rapidly and easily. Each DIR was reviewed and key data elements were selected for input. The DIS files may now be searched online rapidly and efficiently. The MUMPS-based information system has provided open access for all staff pharmacists, 24 hours a day. The benefits have been an increase in both the quantity and quality of drug information provided.    Here, w

Introduction to database: MYSQL, MS ACCESS, Pharmacy Drug Database

Image
    Database refers to a collection of electronic records that could be processed to produce useful information. A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques. The data can be accessed, modified, managed, controlled and organized to perform various data-processing operations.      The data is typically indexed across rows, columns and tables that make workload processing and data querying efficient. There are different types of databases: Object-oriented, Relational, Distributed, Hierarchical, Network and others. In enterprise applications, databases involve mission-critical, security-sensitive and compliance-focused record items that have complicated logical relationships with other datasets and grow exponentially over time as the userbase increases. As a result, these organizations require technology solutions to m

Introduction to Web servers & Server Products

Image
Overview Web server  is a computer where the web content is stored. Basically web server is used to host the web sites but there exists other web servers also such as gaming, storage, FTP, email etc. Web site is collection of web pages whileweb server is a software that respond to the request for web resources. Web Server Working Web server respond to the client request in either of the following two ways: Sending the file to the client associated with the requested URL. Generating response by invoking a script and communicating with database Key Points When client sends request for a web page, the web server search for the requested page if requested page is found then it will send it to client with an HTTP response. If the requested web page is not found, web server will the send an  HTTP response:Error 404 Not found. If client has requested for some other resources then the web server will contact to the application server and data store to construct the HTTP response. Architecture