How Access Works

by Sharon White - Date: 2007-01-19 - Word Count: 296 Share This!

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.

Source: Free Articles from ArticlesFactory.com

Related Tags: how, access, works

The article was produced by the writing expert of masterpapers.Get perfect Samples of various Essays and Custom Papers. Your Article Search Directory : Find in Articles

© The article above is copyrighted by it's author. You're allowed to distribute this work according to the Creative Commons Attribution-NoDerivs license.

Recent articles in this category:

How Hypnotherapy Can be Used on Children by Gemma Bailey
Today Hypnosis can be termed as a branch of medicine which is quite unique, whereas in the past this
Confidence Workshops For Children by Gemma Bailey
Every parent wants their children to be confident, happy, highly motivated and enthusiastic in order
Inspiring Children Using NLP by Gemma Bailey
Neuro-Linguistic Programming (NLP) is one of the most successful therapies in psychology today. Init
Writing Term Papers by Brain Haley
Students often tend to put off a written assignment, considering it to be a chore too formidable to
Naming In Term Paper by Eric Mosby
Give a descriptive name to each of your concept in the paper. Adhere using terms like "our approach"
Introduction Section of a Research Paper by Eric Mosby
Your introductions should not exceed more than two pages (typed, double spaced). See again the examp
Getting a Feedback of Your Term Paper is Important! by Eric Mosby
Get the feedback of your work! Finish your paper, having written it well in advance, so that you hav
The 1950's - Was Life Better? by Christopher P Clark
Iconic TV shows like I Love Lucy, Dennis the Menace and My Three Sons seem to indicate that the 1950
Online Classroom Systems Makes Home Schooling Even More Attractive by Craig Lawson
In the past it went without saying that you would send your kids to public schools. With public scho
8 Helpful Tips For Surviving Military Basic Training by Danica Reynes
Getting through military basic training takes a lot perseverance. During this training it is best to

Most viewed articles in this category:

Culinary Cooking Schools and What They Teach by Andy West
Culinary cooking schools prepare you for a job in the culinary industry by providing you with the kn
How To Learn Spanish Quickly Without Moving To Spain by Gray Rollins
Learning Spanish is a popular pastime, as well as a serious goal for many individuals. Whether it's
How To Improve Your Life With An Accredited Online College Degree by Andy West
With the information super highway raring full steam ahead, quality accredited online college degree
Online Bachelor Degree Programs Go Mainstream by Andy West
The Internet has seen an explosion in online bachelor degree programs in the last five to ten years
Online Degree Program Just A Click Away by Andy West
You want to go shopping, but your car is low on gas. You want to know your account balance, but do n
Online Paralegal Degree Will Open Doors by Andy West
An online paralegal degree may offer the possibility of improving your chances in the legal professi
What West Point Military School Looks For In A Candidate by Victor Epand
West Point is looking for well rounded young men and women who are good students, good athletes, and
The Importance of Effective Accounting Programs by Morgan Hamilton
In the past, small businesses like mom and pop stores were not required to maintain any sort of acco
California Schools Educators Retirement System And Lionstone Group Create Investment Fund by Patricia Hawke
The California State Teachers' Retirement System (CSTRS) is the second largest public pension fund i
A Taste of China - Seattle Schools New Guest Teacher Shares Language and Culture of Her Native Hom by Jason Thomas
The Seattle schools have a new "guest" teacher. Zhu Dan arrived in the Seattle schools in January