How to use Microsoft Access - Beginners Course (Deep Dive)
Dive deeper into how to use Microsoft Access in this beginner's course. This video builds on concepts from Microsoft Access Tutorial - Beginners Level. In this tutorial, you will learn how to set up and customize fields for your table in Microsoft Access, import data from an excel spreadsheet, create a 1 to many relationships with two tables, create a form with controllers and drop-drowns, get more specific with your queries in Microsoft Access, create a report based on a query and learn to export your data. Use the timestamps below to navigate the video.
Microsoft Access Tutorial - Beginners Level 1: https://youtu.be/Sxp8YjKu_Tc
Practice excel file: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/Ee9T-B1BshhJv3iYuLE_X3sB685t77y4ST8MRXeXozbIcQ?e=faO5Qt
Microsoft query examples: https://support.microsoft.com/en-us/office/examples-of-query-criteria-3197228c-8684-4552-ac03-aba746fb29d8
0:00 Introduction
0:48 Why use Microsoft Access
2:44 Create a blank database
3:43 Create a table and add fields for students
8:06 Add a record to the student table
10:32 Import data from excel spreadsheet into a created table
13:19 Import data from excel spreadsheet into a new table
14:58 Create a relationship between tables (one to many)
22:56 Customize table fields in Microsoft Access
34:56 Create a form
37:05 Create a form with the form wizard
38:06 Customize the look of your form
45:47 Add a combo box to your form
49:55 Add an image to your form
51:05 Add command buttons to your form in Microsoft Access
56:16 Add a record with your form
57:30 Using Sort in your tables
58:59 Creating queries in Microsoft Access
1:03:33 Adding criteria to your query
1:07:06 How to use parameters and wildcards in your queries
1:10:50 Using the greater, less than or equal in the criteria
1:13:29 Create a report form a query
1:18:16 Export tables, forms queries, and reports
Видео How to use Microsoft Access - Beginners Course (Deep Dive) канала Teacher's Tech
Microsoft Access Tutorial - Beginners Level 1: https://youtu.be/Sxp8YjKu_Tc
Practice excel file: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/Ee9T-B1BshhJv3iYuLE_X3sB685t77y4ST8MRXeXozbIcQ?e=faO5Qt
Microsoft query examples: https://support.microsoft.com/en-us/office/examples-of-query-criteria-3197228c-8684-4552-ac03-aba746fb29d8
0:00 Introduction
0:48 Why use Microsoft Access
2:44 Create a blank database
3:43 Create a table and add fields for students
8:06 Add a record to the student table
10:32 Import data from excel spreadsheet into a created table
13:19 Import data from excel spreadsheet into a new table
14:58 Create a relationship between tables (one to many)
22:56 Customize table fields in Microsoft Access
34:56 Create a form
37:05 Create a form with the form wizard
38:06 Customize the look of your form
45:47 Add a combo box to your form
49:55 Add an image to your form
51:05 Add command buttons to your form in Microsoft Access
56:16 Add a record with your form
57:30 Using Sort in your tables
58:59 Creating queries in Microsoft Access
1:03:33 Adding criteria to your query
1:07:06 How to use parameters and wildcards in your queries
1:10:50 Using the greater, less than or equal in the criteria
1:13:29 Create a report form a query
1:18:16 Export tables, forms queries, and reports
Видео How to use Microsoft Access - Beginners Course (Deep Dive) канала Teacher's Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
5 Amazing Google Docs Hacks!Revolutionize Your Guide Creation: Auto-Generate with ScribeHow to use Threadit - Video meetings you don't need to be at!Set Goals in Google Calendar - New FeatureMake Microsoft Excel WAY Smarter?Google Drive Tutorial - Managing DriveRepair Documents in Microsoft Word. Make Old Look New!Create an Interactive Chart with Checkboxes in Microsoft ExcelLearn Different Ways to Combine Cells in Microsoft ExcelRelative vs Absolute Cell Reference in Microsoft Excel - What's the difference?Microsoft OneNote for Windows 10 Tutorial - Beginner's Level 2Create Drone-Style Videos for FREE with Google Earth StudioHow to Remove a Background from an ImageHow to use the NEW Microsoft Planner in TeamsEasy Podcasting for Teachers and Students with Synth3 Powerful Camera Features with Google App on a iPhoneCreate Excel Pivot Table from Multiple Sheets: The FASTEST WayHow to use the XLOOKUP Function in Microsoft Excel - Beginners TutorialMail Merge Made Easy: From Excel to Word to OutlookHow to use the Best FREE Premium PDF Editor7 Tips in Microsoft Word You May Not Know About