This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CREATING A DATABASE 1. Assignment: Create a database for any company that interests you. The database should have two tables, one form, 5 records, one query, and a report on that query. There should also be one relationship. Show your recitation leader when it is complete. Use the following example and instructions as a guide: 2. Let’s say I work at Blockbuster and I want to create a database that includes information about customers but also information about my inventory of movies. a. I want to create two tables and each table needs to have a primary key (i.e., the “unique identifier). There will be a CUSTOMER table and a MOVIE table. b. I want to create a relationship between my customer and movie tables by using a movie ID #. Basically, in the customer table, I want to have information about what movies each customer has rented. By putting the “Movie ID #” in the customer table as a foreign key (but as a primary key in the movie table), I can create a relationship so that when I search on a customer it not only provides the movie ID # but is also linked to more information about that movie from the movie table. (see instructions for creating tables) 3. I want to use the “relationships” feature in Access to link my customer table to my movie table. I basically want the “movie ID #” field (foreign key) in my CUSTOMER table to be linked to my “movie ID #” field (primary key) of my MOVIE table. This allows me to have separate pools of information for customers and movies but also gives me the option to get information from both tables if needed. (see instructions for creating relationships) 4. I also want to make sure I have an easy way for my Blockbuster employees to enter information into my tables. For example, when I get new customers and/or new movies in my inventory, I want my employees to be able to easily enter the needed information into my database. To do this, you want to create a FORM for each table. (see instructions for creating forms) 5. Once my database has information about customers and/or movies, I can create a report to get any kind of information I need from that database. A report allows you to create an organized, simple display of only the information you want from your database. For example, I can create a report of all movies in my inventory or a report of all customers. (see instructions for creating reports) 6. In some cases I want a report of more specific, tailored information such as...
View Full Document
- Spring '08
- Foreign key, Double click, Matt Damon