Entry of data from initial stages.

Hello Winter,

Hope you enjoyed your Microsoft Access Intermediate course with Best STL.

Thank you for your question regarding data entry into a newly created database.

I don't know the structure of your database i.e. how many tables? what are the table relationships? ...so, I am going to assume that you have a few tables with one-to-many relationships. A table with the primary key is the 'parent' table and must be populated first with data before entering data into the 'child' table where the foreign key is located.

Data may be input directly into the table itself or through a form if you have created this already.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Hi Winter,

Thank you for your question and welcome to the forum.

You create the tables in Design view with the fields, data types and their properties. Then you link all the tables.

Once the database has been established and all your tables have been created, you can enter the data directly into the table in DataSheet view.

Alternatively, you can use the form wizard to create a form based on the relevant table. Then you can enter the data directly into each field using the Tab key.

I hope this answers your questions.

Regards

Simon