Using Databases – Flashcards
Unlock all answers in this set
Unlock answersquestion
What are the different types of databases and which is the most common?
answer
There are relational, object-oriented, and multidimensional databases. Of these, the relational database is most common.
question
How do I get started on creating a database?
answer
Before creating a database, you need to know the three main components of a database. These include fields, records, and tables.
question
How do I create fields in a database?
answer
Actually, you can create the fields manually by assigned field names.
question
What data type can I use for a field if I have to store a page of text?
answer
You can use memo fields. They are text fields that are used to hold long pieces of text.
question
What else can I store in a field besides text, numeric values, and contents of a calculation?
answer
You can store pictures and video clips using OLE Object fields.
question
Is one table in a database enough to enter all my information in it and store all the fields?
answer
No, you need to create different tables and categorize data to be stored in them.
question
How do I create relationships between tables?
answer
You use primary and foreign key fields to create relationships between tables.
question
But, if I include the primary key of one table in the other table, won't I have two primary keys for a record?
answer
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.
