Search Button on Navation Form (1 Viewer)

[michaeljryan78]

Here is a start. This may give you some ideas. I used your names for the spotlight questions, but I suggest renaming the fields to something without spaces and special charactors. you decide.

 

[michaeljryan78]

This link about normalization could help with the restructuring:

http://msdn.microsoft.com/en-us/library/office/aa139981(v=office.10).aspx

 

[SarahBeth]

Now I am having trouble making in the CRAFT information table making Student ID as a prime key. I have take away navigation table. Have add Student ID to CRAFT information.

 

[michaeljryan78]

I created a student table and joined it to the Craft table. Did you look at the normalization article? Attached is the update. I would also look up relationships in help to guide you in the database design.

When looking at the tables, ask yourself, "is the data in the Students table ONLY information that directly applies to STUDENTS?" If not, then the data belongs in another table and related back to the student.

 

[SarahBeth]

I created a student table and joined it to the Craft table. Did you look at the normalization article? Attached is the update. I would also look up relationships in help to guide you in the database design.

When looking at the tables, ask yourself, "is the data in the Students table ONLY information that directly applies to STUDENTS?" If not, then the data belongs in another table and related back to the student.

Yes, I did look at the Normalization article. All of the information in this database would directly applies to Student because it is Student Worker Database.

 

[michaeljryan78]

Look at this articel about INF (First Normal Form)

http://en.wikipedia.org/wiki/First_normal_form

 

[Mihail]

Mihail: here is the structure. Looks like there may need to be a bit of an overhaul with normailization

Thank you for pic but looks like a spider web.
If you can save the database for A2007.

 

[SarahBeth]

Thank you for pic but looks like a spider web.
If you can save the database for A2007.

I cannot save this database as A2007. I have try to save as A2007, I have too much stuff that is not in A2007.