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

ms access

ResolvedVersion 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

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.