Using MS Access/Ms Access Tables order

Advertisement


Question
QUESTION: I would be thankful for any help!

However, Iím a complete beginner. I have data in MS Word Formant and I want it to enter in MS Access Format. I m confused what tables order should be the best. The detail of my data column is as under:
1.Product Name       2. Register Name    3. Register Page No.    4. BillNo.
5. Bill Date         6. Supplier Name    7. Quantity   
8. Product Specification.    9. Price Per Unit    10. Amount.   11. Total Qty.
12. Issued to       13. Room No.       14. Product Disposal       15. Disposal Date
16. Qty Current Balance. 17. Remarks.

ANSWER: For a proper relational database you need several tables. At least a Product table, a supplier table, and Order and Order detail tables. You may also need a Register table (not sure what Register refers to).

If you describe what you app is and what the data represents, I can be more specific.

Hope this Helps,
Scott<>

---------- FOLLOW-UP ----------

QUESTION: thanks sir for ur reply..
i am working at store. Actually i have many stock register like Fixed assets register,stationery register & electric register etc. my data is in ms word format which consists of above mentioned columns and i want to re-enter it in access database format.
my Question is what tables order would suit me? or how can i make my tables?

Answer
Ok, I suggest you get a copy of the Northwinds sample database from Microsoft's site. It will give you a sample of an order entry database.

You need the tables I suggested and a Register table, (still not clear on what that is). I would suggest converting your Word document to an Excel table, then importing that in Access. Use the Table Analyzer and let Access recommend a structure. You will then need to run a series of Append queries to get the data from what you have into normalized tables.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.