Queries and Forms

[greeneyerat]

Hello,

I am a new to MS Access and wanted to know the following:

1. My tables have been completed, and I need to know what needs to be done 1st, the Queries or Forms?

2. Also, if the Queries are done first, for each of the Queries do I need to create a form replicating the Queries functions?

Thanks,
JM

 

[Trendsetter]

If your now make your queries you can base the construction of each form on the relevant query.
Example:
If you make a query that lists all the customer details then the form will have all of the details from the query and will be in the order selected by the query.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[greeneyerat]

Ok,

So once I create a query, then I create the form. The fields used to build the from would be brougth in from the query or I extract them from the table?

Thanks again,
JM

 

[Trendsetter]

Use the query to build your forms.
This way you can combine any number of tables and manipulate the data in many different ways.
With the table you are stuck with the existing format and content.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[greeneyerat]

Thanks for your feedback! It's greatly appreciated.
Javier.