


Access
Expert
Level 26
Expert
Microsoft Access Tutorial  1 Hour, 41 Minutes 



Access Expert
26 is Part 2 of our Comprehensive Guide to Access Functions.
In today's class we will focus on Math and Type Conversion Functions. You will learn a bunch of new
functions, and new tricks with some of the functions we've covered
before. You will learn multiple functions for properly rounding
numbers, use trigonometry to calculate the height of a
building, display random customer records, build a dice
roller, and much more. Topics include:


Math Functions
 Abs, Sgn,
Round, Int, Fix, Val  Sqr, Exp, Log, Natural
Logarithms

Calculate Pi, Degrees to Radians 
Trig Functions: Sin, Cos, Tan, Atn

Mod, Integer Division, Is Divisible
 Random
Numbers: Dice Roller 
Display Random X Records

Type Conversion Functions 
CInt, CLng, CStr, CDate, CCur, etc. 
Order Now 
If you would like a preview of what's covered in this class,
click here to watch the first
and last lessons of
this course (free of charge), or scroll down for more information.

Access Expert Level 26 
Description: 
Access Expert Level 26 
Versions: 
Recorded with Access 2013.
Most of the material should work with all versions of Access.
The majority of the functions covered in today's class go all the way back to the
first versions of Access. 
PreRequisites: 
Access Expert Level
25 recommended, as you should watch all of my
classes in order. However, if you're skipping around, you should
have at least completed the Beginner series and the first 3 or 4
levels of the Expert series where I start to cover functions. 
Running Time: 
1 Hour,
41 Minutes 
Cost: 
$24.99 


We have covered some of these functions in previous classes, however in
this Comprehensive Guide to Access Functions we will cover those
in a lot more detail, plus learn many new functions. Today we will be
learning about Math and Type Conversion functions. We will
beging by learning about the Abs (absolute value) and Sgn
(sign) functions. We'll cover the Round function in a lot more
detail, and we'll review Banker's Rounding (Round to Evens). We'll learn
how to round to the nearest multiple of X (so, for example, round to the
nearest 10 or 500). We'll learn how to use the Val function to
pull the numeric digits from a text string, and how to convert from
hexadecimal to decimal.
Next we will learn about the Sqr (square root), Exp
(exponential), and Log (natural logarithm) functions. You will
learn how to raise a number to a power. You will learn about the
mathematical constant e (Euler's Number) and how to
calculate logarithms in any base (including 10, 2, and e).
Next we will learn about the trigonometric functions Sin, Cos,
Tan, and Atn. Access does not give us a function for Pi (3.14) so
we will learn how to calculate it using the Atn function. We will learn
how to convert degrees to radians (and vice versa). We
will use our newfound knowledge of trig to calculate the height
of a building knowing only the distance to the building and the angle to
the top of the building.
We will learn about the Mod (modulus) function and integer
division. We'll learn how to determine if a number is divisible
by X (for example, by 3 or 7). Next we will learn about the Rnd
function and how to use it to generate random numbers. We will
build a simple dice roller form where we can generate three
random dice rolls (of any sized die) and add them up.
We can then use these random number techniques to do all kinds of useful
things. For example, I'll show you how to create order/invoice
codes that consist of random numbers, or generate a list of X
random employees (let's say each month you want to conduct three
random employee reviews). These techniques will work for any kind of
random number scenario.
Finally, we will learn about the Type Conversion functions. These
allow us to convert from one data type to another. They've very handy
when importing values and they come in as text values, but you want to
convert them into proper Access data types (currency, date, etc.)
This is the 26th class in the Access Expert series. This
is the second class in my Comprehensive Function Guide series. If you're
serious about building quality databases with Access, don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline  Access Expert Level
26
00. Intro (06:20)
01. Math Functions 1 (27:09)
Abs  Absolute Value
Sgn  Sign
Postive, Negative, Zero
Round
Banker's Rounding
Round to Evens
Don't Want Banker's Rounding
Round to Nearest Multiple
Int  Round to Integer
Fix  Negative Int Rnd Up
Cint  Convert to Integer
Val  String to Number
Val to Convert HEX to DEC
Remove Thousands Separator
Power of Tens: 2E14
02. Math Functions 2 (12:16)
Sqr  Square Root
e  Euler's Number
Mathematical Constant
Exp  Exponential
^ Number to Power
Log  Natural Logarithm
Calculate Log of Any Base
03. Math Functions 3 (11:40)
Calculating PI
Inverse Functions Missing
Degrees to Radians
Radians to Degrees
Sin, Cos, Tan, Atn
Calculate Building Heights 
04. Math Functions 4 (29:21)
Mod 
Modulus
\ 
Integer Division
Is
Number Divisible By X
Rnd 
Random Numbers
Dice
Roller Form
Reroll
Button
Requery Macro Command
Display Random Records
Open a
Random Customer
SemiRandom Customer Codes
05. Type Conversion (9:42)
CBool
 Boolean
CByte
 Byte
CCur 
Currency
CDate
 Date
CDbl 
Double
CDec 
Decimal
CInt 
Integer
CLng 
Long Integer
CSng 
Single
CStr 
String
CVar 
Variant
06. Review (5:11) 


Keywords:
Comprehensive Function Guide, Math Functions, Type Conversion Functions, microsoft access tutorial, microsoft access tutorial, microsoft access training, access 2007, access 2010, access 2013, Abs, Sgn, Round, Int, Fix, Val, Sqr, Exp, Log, Sin, Cos, Tan, Atn, Rnd, Random, Pi, Radians, Degrees, Dice Roller, CInt, CLng, CDbl, CDate, CStr, CCur, CBool, CByte, CSng, CVar 


Student Interaction:
Microsoft Access Expert 26
Richard on 11/10/2014:
Access Expert 26 is Part 2 of our Comprehensive Guide to Access Functions. In today's class we will focus on Math and Type Conversion Functions. You will learn a bunch of new functions, and new tricks with some of the functions we've covered before. You will learn multiple functions for properly rounding numbers, use trigonometry to calculate the height of a building, display random customer records, build a dice roller, and much more. Topics include:
 Math Functions
 Abs, Sgn, Round, Int, Fix, Val
 Sqr, Exp, Log, Natural Logarithms
 Calculate Pi, Degrees to Radians
 Trig Functions: Sin, Cos, Tan, Atn
 Mod, Integer Division, Is Divisible
 Random Numbers: Dice Roller
 Display Random X Records
 Type Conversion Functions
 CInt, CLng, CStr, CDate, CCur, etc.
Click here for more information on Access Expert Level 26, including a course outline, sample videos, and more. This course was recorded using Access 2013, but most of the functions covered are valid for all versions of Access. This class follows Expert Level 25. The next class in the series is Expert 27 which covers Date and Time Functions. 
MBONGA on 11/11/2014: Hi there thank you for this tutorial




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


