|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Access Expert 25 Welcome to Access Expert 25. Total running time is 1 Hour, 33 Minutes. Lessons
Resources
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
IntroIn lesson 25, you will learn about the different functions available in Microsoft Access, with a focus on string functions and logical functions. I will review some functions you may have seen in earlier lessons and share new tips and examples, as well as introduce new functions you may not have used before. We will cover what string functions are, how to use them for working with text, and then move into logical functions. This lesson is suitable for anyone who has completed the beginner series and at least the first few expert level classes.TranscriptWelcome to Microsoft Access Expert Level 25, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.Today's class is part one of our comprehensive guide to Access functions. We are going to take the next couple of classes to cover all the different functions you could possibly ever want to use in Microsoft Access. Today's class will focus on string functions and logical functions. Some of these functions we have covered in previous lessons. I will be going over them briefly and/or showing you some new tips and tricks regarding those functions. Some of these functions are brand new, even for me. Prerequisites: this class follows Access Expert Level 24, and the couple of classes before it covered some advanced topics that you do not necessarily have to know to watch this class. However, before continuing, I strongly recommend you finish my beginner series and preferably expert levels one through four at least, where I begin to cover functions. If you have some of the background on functions before watching today's class, it will definitely help you. This class is recorded with Access 2013. If you are using 2007 or 2010, you should be okay following along with this class. Most of the functions that I am covering were around in Access 2003; however, a couple of them were new in 2007. Some of them, like Switch, will not be available to you if you are still using Access 2003 or earlier. It is time to upgrade. My courses are broken up into beginner, expert, advanced, and developer level classes. Beginner level classes are for novices. You should understand all the topics covered in them by the time you get to the expert level classes, which you are in now. When you finish all the expert level classes, the advanced classes will cover event programming and macros, and the developer classes will cover Visual Basic for Applications. Each group of classes is broken down into multiple levels: Level 1, 2, 3, and so on. In addition to my normal Access classes, I also have seminars designed to teach specific topics. Some of my seminars include building web-based databases, creating forms and reports that look like calendars, securing your database, working with images and attachments, writing work orders and running a service business, tracking accounts payable, learning the SQL programming language, creating loan amortization schedules, and lots more. You can find details on all of these seminars and more on my website at accesslearningzone.com. If you have questions about the topics covered in today's lessons, please feel free to post them in my student forums. If you are watching this course in the online theater on my website, you should see the student forum for each lesson appear in a small window next to the class video. Here you will see all of the questions that other students have asked, as well as my responses to them and comments that other students have made. I encourage you to read through these questions and answers as you start each lesson and feel free to join in the discussion. If you are not watching these lessons on my website, you can still visit the student forums later by visiting accesslearningzone.com/forums. To get the most out of this course, I recommend you sit back, relax, and watch each lesson completely through once without trying to do anything on your computer. Then, replay the lesson from the beginning and follow along with my examples. Actually create the same database that I make in the video, step by step. Do not try to apply what you are learning right now to other projects until you have mastered the sample database from class. If you get stuck or do not understand something, watch the video again from the beginning or tell me what is wrong in the student forum and I will do my best to help you. Most importantly, keep an open mind. Access may seem intimidating at first, but once you get the hang of it, you will see that it is really easy to use. I strongly encourage you to build the database that I build in today's class by following along with the videos. However, if you would like to download a sample copy of my finished database file, you can find it on my website at accesslearningzone.com/databases. Sometimes, if you get stuck, the easiest way to learn is to tear apart someone else's database. One of the ways that I taught myself Access years ago was by tearing apart the Northwind Traders database that comes with Microsoft Access. You will find there is a sample database for each of my courses on my website. Now let's take a few minutes and go over exactly what we are going to cover in today's class. In lesson one, we are going to begin learning about string functions, also called text functions. In lesson two, we are continuing with string functions. In lesson three, we will begin looking at logical functions. In lesson four, we are continuing our look at logical functions. QuizQ1. What is the primary focus of Access Expert Level 25?A. Introduction to database relationships B. Comprehensive guide to Access functions, focusing on string and logical functions C. Advanced Visual Basic for Applications programming D. Creating query wizards Q2. What does Richard recommend you complete before starting this class? A. Developer level courses B. Access beginner series and preferably expert levels one through four C. Only Access Expert Level 24 D. Advanced event programming lessons Q3. Which Access version is primarily used in this tutorial? A. Access 2003 B. Access 2007 C. Access 2010 D. Access 2013 Q4. What feature is NOT available if you are using Access 2003 or earlier? A. String functions B. Switch function C. Reports D. Queries Q5. What is suggested if you get stuck while working through the course material? A. Skip to the next lesson B. Watch the video again or post in the student forum for help C. Give up entirely D. Only read the course textbook Q6. What approach does Richard suggest for following along with the lessons? A. Apply concepts directly to your own project first B. Watch each lesson through once, then follow along with building the sample database C. Only watch the summary at the end D. Memorize every screen Q7. What kind of additional content does Richard provide outside of normal Access classes? A. Free hardware recommendations B. Seminars on specific topics, like building web-based databases and securing your database C. Video game walkthroughs D. Networking tutorials Q8. Where can you find sample databases to download that match the video lessons? A. Only on YouTube B. At accesslearningzone.com databases C. Through Microsoft support D. In the Access software itself Q9. What is planned for lessons three and four of this course? A. Macros and events programming B. Introduction to forms and reports C. Logical functions D. Database security features Q10. According to Richard, what is a good way to learn Access aside from following his courses? A. Only reading books B. Tearing apart the Northwind Traders sample database C. Hiring a tutor D. Watching unrelated online tutorials Answers: 1-B; 2-B; 3-D; 4-B; 5-B; 6-B; 7-B; 8-B; 9-C; 10-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone is Microsoft Access Expert Level 25, and it's the first part of a thorough guide to using functions in Microsoft Access. In this series, we'll explore all of the Access functions that you might need for your projects. This particular class zeroes in on string functions and logical functions.Many of the functions we'll talk about have come up in earlier lessons, so I'll briefly review them and share some new tips or techniques for working with those functions. We'll also investigate a few functions that are new, even to me. This class builds on Access Expert Level 24, but it's not necessary to have finished the most recent advanced topics to get value out of today's lessons. Still, having completed my beginner series and at least the first four expert levels will give you a better foundation for understanding how functions work in Access. I'm working with Access 2013 for this course. If you are using Access 2007 or 2010, you should be able to follow along without much trouble, as most of the functions I demonstrate have been available since Access 2003. That said, a handful of them were introduced in 2007, so users of Access 2003 or earlier might find that certain features, such as the Switch function, are unavailable. If that's the case, it's a good idea to consider upgrading. My course catalog is divided into four groups: beginner, expert, advanced, and developer. By the time you reach the expert level, which you are in now, you should already be comfortable with the content from the beginner classes. Once you finish the expert level classes, you'll be ready for advanced lessons that cover event programming and macros, followed by developer classes that focus on Visual Basic for Applications (VBA). Each group is further split into multiple levels like Level 1, Level 2, and so on. In addition to my main Access classes, I offer seminars on specialized topics. Some examples include building web-based databases, designing calendar-style forms and reports, securing a database, working with images and attachments, managing work orders for service businesses, tracking accounts payable, learning SQL, creating loan amortization schedules, and more. You can find information about all of these specialized seminars on my website. If you ever have questions about the content of today's class, you're welcome to participate in the student forums. If you are watching this video on my website, the forum for each lesson appears next to the video. In these forums, you can read questions and answers from other students as well as my responses. I recommend browsing these discussions at the start of each lesson and joining the conversation if you have anything to add. If you're not viewing this course on my website, you can still access the forums at any time by heading to accesslearningzone.com forums. To get the most out of this material, I suggest watching each lesson all the way through first, without stopping to try the exercises yourself. Then, start the lesson over and practice along with me step-by-step, building the sample database from the video. Mastering the technique this way—using the sample database—will make things clearer before you transfer your skills to your own projects. If you get stuck or something doesn't make sense, go back and rewatch the relevant section, or ask questions in the student forum so I can help. As you work through these lessons, approach them with an open mind. Access might seem daunting when you're just starting out, but with a little experience, you'll discover that it's actually quite straightforward. I always suggest that you build the same database that I'm building in the video, but if you'd prefer, you can download a copy of my finished database from my website. Sometimes the best way to learn is by examining someone else's example and seeing how it works. That's how I got my own start with Access, by taking apart the Northwind Traders database included with the program. There's a sample database for each of my courses on my website for you to explore. Here's a brief overview of today's topics. Lesson one introduces string, or text, functions. Lesson two continues our exploration of string functions. Lesson three gets us started with logical functions, and lesson four takes us further into that topic. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListString functions overviewUsing string functions in Access Practical examples with string functions Logical functions overview Using logical functions in Access Practical examples with logical functions |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: access expert 25 Left() Right() Mid() Separate Phone Number Parts InStr() Len() Separate First and Last Names UCase() LCase() StrConv() Trim() Replace() String Concatenation CStr() StrComp() ASCII Code Table Non-Standard Characters Space() IsDate() IsNull PermaLink Microsoft Access Expert 25 |
