access course london - Access importing data

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

Resolved · Low Priority · Version Standard

Access importing data

Emma has attended:
Access Introduction course

by - delegate Emma [1 post] (2007 Jun 20 Wed, 12:53) Reply

In our training course for employees there was a subject called Annual Reports where it allows you to insert words into the box. If for example these annual reports on employees are prepared in Word, is it possible to link these reports into Access?

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 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
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access importing data

by - trainer Andrew platinum contributer [513 posts] (2007 Jul 13 Fri, 12:04) Reply

Hi Emma

Word will connect to Access to create a mail-merge. From Word go to the Tools menu then choose Letters and Mailings and Mail Merge Wizard.

The merge wizard appears in the task pane on the right of the screen. Step 3 of the wizard lets you choose your mail merge recipients - click on the browse link and navigate to find your access database. Choose your table or query with the recipients for your mailing then follow the rest of the wizard to complete your merge.

I hope this is helpful - do let us know if you have further questions.

Kind regards,

Andrew

· How To Find Good Access Database Courses In London
· Microsoft Access 2007: New Features
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Innovation with Microsoft Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips