access vba courses - Microsoft Access Foundation

Resolved · Low Priority · Version Standard

Microsoft Access Foundation

Roz has attended:
Access Intermediate course
Access Introduction course

by - delegate Roz [2 posts] (2007 Nov 5 Mon, 16:47) Reply

What does 'Double' mean in the Field Size in design view?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Microsoft Access Foundation

by - trainer Stephen gold contributer [386 posts] (2007 Nov 9 Fri, 10:40) Reply

Hi Roz

When you design a field you need to specify how much memory will be set aside for the data. When dealing with numbers you need to tell access how big the number can be.

When dealing with numbers that are decimals there are three options "Single", "Double" and "Decimal".

Double takes up 8 bytes of memory and can contain a number in the range

4.94065645841247 E-324 to 1.79769313486232 E308

(in scientific notation)

· Microsoft Access: Unleash the True Potential Today
· How Reorganising Your Data Can Take Your Business to the Next Level
· Take an Access Course to Learn About Relational Databases
· Microsoft Access Mistakes to Avoid
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

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

Rate this page: