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 · Low Priority · Version 2003

Reply Wed 8 Apr 2009, 11:47Delegate Brynjar said...

Brynjar has attended:
Access Advanced course

Access

Is it vital to learn VBA for database development?

For upcoming training course dates see: Pricing & availability

Reply Thu 9 Apr 2009, 11:32Trainer Carlos said...

RE: Access

Hi Brynjar

The short answer is Yes.

In Access you cannot develop a sophisticated Access database without it.

Although Access produces great Databases you need VBA to automate connections especially in forms.

It is also a stepping stone to SQL programming.

Hope this helps.

Carlos

Thu 16 Apr 2009: Automatically marked as resolved.

Access articles

· Get A Head Start With Access 2010 Templates
· Material covered on a Microsoft Access Course
· Build International Databases With Microsoft Access
· How To Use The New Total Feature In Microsoft Access 2007/10
· Why go on a Microsoft Access Training Course?

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