|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I'm doing a masters at uni and have to make a notice board for a virtual learning environment using access, sql, asp, or whatever and i've never done any database stuff before and dont know what to do next!
i have a basic database- just a few tables and a few relationship diagrams etc but what do i do next? i probably sound really dumb now but i am blonde so!!! jenny |
|
#2
|
||||
|
||||
|
first create the database structure...What tables will be needed...what fields within these tables...what relationships, etc...
Then just break the enitre application down to simple steps... Are you requiring a login page? if so, then design that first...etc... Create a picture of how the system will work and then just start from the beginning. |
|
#3
|
|||
|
|||
|
thanks but i'm even more dumb than that! i dont know how to actually do any of it, i can plan it, and design it on paper, but i just get lost after that. i need it by january as well, which doesnt leave me much time! i could do with someone talking me through step by step really but i know that would take ages, am just clinging to my last few shreds of hope that some miracle will happen. but thanks for replying darlin, if i wasnt so dumb it would have been helpful!
getting stressed, jenny |
|
#4
|
||||
|
||||
|
First of all, you need to determine what data should be stored in your database. If you have this on papaer then try to organize them into data tables. Then, create a new Access database and create your tables and create relationships between tables.
Relationship means, for example: Let's say you need to build a database about people and their phone numbers. One person can have more than one phone number so you need to store the phone numbers in a different table. So you create a table for the persons...: Table name: tblPerson Fields: PersonID (type: AutoNumber) - this is an identification number that makes the record unique. This field will be the Primary Key. You can't use the person's name as an identifier beacuse you can have more person with the same name. FirstName (type: text, length: 50) LastName (type: text, length: 50) ...And create a table for the phone numbers belonging to the persons: Table name: tblPhoneNumber PhoneNumberID (type: AutoNumber) - Primary Key PersonID (type: Long) - This will tell you which record in tblPerson table is the 'parent' record of the PhoneNumer record. This called 'Foreign Key'. PhoneNumber (type: text, length: 50) Then, you create the relationship between the two tables by linking them on PersonID field. This is called one-to-many relationship. The advantage of the one-to-many relationship is that you don't need to repeat a person record when you need to assign a new phone number to it. The example above is a very simple one, but to create your own database you absolutely need to understand the concept of a relational database. So if you're starting from the zero point, I recommend to seek for books about that.
__________________
BRegs, TBÁrpi "I can only show you the door. You're the one who has to walk through it." |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > I'm a newby to all this! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|