Adding records

[orange]

srin,

Have you worked through any of the tutorials from rogersaccesslibrary?


Here are a few that will help you with table identification and design,keys and relationships.
You have to work through them but you will learn. And, what you learn can be applied to any database.

ER Diagramming
Class Info and Hernandez 12 Steps
CaterIt Business

[Srin]

Hi @orange,

I have been going through the records and following the steps mentioned in the links provided to sit down with the team and preparing the Entity Relationship Diagram (ERD) for our database. The next steps would be to start the database on Access after we are clear with what information we need stored and maintained periodically.

Also we need to decide on an approach to input the data dump that is generated periodically.

Thanks for all your input. This has been a learning experience that I am enjoying.

[orange]

Glad you're finding it a learning experience--that's the intent.

See this post and the link mentioned re stump the model to get some additional info.
Good luck.