access

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version Standard

Matt has attended:
Access Introduction course
Access Intermediate course
Access VBA course
Access Advanced course

Access

Thanks for the course! Can you give me your number one time-saving short-cut when using Access a lot for extracting accounts information? Something that'll save me a few minutes every day. Thanks!

RE: Access

Hi Matt, Thanks for the post, I have been away for a while, so left your question for someone else to answer, seems like no one wants to take it on. Not having an accounts background, I can only answer with standard Access procedure - remember the KIS principle (Keep it Simple) keep your queries simple if you need to query a query then do so. Hope that helps a little bit, best regards, Pete


 

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


Server loaded in 0.08 secs.