Using MS Access/Ms Access Tables order


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,

---------- 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?

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,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers

Answers by Expert:

Ask Experts




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


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

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

Brooklyn College BA

©2016 All rights reserved.