ms access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access 2003

MS Access 2003

resolvedResolved · Low Priority · Version 2003

Leah has attended:
Access Introduction course
Access Intermediate course

MS Access 2003

Are subdatasheets generally referred to as an adequate resource or should this information be displayed via a different medium?

RE: MS Access 2003

Hi Leah, Thank you for your post, in answer to your question; a subdatasheet can be created manually or will be created by Access automatically if the correct relationships are established.
As an adequate resource? In the table format it is a bit unfriendly.
However I would use them in this way; if you are utilising the table which has a subdatasheet as the source for your form or report and use the AutoForm or AutoReport to create it, the subdatasheet will appear as a table on the new object, if this view is sufficient to your needs, then yes, it is an adequate resource, however I prefer to create a form from the subdata, (the other table) and then in my report or form create a sub form/report, this I feel is more user friendly however it depends on your users and how they prefer to view and use the data. I hope that has helped, if so please click the Resolved link, best regards Pete

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


Server loaded in 0.09 secs.