Hi

[rizzy]

Hello everyone. I am new to this forum and haven't use any kind of forums before. I am a beginner in Access and need some help in the designing stage. I am currently working on flat file database and need to import the existing database in Access.i am currently using 2010 version of microsoft . I am stuck on few points and need some help from people who are expert in this field . i will really appreciate any feed back. thankyou

[June7]

Welcome. Post specific questions for issues you encounter.

Maybe this site (one of many) will help with design. http://www.rogersaccesslibrary.com/

Breaking up the flat file to normalized structure can be a tedious, painstaking exercise. Just be careful.

[rizzy]

hello thankyou for your reply. I am currently studying in Bsc computer science . i have a flat file database which i have normalized. the problem is that i have no one to help or guide. i am working first time on access . i have previously worked on my sql. i have all the different tables ready to import which are normalised but need to know if i am doing everything right. i hope this helps

[June7]

Happy to help but you did not ask specific question.

If you truly have a normalized structure, that is step in right direction. But unless you provide something to analyse, that's all we can say.

[rizzy]

thankyou once again.i can send you all the field names of the data and can add explaination in it that what records are held in the database. i am currently working for a company but its placement . i am sure its confidential data . i think that telling yourselves column headings and explaining that which table is doing what would not harm any one. e.g i have customer details in which i have one customer but multiple addresses given in flat file. i have broken the data down by creating further fields for city postcode. the problem i faced was that i have one customer and multiple addresses. my approach was to create one table with customeid(pk) and customername and have a separte table with multiple attributes with a copy of customerid(fk) from the first table. i hope this makes sense and could you please tell me in which way you want me to send the data. i will be appreciate on your feedback

[June7]

That does sound reasonable.

See the instructions in signature area at bottom of my posts.

[rizzy]

hi it's me again. i am really sorry and don't know what you mean by signature area . could you help me with where it is as all i can see under your post is

To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!
Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm
i hope this helps.

[June7]

That's it. If you want to provide files, follow instructions is the first line.

[rizzy]

what you think is the best way for you to observe the data. the flat file consists of 100 columns/fields .would you want me to send you the column headers in the file or let me know which way

[June7]

Do you want your db design evaluated? Provide db or diagram.

If you want the flat file reviewed, provide Excel or import records into a big flat table.

[rizzy]

ok thankyou for the reply, i will send you the file over the weekend if thats ok with you. thanks for the help once again.

[rizzy]

june 7 how are you . i have attached database . it has only few records asa i have about 2000 records in the database. i would really appreciated if you could have a look and if you have any questions please don't hesitate to ask me. just to let yourself know that the different section where i put arrows all the data is in one flat file and it starts from schedule, workorder, and so on it is all linked so when you see the arrows it's just to let yourself know that this is where different section of data starts . any question please let me know

[ssanfu]

I only see the Excel file; the dB wasn't included in the zip file.
Were you going to include the dB?

[June7]

Is this manufacturing data? One of the more difficult type of databases to build. Has been topic of numerous threads. Search forum.

[rizzy]

the excel file is the current version given to me and i have to change this into access database.this reply for ssanfu