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

microsoft training access course - templates

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Templates

microsoft training access course - Templates

ResolvedVersion Standard

Sunette has attended:
Excel Intermediate course

Templates

Where do I find the Spreadsheet templates on my computer in order to create a new spreadsheet.?
Thanks

RE: Templates

Hi Sunette

Thank you for your question.

You can access the in-built Excel templates through the task pane on the right hand side of your screen. If you can't see the task pane, then go to View - Task Pane.

On the New Workbook task pane, click the General Templates link under New from Template. Select the Spreadsheet solutions tab, then you will see all of the in-built templates that come with Excel. Select a template and click OK. Then a new file will be generated from the template you selected.

I hope this helps.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.