An easy one : How would you make this in access ?

[plenderj]

I'm doing some study for an access exam, and one question that was asked last year as to make an access database from some given data.

I was just wondering though that it would look like in access itself.
Its question one I'm working on, and the source data is at the bottom of the document.

Now I've no problem with the stuff up to services, but then how do you deal with 2 or 3 lines per record then after that ?

[chenko]

****ing acrobat wont open my pdfs

more than one line per record :/

just the normal Enter char you on about? press ^{Enter}

[plenderj]

I'll take screengrabs for you

[plenderj]

Okay.

Original Data is the original data as given in the pdf file.
Screengrab from access is where I've gotten to in designing the table, but I'm not sure what to put in next ...

[Ecniv]

Now I've no problem with the stuff up to services, but then how do you deal with 2 or 3 lines per record then after that ?

Ok, there are several ways.

1 - memo field - text box with the scroll bars active
2 - List box and a separate table with its own IDs plus a foreign key id to the main table of info - pop up form to add new ?
3 - List box and a separate table with the ID and foreign key as the key

...and more probably

Separate the data into groups that are related, store as tables with id keys and link. See Normalization.

Regards

Vince

[plenderj]

Originally posted by Ecniv

Separate the data into groups that are related, store as tables with id keys and link. See Normalization.

This is probably how we're supposed to do it.
Cheers, I'll have a look at it now

[plenderj]

jesus christ this is taking a long time to type in

[plenderj]

Ecniv, I sent you a private message but I don't know if you've received it yet.
Anyway yeah I think access has made a dog's dinner of the database.

Any chance of giving me a hand ?