Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Beginner 2

Next: Access Beginner 4 >

Access Beginner Level 3
Beginner Microsoft Access Tutorial - 1 Hour, 19 Minutes

 
 
This Microsoft Access video tutorial picks up where Level 2 left off. This class focuses on a very important topic that is crucial to proper table design in Access: Field Properties for table fields. 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

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first lesson of this course (free of charge), or scroll down for more information.




 

Access 2010 Beginner Level 3
Description: Access 2010 Beginner Level 3
Versions: Microsoft Office Access 2010
Access 2007 users should be able to follow along fine
Pre-Requisites: Access 2010 Beginner Level 2
Running Time: 1 Hour, 19 Minutes
Cost: $9.99


This class picks up where Level 2 left off. We will focus on the Field Properties for your table fields. You will learn about the most popular properties, including field size, caption, description, format, decimal places, input masks, default value, validation rule, validation text, and using inequalities.

We will begin by learning about the Field Size property. You will learn about field sizes for autonumbers, text, and number fields. You'll learn about the different number types and which ones you should use: byte, integer, long integer, single, double, and decimal. We'll talk briefly about Replication IDs and why you don't need them.

 

Next you will learn about the caption and description properties, why they're useful, what they do, and what the difference between the two are. You'll learn how to change the column header in datasheet view and how to set a status in the status bar at the bottom of a form.

 

You will learn about the format property, and how to set formats for several different data types including numbers, text, currency, and dates. You will learn about the different number type formats including general, currency, fixed, standard, percent, and scientific. You will learn about the decimal places property and currency formats. You will learn how to format dates and times. You'll learn about the stock time/date formats: general date, long date, medium date, short date, long time, medium time, and short time. You'll also learn how to create your own custom date/time formats, like yyyy-mm-dd. You'll learn how to format text values like phone numbers and Social Security numbers.

 

You will learn how to work with Input Masks to control the way data is entered into a field. We'll talk about placeholder characters and whether or not you want to store them in your table. We'll see many of the popular stock input masks such as phone number, zip code, password, and more.

 

You will learn about the default value property and how you can use it to create the starting value for any field. For example, if most of your customers are from New York, you can set it as the default value. You will learn how to automatically set the current date and/or time for a new record using the Date() and Now() functions.
 

 

You�ll learn about the validation rule property which allows you to specify the values that can go into fields. For example, if you want to make it so that a customer never gets assigned a credit limit more than $5000, you can do that with a validation rule. You'll learn about the validation text, which is a message you can provide if the rule is violated. We'll talk about what happens when existing data violates the validation rule. You'll learn about logical inequalities (greater than, less than, not equal to, etc.) and the keywords you can use with them (AND, OR, & BETWEEN). You'll see how you can use the Date() function in the validation rule.

 

This is the perfect class for anyone who is wants to learn proper table design in Microsoft Access. Understanding field properties is crucial. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access 2010 Beginner Level 3

0. Intro (6:53)

1. Field Properties 1 (14:40)
Design View
Field Size
AutoNumber Field Size
What is a Replication ID
Text Field Size
Number Field Size
Byte, Integer, Long Integer
Single, Double, Decimal
Warning: data may be lost

2. Field Properties 2 (5:13)
Caption
Changes default form label
Changes column header in datasheet
Don't confuse with Description

3. Field Properties 3 (16:02)
Format Property
Number Formats
General, Currency, Euro
Fixed, Standard, Percent
Scientific
With percent 1 = 100%
Decimal Places
Rounded values displayed
Actual values stored
Currency Formats
Format might hide data
mm dd yyyy, hh nn ss
F1 for Access Help
List of Date Format Codes
Text Format
Phone Numbers
@@@-@@@-@@@@
Yes/No Format
4. Field Properties 4 (5:25)
Input Mask Phone Number
Placeholder characters
Store symbols in the mask?
Enter data
Warning message on invalid data
Date/Time Input Masks
No Wizard for numbers/currency
Help for Input Masks

5. Field Properties 5 (9:47)
Default Value
State of NY
NumEmployees 1
DiscountRate .05
Automatically set current date
Date() Function
Now() Function includes time
Yes/No Default Values

6. Field Properties (16:16)
Validation Rule
Inequality Symbols
NULL Values not the same as ZERO
Existing data violates rule
Validation Text
ESC escape to cancel editing
Range of values
AND OR
BETWEEN keyword
Date Values #1/1/1980#
Date() Function in Validation Rule
Functions in Validation Text

7. Review (4:47)

 


 
Keywords: Table Field Properties, Field Size, Caption, Format, Input Mask, Validation Rule, Default Value, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 training, replication id, byte, integer, long integer, single, double, decimal, description, validation text, number format, general, currency, fixed, standard, scientific, percent, decimal places, date formats, access help, date format codes, text format, phone number, placeholder characters, store symbols, set current date, date() function, now() function, inequality, null values, AND, OR, BETWEEN, date values in # symbols
 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP