2003 access micorosft training - data sheet
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » 2003 access micorosft training - Data Sheet

2003 access micorosft training - Data Sheet

resolvedResolved · Low Priority · Version Standard

replyReply Tue 6 Nov 2007, 16:52Delegate Roz said...

Roz has attended:
Access Intermediate course
Access Introduction course

Data Sheet

How do you enter a sub data sheet into a table?

For upcoming training course dates see: Pricing & availability

replyReply Tue 13 Nov 2007, 09:53Trainer Richard said...

RE: Data Sheet

To show SUBDATA in a table, click on INSERT> SUBDATASHEET.

You will need to specifiy which object (Table or Query) you want to see related, and which fields the relationship will be built on.

Regards

Richard

 

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard