Need help with data entry using Access!

[mathersi52]

Hello everyone,

This forum looks really great and helpful.. I have been looking for answers but I think i need my own thread to get the help I need. Basically my goal is to have a database for a school system ( not including students ). this database will include semesters, instructor information, course names, departments... fairly simple right?


HERES THE PROBLEM...

I am trying to make a form to enter new info into my database. I am able to make a query to return info i want like instructor name, what they teach, what semester etc...

but i cant figure out how to make a form to add new data

I attached my database and a copy of two forms.. one called Attempt1 and another called Attempt2

Thanks alot everyone for participating .. please excuse my noobyness i have not worked with access in a very long time and want to get back into it slowly

 

[mathersi52]

I know what I want to achieve is accomplishable, I am just missing a few key steps. Hope we can go through my problems together and make this a learning experience... this is a very basic database I am aware so dont hate on me for not knowing !

 

[mathersi52]

I want to be able to have a form where i can say..

Scroll through a ilst of my instructors and show what they teach... also ability to add a new course to their teaching list.

Thanks sorry for confusing posts

 

[mathersi52]

I made a form where It shows everything but for some reason I cannot properly update the CourseInstructor table I have made.

 

[vinz4ever]

Right, we need to concentrate on one area at a time.

Can you please tell me your first query in detail and i will see where i can assist.

I made a form where It shows everything but for some reason I cannot properly update the CourseInstructor table I have made.