Access

Resolved · Low Priority · Version 2003

Access

Matthew has attended:
Access Intermediate course

by - delegate Matthew [2 posts] (2008 Apr 8 Tue, 15:47) Reply

When is it best to transport data to Excel?

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: Access

by - trainer Pete platinum contributer [799 posts] (2008 Apr 9 Wed, 09:15) Reply

Hi Matthew, Thank you for your post, welcome to the forum, in answer to your question.
Access is a database which will store, sort and filter data, Excel is a 'number cruncher' they both have overlapping functions, ie Excel can contain a 'flat file database' and Access can undertake calculations on field data.
However the point at which you decide to move records from Access to Excel would be when Access can no longer provide you with the ease of creating calculations that you can find in Excel.
However why not consider this option; create and calculate your requirements in Excel, but link the table to your Access Database.
To link an Excel Table to an Access Database you could search this forum to find the steps necessary, or come back and I will provide. I hope that helps, best regards Pete

· Why consider Access Visual Basic training?
· Get More Out of MS Access Courses
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Innovation with Microsoft Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses

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

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.