Database Basics - Plan and Create Your Tables
Complete the On-line lesson - Design Tables for a New Access 2007 Database
Answer the following questions as you read through the lessons. All answers need to be in your own words, do NOT cut and paste your answers.
- What is the name of a row in a database?
- In Microsoft Access what is a field? (this definition is not consistent with other databases)
- What is the purpose of dividing data into subject-based tables?
- Copy down the third bullet point under "A good database design..." This is one major goal of a database.
- What is a primary key?
- Jump down to the Dividing the information into tables. Look at the four tables they came up with for a product sales database. Now think about School Loop. List some of the tables that this (the School Loop database) would contain (list at least 4)
Complete the On-line lesson - Create Tables for a New Access 2007 Database
Answer the following questions as you read through the lessons. All answers need to be in your own words, do NOT cut and paste your answers.
- What is a table relationship?
- What are the two types of keys and what is the function of each?
- What icon denotes a primary key in a table?
- What are the benefits of using relationships?
- The Practice Session is no longer available so go to Lynda.com and watch the Access 2007 Essential Training with David Rivers - watch the Creating Tables, Creating Fields and Working with Records and Working with data. As you watch the video follow the steps. Add several music titles of your own to the table and then show your completed table to your instructor for teacher check. Save the table in your Access folder in your home drive.
Congratulations on creating your first database tables.
- List three tables you would expect to find in the Infinite Campus database.
- Choose one of these tables and list at least three fields you would expect to find in that table.
- What would be the primary key in that table?