advanced microsoft access courses in london - access sql books
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access courses in london - Access SQL books

advanced microsoft access courses in london - Access SQL books

resolvedResolved · Low Priority · Version Standard

Tue 12 Dec 2006, 10:09 replyReply Delegate Evita said...

Evita has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Access SQL books

Hello,
Could you please recommend me a couple of useful books in Access SQL?
I haven't done that course with you, so hopefully I'll try to self-train with a book.

Many Thanks,
Evita

For upcoming training course dates see: Pricing & availability

Tue 12 Dec 2006, 10:18 replyReply Trainer David said...

RE: Access SQL books

Hi Evita

If you follow this link, you will find a link to an online book store, where you will be able to search for SQL books, personally I would recoment one of the Sam's books.

http://www.microsofttraining.net/access-training-london.php

Hope this helps

David

 

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.



Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.



To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.



Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.



However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.



View all Access hints and tips



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest