How Access Works

Microsoft Access is intended primarily to enhance the society, business economist, companies and other enterprises on the basis of filing and sorting of data. The access database is a single file that is sub-divided into tables, queries, forms, reports, macros and modules. Access functions only when there is an existing file either in your floppy or in the systems. The power of Access (and indeed, any relational database application) is the power and functionality to be able to relate information in multiples tables. This is done by defining relationships between tables either by using a one-to-many or many-to many relationships but a one-to-many relationship is the most common type. To create a database for the company, it would be necessary to create tables to hold information about the separate subjects. Thus, for the situation, one table each would be required for the employee, customer, supplier and product. Data can then be entered into the tables for the different entities. for example, the employee table would have such fields as the employee ID number, name, designation, department and so on. in a like manner, the customer table may have fields like the customer ID number which like the employee ID, would be a unique identifies for each customer, contact address and the like consider the fictitious ordering company, XYZ products and marketing company. Assuring a customer desires to need to engage an employee of the company in making the order, most probably the sales persons. The order in itself may comprise several products that the company has and the order may consist of more than one order item.

After this information has entered, a way to instruct access to bring back together the information it has stored together again is needed.