Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access vba courses - microsoft access foundation

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

access vba courses - Microsoft Access Foundation

ResolvedVersion Standard

Roz has attended:
Access Intermediate course
Access Introduction course

Microsoft Access Foundation

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

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 tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.