using ms access queries
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 » Using MS Access queries

Using MS Access queries

resolvedResolved · Low Priority · Version 2003

replyReply Wed 4 Mar 2009, 15:13Delegate Richard said...

Richard has attended:
Access Advanced course

Using MS Access queries

Where I telework, the network speed is extremely slow. This affects me when I am trying to run MS Access queries.

How can I use MS Access to get round this? Is the use of make-table queries the best / only way round a slow network?

For upcoming training course dates see: Pricing & availability

replyReply Thu 5 Mar 2009, 09:57Trainer Stephen said...

RE: Using MS Access queries

Hi Richard

Thank you for your question

Using a make table query would place a copy of a table on your lap top. You could then build queries on that, thus avoiding the need to connect remotely to the database.

The problem would be that the tables you create would be a snapshot of the data at the time you built them and would not necessarily represent the up to date data.

You might want to consider the method you use to connect when working remotely, and seek advice from your IT support.

Regards

Stephen

Wed 11 Mar 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft-access-courses and other Microsoft training courses.

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

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