Access/Excel

Resolved · Low Priority · Version 2003

Mon 12 May 2008, 16:58 Delegate Jacqueline said...

Jacqueline has attended:
No courses

Access/Excel

Why would I use Access instead of Excel?

Tue 13 May 2008, 06:05 Trainer Tracy said...

RE: Access/Excel

Access is database software so stores information such as customer details telephone numbers address etc. Where as Excel is a spreadsheet based software and purely deals with numerical information.
Hope that helps
Tracy

Training courses

	98.8 % recommend us
	More live stats...

Training information:

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