Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft/access/training/courses - Access

microsoft/access/training/courses - Access

ResolvedVersion Standard

Tue 4 Dec 2007, 14:44 Delegate Barbara said...

Barbara has attended:
Access Intermediate course

Access

Hello,

This maybe a silly question and I am not sure if this is possible.

Via Access is it possible to create a folder in queries? in order to organize my queries?

Many thanks
Barbara

Mon 10 Dec 2007, 14:54 Trainer Richard said...

RE: Access

Hi Barbara

Thank you for your question regarding creating folders in your queries.

The short answer is NO, you cannot create a folder with the queries section. To arrange your queries you might consider using a naming process that orders your queries by section.

For example, if you have queries for different departments, you might have the queriy name starting with the department.

eg:
HRTotalSumQuery
HRAverageSpend
AccountsTotalSumQuery
AccountsBirthdays
etc.

Does that address your question?

Regards

Richard
Microsoft Office Specialist

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

microsoft/access/training/courses - Access

Access

RE: Access

Access articles

Access tip:

Choosing data types in Access