training for microsoft access - how do i live
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 » training for microsoft access - How do I live link data from Access to Excel?

training for microsoft access - How do I live link data from Access to Excel?

resolvedResolved · Low Priority · Version Standard

replyReply Wed 17 Oct 2007, 15:35Delegate Duncan said...

Duncan has attended:
Access Introduction course

How do I live link data from Access to Excel?

How do I live link data from Access to Excel?

For upcoming training course dates see: Pricing & availability

replyReply Mon 22 Oct 2007, 16:23Trainer Richard said...

RE: How do I live link data from Access to Excel?

FILE > GET EXTERNAL DATA > LINK.

Step through the wizard, locate the file, and link the data.

 

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

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