Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< 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 Beginner Level 3
Description: Access Beginner Level 3
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access Beginner Level 2
Running Time: 1 Hour, 19 Minutes

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 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)
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
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
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 tutorial, microsoft Access 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


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/21/2024 11:38:38 PM. PLT: 0s