Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access Beginner 3
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 years ago

This Microsoft Access video tutorial picks up where Level 2 left off. This class focuses primarily on table field properties in Access. You will learn:

  • What are Field Properties
  • Field Size
  • Caption & Description
  • Format Property
  • Decimal Places
  • Input Masks
  • Setting a Default Value
  • Validation Rule & Text
  • Using Inequalities

Click here for more information on Access Beginner Level 3, including a course outline, sample videos, and more.


Phone Number Input Mask Upload Images   Link 
Muhamad Faizul Izwan 
12 months ago
In my country our cell phone number is usually with 3 header and 7 following digits but now some of the of the country is using 3 digits header with 8 following digits. When I set the cell phone text box with input mask for 7 digit it wont allow the use to enter the 8 digit one. but when i set it for 8 digit it won't accept 7 digit either. how can i set the input mask to accept both 7 digit and 8 digit phone number?
Richard Rost
12 months ago
Great question. I'm going to turn this into a TechHelp video. Stay tuned.
Add a Reply
Upload Images   Link 
Rafael Gonzalez 
5 years ago

This is what i get when i go F1 key.
Office VBA developer help content

All context-sensitive (F1) developer help for VBA is available on MSDN and GitHub. It is no longer available on (now Read More...
Add a Reply
Hi Richard am getting along with the lectures qui Upload Images   Link 
Lamin Sanyang 
6 years ago
Hi Richard, am getting along with the lectures quite well and am loving it. I want to ask if it is possible to build formula on Microsoft Access just like it is done on excel? However, if possible but different with the way it is done on excel; kindly let me know. Read More...
Add a Reply
Long Integer Limit Upload Images   Link 
Rajiv Dass 
6 years ago
For Long integer you show "+/_ 2,000,000" but you say "plus or minus 2 Billion (11:15)? which is it?

Reply from Alex Hedley:

Byte — Use for integers that range from 0 to 255. Storage requirement is 1 byte. Read More...
Add a Reply
Access 2010 Beginner 3 Upload Images   Link 
R?gis D 
6 years ago
Hello Richard,
I am trying to do following based on an Access database:
- populate the database based on e txt file being also actually populated itself realtime;
- gnerating graphs directly from the data being generated out of Access database. Read More...
Add a Reply
Phone Extension Upload Images   Link 
Heather Hudson 
6 years ago
How can a phone extension be entered?
Also, am I able to manipulate that only some of the numbers have extensions or do I have to show for all?

Reply from Alex Hedley:

You could either have it as another Field or just only add it into 1 field and allow the field a longer character length Read More...
Add a Reply
Phone Option Input Mask Upload Images   Link 
Resat Ilgaz Demirel 
6 years ago
For some reason I am not getting Phone option in my input masks.

Reply from Alex Hedley:

What data type is the Field?
Add a Reply
Sort by Dates Upload Images   Link 
Mark E 
6 years ago
Thanks for the prompt reply. I am looking for help on an appropriate way to set up the data base to enter and sort the two different types of dates for photographs.e.g "c1990" or "26 March 2010". I assume Access does not allow two different date formats to be used in a single date field. Read More...
Add a Reply
Sort by Dates Upload Images   Link 
Mark E 
6 years ago
Hello Richard - I have been a while getting back to this item. Continuing from above. If I want to sort by "date" (e.g for photos) and have two types of date formats some with just the approximate "year" known and others with the "day/month/year" how might this be done. Read More...
Add a Reply
How do I blind all but last four in SSN Upload Images   Link 
Joe Beniacar 
6 years ago
Regarding Philip Bartlett's question about "blinding all but last four #'s in the SSN's", could you make the concatenation of *'s and RIGHT the SSN field's Format field property in the Table/Form, as well? Thanks!
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access 2010 beginner 3 field properties field size caption description format input mask default  Page Tag: whatsnew  PermaLink