Using Databases

How do I create fields in a database?

Actually, you can create the fields manually by assigned field names.

What are the different types of databases and which is the most common?

There are relational, object-oriented, and multidimensional databases. Of these, the relational database is most common.

How do I create relationships between tables?

You use primary and foreign key fields to create relationships between tables.

How do I get started on creating a database?

Before creating a database, you need to know the three main components of a database. These include fields, records, and tables.

Is one table in a database enough to enter all my information in it and store all the fields?

No, you need to create different tables and categorize data to be stored in them.

But, if I include the primary key of one table in the other table, won't I have two primary keys for a record?

When the primary key of one table is included in another table to establish a relationship between the two tables, it is called a foreign key in the related table.

What else can I store in a field besides text, numeric values, and contents of a calculation?

You can store pictures and video clips using OLE Object fields.

What data type can I use for a field if I have to store a page of text?

You can use memo fields. They are text fields that are used to hold long pieces of text.