Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses - Microsoft Access Foundation

	98.1 % recommend us
	More live stats...

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

Training information:

access vba courses - Microsoft Access Foundation

Resolved · Low Priority · Version Standard

Reply Mon 5 Nov 2007, 16:47Delegate Roz said...

Roz has attended:
Access Intermediate course
Access Introduction course

Microsoft Access Foundation

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

For upcoming training course dates see: Pricing & availability

Reply Fri 9 Nov 2007, 10:40Trainer Stephen said...

RE: Microsoft Access Foundation

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)

Access articles

· Find Out All About Microsoft Access Report Sections
· Getting To Grips With Templates In Access 2007
· Want To Get Started With Macros In Microsoft Access?
· The Benefits of Certified Microsoft Training in Access
· Material covered on a Microsoft Access Course

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips