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

	98.1 % recommend us
	More live stats...

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

Training information:

Access

Resolved · Medium Priority · Version 2007

Reply Tue 31 Aug 2010, 11:46Delegate Tracy said...

Tracy has attended:
Access Introduction course
Access Intermediate course

Access

I have about 1200 contacts that I would like to export from Outlook Contacts into Access. My question is would this be straightforward or would I have a lot of tiding up to once I have converted these?

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Sep 2010, 13:49Trainer Anthony said...

RE: Access

Hi Tracy, thanks for your query. Actually, that should be pretty straightforward, the applications relate to each other closely so there should be only a little tidying up (e.g. making sure the datatypes of the fields are set correctly) after getting the data into Access.

Hope this helps,

Anthony

Access articles

· How To Show JPG Or GIF Images In Access 2003 Forms
· Get To Know The 3 As: Access Accuracy Achievement
· Supersizing your databases via Microsoft Access
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Learn About Action Queries In Access

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