This is the start of your Task 05. Start to create these tables now and we will use them during the next class when we add relationships to them. You will turn in the tables and their relationships by Wednesday, 04 April, so I can be sure you have a solid baseline for the remainder of task 05.
When you are ready, start to design the tables you want to use in your database. You will have specific guidance about what these tables should look like so start to design them, concentrating on design and formats. Do not spend too much time populating the tables with data at this time though you may wish to enter some sample data in table fields to see if the formatting you have selected is appropriate for the data you wish to use.
[top]
You will have at least these four tables in your database, so you can use the example above as a start and construct the four tables, to include the listed fields (at least these fields, you may desire or need additional fields). Consider how each of the fields should be described in the design view.
If the import tool doesn't do it for you, ensure that these fields are in your tables and that the field properties are correct. If the import tool adds data fields to your tables that are not included in the list below, you may use them or delete them. But be sure to include at least these data fields.
In the import process, you will be asked if you want to allow the Wizard to create a Primary Key for you. Say no and choose the most sensible field in each worksheet to act as the primary key (it should be obvious which one to use).
You have one table that you will have to create from scratch using your choice of table creation tools. Concentrate on setting up the table design correctly. You will not be adding live data to this table until next week.
[top]
In all these tables, you will be adding data fields at a later date as you construct relationships between the tables. For today, however, concentrate on creating the tables.
[top]