microsoft-access-courses - Excell

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

Resolved · Low Priority · Version Standard

Excell

Sue has attended:
Access Introduction course

by - delegate Sue [1 post] (2008 Jan 23 Wed, 16:25) Reply

please explain again how to be able to imput date onto the excell spreadsheet from the access site.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
Full Schedule: See all 48 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: excell

by - trainer Carlos gold contributer [473 posts] (2008 Jan 28 Mon, 09:44) Reply

Hi Sue

To export an Access table to Excel do the folowing:

1. Select the table you want to export

2. Open the File menu. Select Export

3. In the Export dialog box select the folder where you want to save the table.

4. Make sure the Save As Type is Microsoft Excel 97-2003

5. Click Export

The new workbook is saved in the indicated folder.

Hope this helps

Carlos

· The Benefits of Certified Microsoft Training in Access
· Reasons to Consider Microsoft Access Training
· Microsoft Access Courses
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· How Reorganising Your Data Can Take Your Business to the Next Level

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.