Good Sunday evening all, I am a brand new member as well as a new user of Access. My dear wife and I are starting a Real Estate School that will accomodate between 5 and 40 students. As I've started read a book re: Access, I discovered that I was way off regarding how to construct a database that will work for us. While I am very excited about learning how to build a strong database, it takes more than a strong desire to learn Access. So, when I was blessed to discover this forum, I am certain someone here can help guide me. I am using Access 2007. I will list all the elements I plan to use below:
LastName
MiddleName
FirstName
address
city
state
zipcode
HomePhone
mobilephone
emailaddress
company where realtor works
coursedate
coursetime
coursenumber
courseCEhours
studentscore
studentcomplete (did student complete the course?)
studentscore
studentpayment
howpaid
notes
customerID
My questions are, how should I divide these catagories up so all will work correctly? Should I have separate tables and what should go in each table? How can I and my wife access this information from our different computers? I do hope I've asked all of the questions I needed to. Thank you for your responses.