access-training-courses - Queries

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

Resolved · Low Priority · Version Standard

Queries

Sabine has attended:
Access Intermediate course

by - delegate Sabine [7 posts] (2007 Oct 25 Thu, 16:54) Reply

how do i link my query to my table and then to my report?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: queries

by - trainer Rajeev gold contributer [462 posts] (2007 Oct 28 Sun, 00:40) Reply

Dear Sabine

Not sure exactly what you are seeking!! I hope you are aware that when you create a report using the wizard you can choose any table or query.

I am not sure what you mean by linking!! When you create a query from a table they are automatically linked.

Did you mean if you change the table how it is reflected in the existing report/s?

· Why go on a Microsoft Access Training Course?
· Take an Access Course to Learn About Relational Databases
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· How Reorganising Your Data Can Take Your Business to the Next Level
· Material covered on a Microsoft Access Course

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.