| Databases - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Exercise 1 Exercise 2 | |
 |
Community Learning Homepage |
|
<< PREVIOUS 1 - What is a database? NEXT >> A database is a collection of information that's related to a particular subject or purpose, such as tracking Company orders and or maintaining a list of staff or customers.
The first step in designing a database is to determine its purpose and how it's to be used: Talk to people who will use the database. Brainstorm about the questions you and they would like the database to answer. As you determine the purpose of your database, a list of information you want from the database will begin to emerge. From that, you can determine what facts you need to store in the database and what subject each fact belongs to. For example, a subject might be Customers and the following facts about your customers would be things like company name, address, city, and phone number. All the Facts about your Customers are stored in a table made up of rows and columns. Each row contains a complete (Record) about a customer and each column (Field) stores the facts. You can have as many tables as you want in a single database for example, as well as a customer table, you may need a Staff table, your company Products table and an Sales Order table. Using Microsoft Access, you can manage all your information from a single database file. Within the file, you can use:
• Tables to store your data. |
|
