access+vba+courses+london

access+vba+courses+london - Queries

Resolved · Low Priority · Version Standard

Queries

Ben has attended:
Access Advanced course

by - delegate Ben [1 post] (2008 Jan 9 Wed, 15:50) Reply

How can I set up a record of when Queries get used, so I can remove unused ones from my (over large) database?
I imagine with an "off-focus" linked Macro, but will this pick up multiple-linked queries that may not be accessed directly?
Thanks,
Ben.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
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
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Queries

by - trainer Pete platinum contributer [803 posts] (2008 Jul 10 Thu, 08:49) Reply

Hi Ben, Thank you for your post, I have attempted to do this using a macro and many other automated ways but have been unsuccessful so I am going to hold my hands up and say that I cannot find an automated method of doing what you ask. regards Pete

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access Training Unleashes the Power of the Pivot Table
· MS Access and Database Normalisation
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Rate this page: