With a computerized database in Microsoft Access, you can store information as described in the examples, but you can do much more.
For example, if you keep a list of all your business customers in an Access database, you can:
How Access Stores Your DataIn Access, you first need to create a database file. That file holds everything you create for that database — not only all the data, but also the customized forms, reports, and indexes.
If you have two or more businesses, you might want to create two or more separate databases, one for each business.
Access stores each database entry (for example, each employee or each inventory item) in its own row; this is a record. Each record is a collection of information about one thing — in this case, an employee. For example, all the information about Dan Masters, including Name, Surname, Marital status, Salary and Department forms a single record.
Each type of detail is kept in its own column: a field name. For example, Employee ID is one field name and Employee Surname is another. All the Surnames in the entire table are collectively known as the Surname field.
At the intersection of a field name column and a record row is one individual piece of information for that particular record; this area is called a cell. For example, in the cell where the Department column and the Dan Masters record intersect, you’ll find Marketing, Dan’s Department.
You’ll learn how to create these tables. Each database file can have many tables. For instance, you might have one table that lists all your customers and another table that lists information about the products you sell. A third table might keep track of your salespeople and their performance.
Access links the form to the table and stores the information that you put into the form in the table. For instance, Access stores the employee data I'm entering on this form in the previous table.
You can think of it as a sifter you dump you data into; the data you don't want fall through the holes in the sift leaving only the data you're interested in.
Many people are afraid of queries because of the technical terms associated with them, such as values, criteria, and masks. But there’s no need to be worried, as you will learn when you create and use a simple query.
As mentioned earlier, tables are the central focus of all activities — all the other objects do something to, or with the table data.
Reports summarize and organize the table data. Forms help you enter information into the table, queries help you find information you want to use in the table.
Access XP Topics- Screen layout
- Storing data
- Database planning
- Tips for tables
- Tips for forms
- Tips for reports