Access Beginner Level 3
Beginner Microsoft Access Tutorial - 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