Quality & value training trusted by thousands of UK businesses

We'll call during UK business hours

0207 987 3777

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

	98.8 % recommend us
	More live stats...

Training information:

Data Validation

Resolved · Low Priority · Version 2007

Thu 28 Jun 2012, 15:54

Reply Delegate Charlotte said...

Charlotte has attended:
Access Introduction course
Excel VBA Introduction (1 day) course

Data Validation

Hi There,

I was wondering if there is anyway you can create a data validation in a form in access which references another table?

Thanks

Charlotte

For upcoming training course dates see: Pricing & availability

Mon 2 Jul 2012, 12:07

Reply Trainer Simon said...

RE: Data Validation

Hi Charlotte,

Thank you for your question.

Could you please provide me with some more details.

Do you mean like an IF statement that tests the value in a table and places an answer in a from field that matches the criteria set?

Regards

Simon

Thu 13 Dec 2012, 11:32

Reply Trainer Cindy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 20 Dec 2012: Automatically marked as resolved.

Access articles

· When Is Microsoft Access Not The Best Choice For Your Business?
· What Are The Benefits Of Publishing Your Microsoft Access Database?
· Get A Head Start With Access 2010 Templates
· How To Import Data Easily Into Access 2010
· Microsoft Access Flaws and Ways to Overcome Them

Please browse our web site to find out more about
access advanced courses and other Microsoft training courses.

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

MS Project training

Course rating:

4.8 stars - based on 5149 reviews

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

Resources