Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access 2007

Resolved · Low Priority · Version 2007

Reply Thu 18 Sep 2008, 17:10Delegate Craig said...

Craig has attended:
Access Intermediate course

Access 2007

Can you stop people entering the same data twice?

For upcoming training course dates see: Pricing & availability

Reply Thu 25 Sep 2008, 15:42Trainer Greg said...

RE: Access 2007

Craig,

I hope this answers your question.

Yes, there is a way of doing this. When designing a table (be in Tables and Design mode), on the bottom left-hand corner you can choose to not allow Duplicates (Index : Yes(No Duplicates)).

If this does not answer your question, please come back to us.

Thank you

Greg

Access articles

· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· What You Need To Know About New Security Features In Access 2007
· How To Make One Combo Show Values Determined By Another Combo In Access
· Some Things You May Not Know About Relational Databases
· How to Find a Third-Party Venue for Microsoft Access Training

Please browse our web site to find out more about
access+courses+in+london 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