ms access training courses in london

ms access training courses in london - Data access page

Resolved · Low Priority · Version Standard

Data access page

Richard has attended:
Access Advanced course
Access Intermediate course
Access VBA course

by - delegate Richard [1 post] (2007 Oct 10 Wed, 16:19) Reply

can i create a drop down box which will automatically update all other fields?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: data access page

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 15:13) Reply

Hi again Richard, Thanks for the post, I had to dig deep to find an answer to your question. Consider we have two tables tblSuppliers and tblProducts, they should be joined through a common field (One supplier - Many products) eg SupplierID.
1. Create Two Data Access Pages one from each of the tables.
2. To view the products supplied by a particular Supplier, open the DAPage for Suppliers in Design view,
3. Display the field list and expand the Tables folder to view the list of tables in the database,
4. Expand the table for Products to view all the fields, drag the Product_name field (for example) to the Suppliers DAPage, if necessary confirm the link field, select display type ie Columnar,
5. Right Click the new control and choose Group Filter Control, the control is now a drop down field and will show Supplier data for each Product chosen in the drop down.

· Microsoft Access: Unleash the True Potential Today
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Microsoft Access and Customer Surveys
· Get More Out of MS Access Courses
· Access Database Optimization: First Normal Form

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.