access-database-training - new queries

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access-database-training - new queries linking to excel spreadsheets | Access forum

access-database-training - new queries linking to excel spreadsheets | Access forum

resolvedResolved · Low Priority · Version Standard

Sarah has attended:
Access Introduction course

new queries linking to excel spreadsheets

how to set up new queries?

linking database to spreadsheets?

RE: new queries linking to excel spreadsheets

Hello Sarah,

Setting up queries is covered on the Access Introduction course.

The File / Import facility allows the linking of Acess to Excel spreadsheets. This is discuss on the Introduction course, last topic of the day under importing

Regards


 

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


Server loaded in 0.08 secs.