MS Access 2003

The UK's most regular instructor-led training courses.
Training information: access+courses+in+london · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

MS Access 2003

Leah has attended:
Access Introduction course
Access Intermediate course

by - delegate Leah [2 posts] (2008 Apr 15 Tue, 16:18) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 9 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Jul 16 Wed	Bayswater	6	book now	£195	£205
2007	2008 Jul 25 Fri	Bloomsbury	3	book now	£240	£245
2003/XP	2008 Jul 30 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 6 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Aug 18 Mon	Bayswater	5	book now	£195	£205
Full Schedule: See all 57 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: MS Access 2003

by - trainer Pete platinum contributer [600 posts] (2008 Apr 16 Wed, 07:18) Reply

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

· Why consider Access Visual Basic training?
· Access VBA Training Adds Power to your Databases
· MS Access: Access your Personal Information with Ease
· Access VBA Handling Errors and Debugging Code
· Get More Out of MS Access Courses

Please browse our web site to find out more about
access+courses+in+london and other Microsoft training courses.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips