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 More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Microsoft Access Expert 26
By Richard Rost     7 years ago

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
7 years ago
Hi there thank you for this tutorial

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:
 9/17/2021 Overlapping Windows 9/16/2021 Inventory 9/10/2021 Benefits of Access 9/10/2021 Access on a Phone 9/5/2021 Prevent Deletion 9/4/2021 Booklet Template 9/4/2021 Inspections Template 8/29/2021 What is Microsoft Access? 8/27/2021 Union Query 8/24/2021 Navigation

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey
Keywords: access expert 26 math type conversion functions random rnd trigonometry sin cos tan atn pi dice rol  Page Tag: whatsnew  PermaLink