Hellow guys, Welcome to my website, and you are watching Microsoft Access Beginner Level 2 Complete FULL Course. Form Design. Intro to Relationships. More!. and this vIdeo is uploaded by Computer Learning Zone at 2022-09-18T12:46:22-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Microsoft Access Beginner Level 2 Complete FULL Course. Form Design. Intro to Relationships. More! |
| Video Uploader | Video From Computer Learning Zone |
| Upload Date | This Video Uploaded At 18-09-2022 15:46:22 |
| Video Discription | This is my complete Microsoft Access Beginner Level 2 course. It runs 1 hour and 45 minutes. This course follows Level 1 which you can find fore free on my website and my YouTube channel. LEVEL ONE: https://599cd.com/ACB1 https://youtu.be/tj2USpibb7Y If you are interested in Level Three, that can be purchased directly from my website for just US $1 here: LEVEL THREE: Access Beginner 3: https://599cd.com/ACB3L LEVEL TWO TOPICS 00. Introduction (00:00) 01. Getting Started (04:08) 02. Form Design 1 (13:09) 03. Form Design 2 (26:00) 04. Intro to Relationships (38:52) 05. Appointment Form (54:45) 06. Q&A From Students (1:15:10) 07. Review & What's Next (1:40:22) In Lesson 1, we will download the sample database from Level 1. We'll learn about the security warning and what it means that "active content has been disabled." We will set up a Trusted Location on our computer to put our database files in, and then make a shortcut to our database on the Desktop. We'll go over a quick review of the topics covered in Level 1. In Lesson 2, we will begin rebuilding the customer form we started in Level 1. We will learn how to add, remove, and resize controls. We'll see how to align and size objects relative to each other. We'll see how to modify the foreground (font) and background colors. In Lesson 3, we will continue working with form design. We'll focus on additional kinds of form formatting. We'll learn the difference between the grid lines and grid dots, and how to change between them. We'll learn how to size objects to the grid. We'll work with some additional object properties like colors, outlines, and fonts. We'll learn about Themes. In Lesson 4, we will get an introduction to relationships, one of the most important features of an Access database. We will learn what relationships are, why we want to use them, and about the different types of relationships. We'll learn about primary and foreign keys. We'll build a table to track appointments for each customer. We'll learn how to set default values using the Now and Date functions. In Lesson 5, we will continue working with relationships. We'll build an appointment form. We'll learn how to build a relational combo box so we can pick a customer from a list of customers. We'll make a command button so that we can open the appointment form and see just the appointments for the selected customer. Finally, we'll take some time to go over popular questions that I've been asked over the past 20 years of teaching this course. We'll discuss customizing the Ribbon and the Quick Access Toolbar. What's the problem if you can't see text as you are typing into a form? How to print a form in design view. How to get your AutoNumbers to start higher than 1. What's a combo box that's always open? What is the maximum size of an Access database, and the max number of fields per table. Can you run Access on a Mac? How to restore a deleted textbox. What's the green triangle that shows up on your fields in design mode. What is a #Name? error? How to deal with "unrecognized database format" errors. Can you change the background color of a checkbox? How to put data from multiple tables on a form. What are the thumbtacks on the file list for? What's an LACCDB file? LINKS: Full Beginner 1 Course: https://599cd.com/ACB1 Get Beginner Level 3 here: https://599cd.com/ACB3 TechHelp Video Series: https://599cd.com/TechHelp TechHelp Free Templates: https://599cd.com/THFree ADDITIONAL RESOURCES: Get on my Mailing List: https://599cd.com/YTML Twitter: https://twitter.com/LearningAccess https://en.wikipedia.org/wiki/Microsoft_Access https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft-365/blog/access/ KEYWORDS: microsoft access tutorial, ms access, access 2016, access 2019, access 2021, access 365, #msaccess, #microsoftaccess, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, access beginner 2 form design, intro to relationships, combo box, appointments QUESTIONS: Please feel free to post your questions or comments below. Thanks. |
| Category | Education |
| Tags | Education Download MP4 | Education Download MP3 | Education Download MP4 360p | Education Download MP4 480p | Education Download MP4 720p | Education Download MP4 1080p |
