|Access||Adobe photoshop||Algoritmi||Autocad||Baze de date||C||C sharp|
|Calculatoare||Corel draw||Dot net||Excel||Fox pro||Frontpage||Hardware|
|Php||Power point||Retele calculatoare||Sql||Tutorials||Webdesign||Windows|
|Asp||Autocad||C||Dot net||Excel||Fox pro||Html||Java|
A database is a collection of data that is organized using a consistent structure. An address book is a database, for example. You have entries for many different people, but you collect the same information about each person: name, address, phone number, and so on.
In a database, each type of information, like ZIP Code, is a field. The complete entry for a certain person is a record. When you put a database in Excel, the field names appear in the top row and all records appear beneath them, as shown in Figure 6-1.
Figure 6-1: A simple database in Excel.
If you're going to use your data in some other program, such as a source for a mail merge in Word, make sure you put the field names in row 1. Don't leave blank lines at the top. Otherwise, the program could get confused when importing your data.
Excel's database capability is limited to the creation of simple flat-file databases. A flat-file database consists of a single, two-dimensional table, like the one in Figure 6-1. If you need a multitable database where the tables are joined together (that is, a relational database), look at a program like Microsoft Access instead.
To start your database, simply enter some field names in row 1. You may want to format them in a special way, as in Figure 6-1, to help you keep that row separated from the data rows that will follow.
As you're figuring out what field names to use, keep these rules in mind:
Ready to create the database? Start typing into the cells.
Politica de confidentialitate | Termeni si conditii de utilizare|