Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Queries
Hi Jenny,
Thanks for posting to our forum.
Hopefully by the end of your course you will have learnt how to create a query in Access!
As a quick reminder: go to Queries and design view to create a new query.
I hope you enjoyed your training
Tracy
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.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
