|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 2nd, 2006, 02:13 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Scheduling
I am running access 2000 and I need to create an Access database that would
allow me to do the following: Have the title of the book and author A blurb about the book The Teacher overseeing it And the students that are going to read it. I then need to be able to create reports of the students and the books they are reading. I need a database that is similar to the one microsoft has on their website. (I can't use it because I don't have Access 2003.) Any suggestions on how to create this database? Many, Many Thanks! 
|
|
#2
March 2nd, 2006, 09:47 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Scheduling
create 3 tables
books: book-id author title blurb teacher-id people: people-id first name last name student or teacher reading: book-id people-id first-date end-date relate the tables create queries/forms to edit the tables. create query/report on the related data you require to see suc^6 Nne "Mike K." schreef in bericht ... I am running access 2000 and I need to create an Access database that would allow me to do the following: Have the title of the book and author A blurb about the book The Teacher overseeing it And the students that are going to read it. I then need to be able to create reports of the students and the books they are reading. I need a database that is similar to the one microsoft has on their website. (I can't use it because I don't have Access 2003.) Any suggestions on how to create this database? Many, Many Thanks!
|
|
#3
March 2nd, 2006, 07:00 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Scheduling
Thank you for the information. To be honest, my access knowledge is basic.
If you could be so kind as to give me just a few steps as to how I go about doing the table, I would apperciate it. Thank you so much. "nanne" wrote: create 3 tables books: book-id author title blurb teacher-id people: people-id first name last name student or teacher reading: book-id people-id first-date end-date relate the tables create queries/forms to edit the tables. create query/report on the related data you require to see suc^6 Nne "Mike K." schreef in bericht ... I am running access 2000 and I need to create an Access database that would allow me to do the following: Have the title of the book and author A blurb about the book The Teacher overseeing it And the students that are going to read it. I then need to be able to create reports of the students and the books they are reading. I need a database that is similar to the one microsoft has on their website. (I can't use it because I don't have Access 2003.) Any suggestions on how to create this database? Many, Many Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Simplifying room scheduling | MPD352 | Calendar | 3 | October 11th, 2005 11:42 PM |
| How can I make scheduling classrooms easier? | dna_atg | General Discussions | 1 | September 21st, 2005 05:42 AM |
| resource scheduling & auto accept | Ted | Calendar | 0 | September 1st, 2005 07:08 PM |
| Resource scheduling | corpach | Calendar | 5 | December 22nd, 2004 05:01 PM |
| See different time zone in scheduling tab | Lauren | Calendar | 1 | June 8th, 2004 03:31 AM |
Linear Mode
