title
How to use Microsoft Access - Beginner Tutorial

description
In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you'll understand the fundamentals of working with databases in Access. 📚 RESOURCES - Sample Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-OHtH9VLpU4PdJw?e=0aRP1p ⌚ TIMESTAMPS 00:00 Introduction 01:01 Advantages of a database over Excel 02:36 Access alternatives 03:17 Overview of tutorial structure 04:10 Access start page 05:04 Create blank database 05:22 Tables, fields & records 14:36 Calculated field & expression builder 15:50 Sample order data 16:50 Opening & closing windows 17:16 Relationships 19:01 Import data sources 19:25 Forms 22:12 Queries 27:51 Reports 30:02 Save Database 30:25 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Access: https://youtube.com/playlist?list=PLlKpQrBME6xJ4Mxv00syl8iOSgL-GVLMG 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same) 🔽 CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://discord.gg/kHuujY2pZf - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎒 MY COURSES - Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 #stratvert

detail
{'title': 'How to use Microsoft Access - Beginner Tutorial', 'heatmap': [{'end': 636.93, 'start': 595.306, 'weight': 0.822}, {'end': 845.675, 'start': 782.087, 'weight': 0.796}, {'end': 955.101, 'start': 858.689, 'weight': 0.785}, {'end': 1121.784, 'start': 1041.005, 'weight': 0.781}, {'end': 1253.645, 'start': 1139.191, 'weight': 0.757}, {'end': 1532.807, 'start': 1509.975, 'weight': 0.775}], 'summary': 'Tutorial on microsoft access covers database management, data limitations in excel, creating and modifying tables, data entry, sql queries, and efficient order management, emphasizing the inefficiency of using excel for database tracking and the potential for advanced queries in access.', 'chapters': [{'end': 112.688, 'segs': [{'end': 47.043, 'src': 'embed', 'start': 22.088, 'weight': 1, 'content': [{'end': 28.951, 'text': 'we were both working at Microsoft at the time and she was on the Microsoft Access team, so I really felt like I had to do this video.', 'start': 22.088, 'duration': 6.863}, {'end': 35.715, 'text': "Now, you might be wondering, what is Microsoft Access? It's a relational database program.", 'start': 29.631, 'duration': 6.084}, {'end': 39.918, 'text': "And as we jump into this video, we'll find out more about what that even means.", 'start': 36.075, 'duration': 3.843}, {'end': 42.059, 'text': 'But at a very high level.', 'start': 40.258, 'duration': 1.801}, {'end': 47.043, 'text': 'you can use Microsoft Access to track customers, to track orders, to track assets,', 'start': 42.059, 'duration': 4.984}], 'summary': 'Microsoft access is a relational database program used to track customers, orders, and assets.', 'duration': 24.955, 'max_score': 22.088, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc22088.jpg'}, {'end': 102.24, 'src': 'embed', 'start': 74.692, 'weight': 0, 'content': [{'end': 79.873, 'text': "So this works too, right? Well, actually, it's not really that efficient at tracking this information.", 'start': 74.692, 'duration': 5.181}, {'end': 84.974, 'text': "Let's say that maybe Bill comes in and he really loves our cookies so he placed another order.", 'start': 80.473, 'duration': 4.501}, {'end': 87.995, 'text': 'So I want to enter another row with his new order.', 'start': 85.295, 'duration': 2.7}, {'end': 94.377, 'text': "So here I'll take all of this customer information, I'll paste it down here, and then I'll enter in the additional order details.", 'start': 88.336, 'duration': 6.041}, {'end': 97.738, 'text': "Now this is what's referred to as a flat file.", 'start': 94.838, 'duration': 2.9}, {'end': 102.24, 'text': "There are no relationships between this data and it's really inefficient.", 'start': 98.079, 'duration': 4.161}], 'summary': 'Tracking customer orders using flat files is inefficient and lacks data relationships.', 'duration': 27.548, 'max_score': 74.692, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc74692.jpg'}], 'start': 3.1, 'title': 'Using microsoft access for database management', 'summary': 'Discusses the use of microsoft access as a relational database program for tracking various types of data, including customers, orders, and assets, highlighting the inefficiency of using excel for similar purposes.', 'chapters': [{'end': 112.688, 'start': 3.1, 'title': 'Using microsoft access for database management', 'summary': 'Discusses the use of microsoft access as a relational database program for tracking various types of data, including customers, orders, and assets, highlighting the inefficiency of using excel for similar purposes.', 'duration': 109.588, 'highlights': ['Microsoft Access is a relational database program that can be used to track customers, orders, and assets.', 'Illustration of the inefficiency of using Excel for tracking information due to lack of relationships between the data, resulting in duplication and inefficiency.']}], 'duration': 109.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc3100.jpg', 'highlights': ['Microsoft Access is a relational database program for tracking customers, orders, and assets.', 'Illustrates the inefficiency of using Excel for tracking due to lack of data relationships.']}, {'end': 529.676, 'segs': [{'end': 311.652, 'src': 'embed', 'start': 271.449, 'weight': 0, 'content': [{'end': 277.332, 'text': "If there's a template that matches what you're trying to do, this could help you save a little bit of time and you can go in and just tweak it.", 'start': 271.449, 'duration': 5.883}, {'end': 281.694, 'text': "There's also a massive collection of templates that you can look at by clicking right here.", 'start': 277.772, 'duration': 3.922}, {'end': 285.957, 'text': 'Down below, you can search for different databases you might have worked on in the past.', 'start': 282.254, 'duration': 3.703}, {'end': 288.918, 'text': 'And here you can see all of your recent databases.', 'start': 286.337, 'duration': 2.581}, {'end': 293.782, 'text': "One of my favorite features, when you hover over right here, you'll see a pin icon.", 'start': 289.379, 'duration': 4.403}, {'end': 296.683, 'text': 'When you click on this, this will add it to the pinned view.', 'start': 294.122, 'duration': 2.561}, {'end': 301.667, 'text': 'So this is just a quick way to get back to the files or the databases that you use most often.', 'start': 296.723, 'duration': 4.944}, {'end': 306.309, 'text': "Okay, to get started, let's go back up to blank database and let's click on this.", 'start': 302.327, 'duration': 3.982}, {'end': 311.652, 'text': 'This opens up a dialog where we can type in a file name for this database.', 'start': 306.809, 'duration': 4.843}], 'summary': 'A tool provides templates and database search, enabling quick access and time-saving. it offers a pin feature for favorite databases.', 'duration': 40.203, 'max_score': 271.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc271449.jpg'}], 'start': 112.748, 'title': 'Database management and data limitations in excel and microsoft access', 'summary': "Delves into the limitations of excel in handling large datasets, focusing on its restriction to just over 1 million rows of data and its inability to manage larger datasets. it also explores the potential for extracting insights using excel's query, filtering, and pivot table features. additionally, it discusses the limitations of microsoft access for mid-sized and large companies, the fundamentals of database design using microsoft access, and the step-by-step process of creating a database, including adding fields and data types, with a focus on tracking customer information for the kevin cookie company.", 'chapters': [{'end': 147.421, 'start': 112.748, 'title': 'Database management and data limitations', 'summary': "Discusses the limitations of excel for managing large datasets, highlighting its restriction to just over 1 million rows of data and the inability to handle larger datasets. it also mentions the potential for extracting insights from the data using excel's query, filtering, and pivot table features.", 'duration': 34.673, 'highlights': ["Excel's limitation to just over 1 million rows of data, restricting its ability to handle larger datasets.", "The potential for extracting insights from data using Excel's query, filtering, and pivot table features."]}, {'end': 529.676, 'start': 147.421, 'title': 'Microsoft access for database management', 'summary': 'Discusses the limitations of microsoft access for mid-sized and large companies, the fundamentals of database design using microsoft access, and the step-by-step process of creating a database, including adding fields and data types, with a focus on tracking customer information for the kevin cookie company.', 'duration': 382.255, 'highlights': ['Microsoft Access limitations for mid-sized and large companies', 'Fundamentals of database design using Microsoft Access', 'Step-by-step process of creating a database using Microsoft Access']}], 'duration': 416.928, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc112748.jpg', 'highlights': ["Excel's limitation to just over 1 million rows of data, restricting its ability to handle larger datasets.", "The potential for extracting insights from data using Excel's query, filtering, and pivot table features.", 'Microsoft Access limitations for mid-sized and large companies', 'Fundamentals of database design using Microsoft Access', 'Step-by-step process of creating a database using Microsoft Access']}, {'end': 993.785, 'segs': [{'end': 560.855, 'src': 'embed', 'start': 529.816, 'weight': 0, 'content': [{'end': 533.959, 'text': "So here I'll click over here and instead of going with short text, I'll go with long text.", 'start': 529.816, 'duration': 4.143}, {'end': 536.301, 'text': "And for this field, I'll call it notes.", 'start': 534.559, 'duration': 1.742}, {'end': 541.424, 'text': 'This should now include all of the different fields that we want to include as part of this customer table.', 'start': 536.901, 'duration': 4.523}, {'end': 546.668, 'text': "Now that we've entered in all of the different fields, I want to show you how you can go back and make edits to these.", 'start': 541.764, 'duration': 4.904}, {'end': 550.971, 'text': "So let's say you enter something in, but maybe you screwed something up or you want to change the text.", 'start': 546.708, 'duration': 4.263}, {'end': 555.553, 'text': 'Right here, I can click on one of these field headers and you can very quickly update the text.', 'start': 551.511, 'duration': 4.042}, {'end': 560.855, 'text': 'Also, when I click on one of these field headers right up here, that opens up the fields ribbon.', 'start': 556.153, 'duration': 4.702}], 'summary': 'Demonstrating how to enter and edit various fields in the customer table.', 'duration': 31.039, 'max_score': 529.816, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc529816.jpg'}, {'end': 636.93, 'src': 'heatmap', 'start': 595.306, 'weight': 0.822, 'content': [{'end': 600.451, 'text': 'So all types of different actions I can take to make sure that the table has the structure that I want it to have.', 'start': 595.306, 'duration': 5.145}, {'end': 604.133, 'text': "Now that we've gone through and we've created all of our different fields,", 'start': 601.032, 'duration': 3.101}, {'end': 608.915, 'text': 'I want to show you a quick way where you can look at your fields and also modify the different data types.', 'start': 604.133, 'duration': 4.782}, {'end': 616.417, 'text': "Down here in the bottom right hand corner, you can enter what's called the design view, and when I click on that, first I have to name my table.", 'start': 609.495, 'duration': 6.922}, {'end': 619.438, 'text': "Right now it's table one, but I want it to be more descriptive.", 'start': 616.477, 'duration': 2.961}, {'end': 624.14, 'text': "Once again, this is tracking customer information, so I'll call this table customers.", 'start': 619.578, 'duration': 4.562}, {'end': 627.002, 'text': 'Once you finish typing in the name, click on OK.', 'start': 624.66, 'duration': 2.342}, {'end': 632.186, 'text': 'This now drops me into the design view, and here again I can see all of the different field names.', 'start': 627.342, 'duration': 4.844}, {'end': 634.408, 'text': 'You can also add field names here.', 'start': 632.486, 'duration': 1.922}, {'end': 636.93, 'text': 'This is a pretty quick way to add additional fields.', 'start': 634.428, 'duration': 2.502}], 'summary': 'Demonstration of modifying table structure and adding fields in design view.', 'duration': 41.624, 'max_score': 595.306, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc595306.jpg'}, {'end': 632.186, 'src': 'embed', 'start': 601.032, 'weight': 3, 'content': [{'end': 604.133, 'text': "Now that we've gone through and we've created all of our different fields,", 'start': 601.032, 'duration': 3.101}, {'end': 608.915, 'text': 'I want to show you a quick way where you can look at your fields and also modify the different data types.', 'start': 604.133, 'duration': 4.782}, {'end': 616.417, 'text': "Down here in the bottom right hand corner, you can enter what's called the design view, and when I click on that, first I have to name my table.", 'start': 609.495, 'duration': 6.922}, {'end': 619.438, 'text': "Right now it's table one, but I want it to be more descriptive.", 'start': 616.477, 'duration': 2.961}, {'end': 624.14, 'text': "Once again, this is tracking customer information, so I'll call this table customers.", 'start': 619.578, 'duration': 4.562}, {'end': 627.002, 'text': 'Once you finish typing in the name, click on OK.', 'start': 624.66, 'duration': 2.342}, {'end': 632.186, 'text': 'This now drops me into the design view, and here again I can see all of the different field names.', 'start': 627.342, 'duration': 4.844}], 'summary': "Demonstrating how to modify and view fields in design view, naming table 'customers'.", 'duration': 31.154, 'max_score': 601.032, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc601032.jpg'}, {'end': 722.103, 'src': 'embed', 'start': 697.026, 'weight': 1, 'content': [{'end': 702.068, 'text': "So every time you go through and you add a new record, it'll automatically get an ID assigned to it.", 'start': 697.026, 'duration': 5.042}, {'end': 707.689, 'text': "As a quick note on this ID, this is also what's referred to as the primary key.", 'start': 702.388, 'duration': 5.301}, {'end': 712.494, 'text': 'And what is a primary key? Well, this is a unique identifier.', 'start': 708.229, 'duration': 4.265}, {'end': 718.5, 'text': 'So basically every single customer record that we add to this table will have its own unique identifier.', 'start': 712.614, 'duration': 5.886}, {'end': 722.103, 'text': 'So no other customer will have the same ID as me.', 'start': 718.9, 'duration': 3.203}], 'summary': 'Automatically assigned unique ids for customer records.', 'duration': 25.077, 'max_score': 697.026, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc697026.jpg'}, {'end': 845.675, 'src': 'heatmap', 'start': 782.087, 'weight': 0.796, 'content': [{'end': 786.21, 'text': "To add another table, let's go back up to the top ribbon and let's click on create.", 'start': 782.087, 'duration': 4.123}, {'end': 788.913, 'text': 'Right over here, we can create a new table.', 'start': 786.751, 'duration': 2.162}, {'end': 790.594, 'text': "I'll click on the one that says table.", 'start': 789.073, 'duration': 1.521}, {'end': 794.696, 'text': 'This drops us into a new table and just like before, we need to build this out.', 'start': 790.874, 'duration': 3.822}, {'end': 799.298, 'text': 'Right up here, the first field is called ID and I want this to be more descriptive.', 'start': 795.156, 'duration': 4.142}, {'end': 803.88, 'text': "I'll double click on this just like we did before and this time I'll call it order ID.", 'start': 799.718, 'duration': 4.162}, {'end': 808.062, 'text': "For the next field, I want to tie this back to the customer's table.", 'start': 804.18, 'duration': 3.882}, {'end': 811.384, 'text': 'Once again, this is one of the big benefits of databases.', 'start': 808.522, 'duration': 2.862}, {'end': 815.746, 'text': 'You can relate information so you could connect one table to another table.', 'start': 811.464, 'duration': 4.282}, {'end': 820.85, 'text': "So here I'll click on tab and for this field, I want it to be a number data type.", 'start': 816.266, 'duration': 4.584}, {'end': 824.013, 'text': "I'll click on number and now I can type in a field name.", 'start': 821.311, 'duration': 2.702}, {'end': 827.016, 'text': "For this one, I'm going to type in customer ID.", 'start': 824.414, 'duration': 2.602}, {'end': 830.479, 'text': "We're going to connect based on that primary key from the previous table.", 'start': 827.316, 'duration': 3.163}, {'end': 832.401, 'text': 'I want to add a few more fields.', 'start': 830.72, 'duration': 1.681}, {'end': 837.166, 'text': 'For this one, I want to include the order date and a date is a date and time.', 'start': 832.601, 'duration': 4.565}, {'end': 840.429, 'text': "I'll select that as the data type and here I'll type in order date.", 'start': 837.186, 'duration': 3.243}, {'end': 845.675, 'text': "I'll add another field for cookies ordered and this is going to be a number data type.", 'start': 840.669, 'duration': 5.006}], 'summary': 'Creating a new table with fields like order id, customer id, order date, and cookies ordered.', 'duration': 63.588, 'max_score': 782.087, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc782087.jpg'}, {'end': 955.101, 'src': 'heatmap', 'start': 858.689, 'weight': 0.785, 'content': [{'end': 860.01, 'text': 'This is basically so.', 'start': 858.689, 'duration': 1.321}, {'end': 866.996, 'text': "our warehouse staff can go in and indicate whether the order has been fulfilled or if it's unfulfilled and they still have to package it and ship it.", 'start': 860.01, 'duration': 6.986}, {'end': 872.16, 'text': "Here I'll click on this field and right down here there's the option for yes, no.", 'start': 867.436, 'duration': 4.724}, {'end': 874.202, 'text': "So if they say yes, it's already been shipped.", 'start': 872.481, 'duration': 1.721}, {'end': 875.443, 'text': "If not, it hasn't.", 'start': 874.402, 'duration': 1.041}, {'end': 877.565, 'text': "And I'll call this field order filled.", 'start': 875.763, 'duration': 1.802}, {'end': 880.067, 'text': 'Lastly, I want to add one more field.', 'start': 877.945, 'duration': 2.122}, {'end': 883.15, 'text': 'However, this one is going to be a little bit different.', 'start': 880.167, 'duration': 2.983}, {'end': 886.473, 'text': 'This is going to contain the revenue per cookie.', 'start': 883.57, 'duration': 2.903}, {'end': 890.737, 'text': 'And we have all of the information stored within here to be able to calculate that.', 'start': 886.873, 'duration': 3.864}, {'end': 894.861, 'text': "Here I'll have the revenue and I'll also have the number of cookies ordered.", 'start': 891.157, 'duration': 3.704}, {'end': 898.945, 'text': "So right here, let's click on this dropdown where we can select the data type.", 'start': 895.462, 'duration': 3.483}, {'end': 901.488, 'text': 'And this is going to be a calculated field.', 'start': 899.325, 'duration': 2.163}, {'end': 903.589, 'text': "We'll see in a moment what this does.", 'start': 902.028, 'duration': 1.561}, {'end': 908.431, 'text': "Right down here, let's go down to calculated field and revenue per cookie, that's going to be a number.", 'start': 903.749, 'duration': 4.682}, {'end': 910.172, 'text': "So let's select the number data type.", 'start': 908.492, 'duration': 1.68}, {'end': 915.876, 'text': 'This opens up an expression builder in Access and you can build all types of different expressions.', 'start': 910.333, 'duration': 5.543}, {'end': 919.177, 'text': "One way to think of it is it's kind of like entering in a formula.", 'start': 916.036, 'duration': 3.141}, {'end': 922.359, 'text': 'Now, once again, I want to calculate the revenue per cookie.', 'start': 919.618, 'duration': 2.741}, {'end': 925.701, 'text': 'So down here, I see some of the expression categories.', 'start': 922.719, 'duration': 2.982}, {'end': 932.125, 'text': "I'll take the revenue and when I double click on that you see it inserts revenue here and I want to divide by the cookies ordered.", 'start': 926.121, 'duration': 6.004}, {'end': 936.688, 'text': "So I'll enter the divide sign and then right down here I'll click on cookies ordered.", 'start': 932.305, 'duration': 4.383}, {'end': 939.149, 'text': "So I'm going to take the revenue divided by the cookies ordered.", 'start': 936.728, 'duration': 2.421}, {'end': 940.37, 'text': 'That looks good.', 'start': 939.729, 'duration': 0.641}, {'end': 941.951, 'text': "Next let's click on OK.", 'start': 940.57, 'duration': 1.381}, {'end': 946.534, 'text': 'This drops me back into the table view and now I can type in a name for the field.', 'start': 942.211, 'duration': 4.323}, {'end': 948.535, 'text': "For this one I'll type in revenue per cookie.", 'start': 946.594, 'duration': 1.941}, {'end': 951.137, 'text': 'I can now fill in some order details.', 'start': 948.815, 'duration': 2.322}, {'end': 955.101, 'text': 'So over here for the first customer, this will be Kevin who orders some cookies.', 'start': 951.197, 'duration': 3.904}], 'summary': 'Staff tracks order fulfillment, adds revenue per cookie field for calculations.', 'duration': 96.412, 'max_score': 858.689, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc858689.jpg'}, {'end': 966.411, 'src': 'embed', 'start': 936.728, 'weight': 2, 'content': [{'end': 939.149, 'text': "So I'm going to take the revenue divided by the cookies ordered.", 'start': 936.728, 'duration': 2.421}, {'end': 940.37, 'text': 'That looks good.', 'start': 939.729, 'duration': 0.641}, {'end': 941.951, 'text': "Next let's click on OK.", 'start': 940.57, 'duration': 1.381}, {'end': 946.534, 'text': 'This drops me back into the table view and now I can type in a name for the field.', 'start': 942.211, 'duration': 4.323}, {'end': 948.535, 'text': "For this one I'll type in revenue per cookie.", 'start': 946.594, 'duration': 1.941}, {'end': 951.137, 'text': 'I can now fill in some order details.', 'start': 948.815, 'duration': 2.322}, {'end': 955.101, 'text': 'So over here for the first customer, this will be Kevin who orders some cookies.', 'start': 951.197, 'duration': 3.904}, {'end': 960.906, 'text': 'Now if you remember back on the customers table, customer ID 1 is for Kevin.', 'start': 955.541, 'duration': 5.365}, {'end': 966.411, 'text': "So right back here in my order table, I'll type in customer ID number 1.", 'start': 961.066, 'duration': 5.345}], 'summary': 'Calculating revenue per cookie by dividing revenue by cookies ordered.', 'duration': 29.683, 'max_score': 936.728, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc936728.jpg'}], 'start': 529.816, 'title': 'Database table creation and modification', 'summary': 'Covers creating and modifying a customer table, adding and modifying fields, changing data types, and understanding primary keys. it also demonstrates the creation of database tables for customer and order information, including adding fields and entering customer and order details.', 'chapters': [{'end': 737.014, 'start': 529.816, 'title': 'Creating and modifying customer table', 'summary': 'Explains how to create and modify a customer table, including adding and modifying fields, changing data types, and understanding primary keys for unique identifiers.', 'duration': 207.198, 'highlights': ['The chapter explains how to create and modify a customer table', 'Understanding primary keys for unique identifiers', 'Adding and modifying fields, changing data types']}, {'end': 993.785, 'start': 737.554, 'title': 'Database table creation and data entry', 'summary': 'Covers the creation of database tables for customer and order information, including adding fields such as customer id, order date, cookies ordered, revenue, and order filled, with a demonstration of entering customer and order details.', 'duration': 256.231, 'highlights': ['Demonstration of adding fields to a new table for customer and order information', 'Explanation of connecting tables using primary key', 'Calculation of revenue per cookie using a calculated field']}], 'duration': 463.969, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc529816.jpg', 'highlights': ['Demonstration of adding fields to a new table for customer and order information', 'Understanding primary keys for unique identifiers', 'Adding and modifying fields, changing data types', 'Calculation of revenue per cookie using a calculated field', 'The chapter explains how to create and modify a customer table']}, {'end': 1437.859, 'segs': [{'end': 1121.784, 'src': 'heatmap', 'start': 1041.005, 'weight': 0.781, 'content': [{'end': 1047.867, 'text': "Now one of the great things about creating a database, here you'll see with the customer ID I don't have to repeat the customer information.", 'start': 1041.005, 'duration': 6.862}, {'end': 1054.009, 'text': 'I simply have to reference that ID and then for this order I can fetch all of the customer information.', 'start': 1048.287, 'duration': 5.722}, {'end': 1060.033, 'text': 'However, first off, I have to connect this customer ID to the customer table over here.', 'start': 1054.469, 'duration': 5.564}, {'end': 1064.877, 'text': "How do we do that? Well, up at the top, let's go up to database tools on the ribbon.", 'start': 1060.494, 'duration': 4.383}, {'end': 1067.96, 'text': "Once we click on that, there's an option for relationships.", 'start': 1065.498, 'duration': 2.462}, {'end': 1068.88, 'text': "Let's click on this.", 'start': 1068.16, 'duration': 0.72}, {'end': 1073.744, 'text': 'Within relationships, I can define how different tables relate to one another.', 'start': 1069.281, 'duration': 4.463}, {'end': 1076.766, 'text': 'And over on the right hand side, I see all of my tables.', 'start': 1074.184, 'duration': 2.582}, {'end': 1077.967, 'text': 'I have two tables.', 'start': 1076.946, 'duration': 1.021}, {'end': 1080.91, 'text': "I'll click on customers and I'll pull that into this view.", 'start': 1078.368, 'duration': 2.542}, {'end': 1084.953, 'text': "Next, let's go over to orders, click on that and pull that over as well.", 'start': 1081.63, 'duration': 3.323}, {'end': 1090.739, 'text': 'So here now I see my two tables and you can see all of the fields in those two different tables.', 'start': 1085.554, 'duration': 5.185}, {'end': 1096.906, 'text': 'Right up here you can see a key icon and that indicates what the primary key is in that table.', 'start': 1091.32, 'duration': 5.586}, {'end': 1103.49, 'text': 'Now here I have the customer ID in my orders table and I also have the customer ID in my customers table.', 'start': 1097.506, 'duration': 5.984}, {'end': 1110.375, 'text': "Now I can simply click on the customer ID and I'll drag that over to the customer ID over in the orders table.", 'start': 1104.031, 'duration': 6.344}, {'end': 1113.718, 'text': 'That opens up a prompt where I can edit the relationship.', 'start': 1111.016, 'duration': 2.702}, {'end': 1121.784, 'text': "So here I'm saying that this value or this field in the customer table is the same as this field in the orders table.", 'start': 1114.098, 'duration': 7.686}], 'summary': 'Creating a database allows for easy access to customer information by connecting tables using relationships.', 'duration': 80.779, 'max_score': 1041.005, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1041005.jpg'}, {'end': 1073.744, 'src': 'embed', 'start': 1048.287, 'weight': 1, 'content': [{'end': 1054.009, 'text': 'I simply have to reference that ID and then for this order I can fetch all of the customer information.', 'start': 1048.287, 'duration': 5.722}, {'end': 1060.033, 'text': 'However, first off, I have to connect this customer ID to the customer table over here.', 'start': 1054.469, 'duration': 5.564}, {'end': 1064.877, 'text': "How do we do that? Well, up at the top, let's go up to database tools on the ribbon.", 'start': 1060.494, 'duration': 4.383}, {'end': 1067.96, 'text': "Once we click on that, there's an option for relationships.", 'start': 1065.498, 'duration': 2.462}, {'end': 1068.88, 'text': "Let's click on this.", 'start': 1068.16, 'duration': 0.72}, {'end': 1073.744, 'text': 'Within relationships, I can define how different tables relate to one another.', 'start': 1069.281, 'duration': 4.463}], 'summary': 'Reference id to fetch customer info and establish table relationships using database tools.', 'duration': 25.457, 'max_score': 1048.287, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1048287.jpg'}, {'end': 1253.645, 'src': 'heatmap', 'start': 1139.191, 'weight': 0.757, 'content': [{'end': 1141.792, 'text': 'This opens up a prompt to save the relationships.', 'start': 1139.191, 'duration': 2.601}, {'end': 1142.612, 'text': "I'll click on yes.", 'start': 1141.892, 'duration': 0.72}, {'end': 1148.204, 'text': 'Along with manually entering in data into your database, you can also import it from other sources.', 'start': 1143.081, 'duration': 5.123}, {'end': 1151.587, 'text': "Right up here on the ribbon, there's the option for external data.", 'start': 1148.685, 'duration': 2.902}, {'end': 1157.311, 'text': 'When we click on this over on the left hand side, you can see all the different places that you can bring data in from.', 'start': 1152.007, 'duration': 5.304}, {'end': 1162.214, 'text': 'For example, you can bring it in from a file, from a database, from different online services.', 'start': 1157.691, 'duration': 4.523}, {'end': 1166.537, 'text': 'So there are lots of different ways that you can get data into Microsoft Access.', 'start': 1162.554, 'duration': 3.983}, {'end': 1174.821, 'text': "So far, we've been entering data directly into the table view, but let's say you want to have other people in your organization come in and add data.", 'start': 1167.117, 'duration': 7.704}, {'end': 1177.342, 'text': 'This might not be the most user-friendly view.', 'start': 1175.261, 'duration': 2.081}, {'end': 1180.523, 'text': 'Instead, you might want to create a form that makes that easier.', 'start': 1177.482, 'duration': 3.041}, {'end': 1184.005, 'text': "Over on the left hand side, I'll select the customer table.", 'start': 1181.223, 'duration': 2.782}, {'end': 1189.828, 'text': "Right up here let's click on create on the ribbon and right here in the middle there's a section for forms.", 'start': 1184.705, 'duration': 5.123}, {'end': 1196.531, 'text': 'This will help us create a form for data entry and you could also use it to review the different records that are in your tables.', 'start': 1190.248, 'duration': 6.283}, {'end': 1199.452, 'text': "There's a form wizard that'll help you through the process.", 'start': 1197.131, 'duration': 2.321}, {'end': 1200.853, 'text': 'You could also start from blank.', 'start': 1199.532, 'duration': 1.321}, {'end': 1203.755, 'text': "There's a form designer or you could simply create a form.", 'start': 1200.933, 'duration': 2.822}, {'end': 1208.377, 'text': "This is going to be the easiest way to create a pretty effective form so I'll click on form right here.", 'start': 1204.255, 'duration': 4.122}, {'end': 1214.201, 'text': 'This now drops me into a new form and down below I can see a sample of what the form looks like.', 'start': 1208.957, 'duration': 5.244}, {'end': 1220.545, 'text': 'So this will be a lot easier for others to come into and start adding information and they can also use it to review information.', 'start': 1214.241, 'duration': 6.304}, {'end': 1225.028, 'text': 'Now, because we connected the customer table to the orders table.', 'start': 1221.206, 'duration': 3.822}, {'end': 1227.49, 'text': "you'll see here all of the customer information.", 'start': 1225.028, 'duration': 2.462}, {'end': 1229.051, 'text': 'shows up and down below.', 'start': 1227.49, 'duration': 1.561}, {'end': 1231.613, 'text': 'it has all of the related order information.', 'start': 1229.051, 'duration': 2.562}, {'end': 1235.215, 'text': 'So here if I jump through the different records, here I could go to the next record.', 'start': 1232.193, 'duration': 3.022}, {'end': 1240.257, 'text': 'Here I see Cheryl as my second customer and she has two orders associated with her.', 'start': 1235.275, 'duration': 4.982}, {'end': 1243.459, 'text': 'Right up on top, I can design what my form looks like.', 'start': 1240.618, 'duration': 2.841}, {'end': 1245.2, 'text': 'So I can choose different themes.', 'start': 1243.539, 'duration': 1.661}, {'end': 1246.381, 'text': 'I could choose different colors.', 'start': 1245.28, 'duration': 1.101}, {'end': 1249.142, 'text': 'I can add different controls to my form.', 'start': 1246.781, 'duration': 2.361}, {'end': 1253.645, 'text': 'I can even add a logo if I wanted to personalize it with the Kevin Cookie Company logo.', 'start': 1249.463, 'duration': 4.182}], 'summary': 'Microsoft access allows importing data from various sources, creating user-friendly forms for data entry and review, and customizing form appearance and controls.', 'duration': 114.454, 'max_score': 1139.191, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1139191.jpg'}, {'end': 1366.304, 'src': 'embed', 'start': 1340.178, 'weight': 0, 'content': [{'end': 1344.86, 'text': "And in a moment, I'll show you how you can run and also write your very own query.", 'start': 1340.178, 'duration': 4.682}, {'end': 1348.882, 'text': "To create a query, let's go up to the top ribbon and click on create.", 'start': 1345.5, 'duration': 3.382}, {'end': 1353.727, 'text': 'Within create right here near the middle, there are two different options for queries.', 'start': 1349.562, 'duration': 4.165}, {'end': 1358.794, 'text': "You can use the query wizard and there's also something called query design.", 'start': 1354.228, 'duration': 4.566}, {'end': 1360.737, 'text': "We're going to use query design.", 'start': 1359.215, 'duration': 1.522}, {'end': 1365.262, 'text': "You'd be amazed at how many advanced queries I've written using query design.", 'start': 1360.877, 'duration': 4.385}, {'end': 1366.304, 'text': "Let's click into this.", 'start': 1365.463, 'duration': 0.841}], 'summary': 'Learn to create queries using query design in the software tool.', 'duration': 26.126, 'max_score': 1340.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1340178.jpg'}], 'start': 993.925, 'title': 'Database table management and data entry in microsoft access', 'summary': 'Discusses creating and managing tables in a database using access, including adding sample data and establishing relationships, as well as covering importing data, creating forms for data entry, and designing queries in microsoft access.', 'chapters': [{'end': 1134.689, 'start': 993.925, 'title': 'Database table management', 'summary': 'Discusses creating and managing tables in a database using access, including adding sample data and establishing relationships between tables.', 'duration': 140.764, 'highlights': ['The chapter discusses creating and managing tables in a database using Access, including adding sample data and establishing relationships between tables.', 'It explains how to add sample data to the tables, avoiding repetitive customer information by referencing the customer ID, and establishing relationships between tables.', 'The process of defining relationships between tables is explained, including pulling tables into the view, identifying primary keys, and editing the relationships to connect specific fields.']}, {'end': 1437.859, 'start': 1135.349, 'title': 'Data entry and form creation in microsoft access', 'summary': 'Covers importing data, creating forms for data entry, and designing queries in microsoft access, emphasizing the ease of form creation and the use of query design for advanced queries.', 'duration': 302.51, 'highlights': ['The form creation in Microsoft Access allows for easy data entry and information review, with the ability to personalize the form using different themes, colors, and controls.', 'The chapter emphasizes the ease of using query design for building advanced queries, showcasing its drag-and-drop interface for adding tables and specifying relationships.', 'Microsoft Access provides various options for importing data from other sources, such as files, databases, and online services, offering flexibility in data acquisition.', 'The process of creating a form in Microsoft Access involves selecting a table, using form wizards or starting from blank, and customizing the form layout and design for user-friendly data entry and review.', 'The form view in Microsoft Access allows users to see the customer information and fill out the form without modifying it, simplifying the process for data entry and adding new records.']}], 'duration': 443.934, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc993925.jpg', 'highlights': ['The chapter discusses creating and managing tables in a database using Access, including adding sample data and establishing relationships between tables.', 'Microsoft Access provides various options for importing data from other sources, such as files, databases, and online services, offering flexibility in data acquisition.', 'The form creation in Microsoft Access allows for easy data entry and information review, with the ability to personalize the form using different themes, colors, and controls.', 'The process of defining relationships between tables is explained, including pulling tables into the view, identifying primary keys, and editing the relationships to connect specific fields.', 'The chapter emphasizes the ease of using query design for building advanced queries, showcasing its drag-and-drop interface for adding tables and specifying relationships.']}, {'end': 1624.4, 'segs': [{'end': 1550.514, 'src': 'heatmap', 'start': 1509.975, 'weight': 0, 'content': [{'end': 1516.939, 'text': "Over on the far right hand side, I see order filled and for this one, I'm going to enter an equal sign and then type in no.", 'start': 1509.975, 'duration': 6.964}, {'end': 1519.701, 'text': "So this means that the order hasn't been filled yet.", 'start': 1517.419, 'duration': 2.282}, {'end': 1522.562, 'text': 'So right now I have my query in place.', 'start': 1520.241, 'duration': 2.321}, {'end': 1526.525, 'text': 'Down in the bottom right hand corner, I can click on the datasheet view.', 'start': 1523.283, 'duration': 3.242}, {'end': 1528.506, 'text': "Let's click on this to see what the results are.", 'start': 1526.585, 'duration': 1.921}, {'end': 1532.807, 'text': "When I click into the datasheet view, look at that, that's our first query.", 'start': 1528.846, 'duration': 3.961}, {'end': 1541.05, 'text': "So here it returns all of the different fields that I selected and it also only returns all of the options where the order hasn't been filled yet.", 'start': 1533.167, 'duration': 7.883}, {'end': 1543.251, 'text': 'Now one of the really neat things is here.', 'start': 1541.51, 'duration': 1.741}, {'end': 1550.514, 'text': "now I'm merging together customer information, so data from the customers table together with data from the orders table.", 'start': 1543.251, 'duration': 7.263}], 'summary': 'Demonstrating query results and data merging in datasheet view.', 'duration': 40.539, 'max_score': 1509.975, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1509975.jpg'}], 'start': 1438.34, 'title': 'Managing warehouse orders and sql queries', 'summary': 'Involves extracting customer information and order date for warehouse orders. it also demonstrates creating sql queries to retrieve unfilled orders and merging customer and order data, showcasing the potential for advanced queries.', 'chapters': [{'end': 1472.513, 'start': 1438.34, 'title': 'Warehouse order information', 'summary': 'Involves extracting customer information such as first name, last name, address, city, state, zip, and country, as well as order date for sending an order to the warehouse crew.', 'duration': 34.173, 'highlights': ['Extracting customer information such as first name, last name, address, city, state, zip, and country for sending an order to the warehouse crew.', 'The warehouse crew also needs to know the order date for processing the order.']}, {'end': 1624.4, 'start': 1473.074, 'title': 'Creating and analyzing sql queries', 'summary': 'Demonstrates using a graphical user interface to create a query to retrieve unfilled orders, merging customer and order data, and then delves into the actual sql query used, showcasing the process and its potential for advanced queries.', 'duration': 151.326, 'highlights': ['The chapter demonstrates using a graphical user interface to create a query for retrieving unfilled orders, merging customer and order data, and then delves into the actual SQL query used, showcasing the process and its potential for advanced queries.', "The SQL query is shown, selecting specific fields from the customers table and joining it with the orders table based on the customer ID, with the criteria of orders filled equals 'no'.", "The demonstration also includes filtering the retrieved data to show only the orders that haven't been filled yet, providing a practical example of using criteria as a filter for one of the fields."]}], 'duration': 186.06, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1438340.jpg', 'highlights': ['The chapter demonstrates using a graphical user interface to create a query for retrieving unfilled orders, merging customer and order data, and then delves into the actual SQL query used, showcasing the process and its potential for advanced queries.', "The SQL query is shown, selecting specific fields from the customers table and joining it with the orders table based on the customer ID, with the criteria of orders filled equals 'no'.", "The demonstration also includes filtering the retrieved data to show only the orders that haven't been filled yet, providing a practical example of using criteria as a filter for one of the fields.", 'Extracting customer information such as first name, last name, address, city, state, zip, and country for sending an order to the warehouse crew.', 'The warehouse crew also needs to know the order date for processing the order.']}, {'end': 1852.607, 'segs': [{'end': 1650.046, 'src': 'embed', 'start': 1625.2, 'weight': 5, 'content': [{'end': 1630.921, 'text': "Now that we've finished entering in our query, let's go up here and let's close out this view and I want to save this query.", 'start': 1625.2, 'duration': 5.721}, {'end': 1634.222, 'text': "So I'll click on yes and we're going to call this unfilled orders.", 'start': 1630.941, 'duration': 3.281}, {'end': 1636.843, 'text': "Once you're done typing in the name, click on OK.", 'start': 1634.662, 'duration': 2.181}, {'end': 1642.984, 'text': "Over on the left hand side, you'll see a new category now for queries and this shows our unfilled orders.", 'start': 1637.183, 'duration': 5.801}, {'end': 1650.046, 'text': 'So if you want to quickly see all unfilled orders again, you can simply double click on that and right now I have a view of all the unfilled orders.', 'start': 1643.044, 'duration': 7.002}], 'summary': "Created 'unfilled orders' query and saved for easy access.", 'duration': 24.846, 'max_score': 1625.2, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1625200.jpg'}, {'end': 1813.484, 'src': 'embed', 'start': 1790.544, 'weight': 3, 'content': [{'end': 1798.011, 'text': 'This gives you all of the basics, to start building out your own databases, to run queries, to create forms, and even to run reports.', 'start': 1790.544, 'duration': 7.467}, {'end': 1800.453, 'text': "Of course, there's a lot that you can customize.", 'start': 1798.371, 'duration': 2.082}, {'end': 1804.356, 'text': "There's a lot of advanced functionality, but this gives you all of the basics.", 'start': 1800.493, 'duration': 3.863}, {'end': 1808.04, 'text': 'The last item I want to show you is how you can save your database.', 'start': 1804.797, 'duration': 3.243}, {'end': 1813.484, 'text': 'To save, up in the top left-hand corner, click on the File menu and then go down to Save As.', 'start': 1808.44, 'duration': 5.044}], 'summary': 'Learn basics of creating databases, running queries, and saving files.', 'duration': 22.94, 'max_score': 1790.544, 'thumbnail': ''}, {'end': 1852.607, 'src': 'embed', 'start': 1849.305, 'weight': 0, 'content': [{'end': 1852.147, 'text': 'I hope you enjoyed, and as always, I hope to see you next time.', 'start': 1849.305, 'duration': 2.842}, {'end': 1852.607, 'text': 'Bye.', 'start': 1852.427, 'duration': 0.18}], 'summary': 'Closing remarks, expressing hope for future engagements. no quantifiable data.', 'duration': 3.302, 'max_score': 1849.305, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1849305.jpg'}], 'start': 1625.2, 'title': 'Creating and viewing unfilled orders query and access database basics', 'summary': 'Demonstrates creating a query to view unfilled orders, promoting efficient order management, and also covers creating queries to track unfinished orders, customizable reports, and saving the database in microsoft access.', 'chapters': [{'end': 1660.83, 'start': 1625.2, 'title': 'Creating and viewing unfilled orders query', 'summary': 'Demonstrates how to create a query to view unfilled orders, allowing users to quickly access and monitor unfilled orders as new data is added, promoting efficient order management.', 'duration': 35.63, 'highlights': ["By creating a query named 'unfilled orders', users can efficiently view all unfilled orders by simply double clicking on the query, promoting quick access to important data.", 'New unfilled orders are immediately displayed on the query page when new customers and orders are added, promoting real-time monitoring and efficient order management.', "Saving the query and naming it 'unfilled orders' creates a new category for queries, providing organized access to specific queries for easy reference and management."]}, {'end': 1852.607, 'start': 1661.17, 'title': 'Access database basics', 'summary': 'Covers creating queries to track unfinished orders, creating customizable reports, and offers guidance on saving the database in microsoft access, providing a comprehensive overview of the fundamental functionalities.', 'duration': 191.437, 'highlights': ['Creating a report to display unfilled orders, allowing warehouse staff to easily view and print out a summary of unfilled orders, enhancing efficiency and workflow.', 'Guidance on saving the database as an Access database, providing a comprehensive overview of the fundamental functionalities and proficiency in designing databases.', 'Creating queries to track unfinished orders, enabling warehouse staff to immediately see all orders requiring attention, enhancing productivity and task management.']}], 'duration': 227.407, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/ubmwp8kbfPc/pics/ubmwp8kbfPc1625200.jpg', 'highlights': ['New unfilled orders are immediately displayed on the query page when new customers and orders are added, promoting real-time monitoring and efficient order management.', 'Creating a report to display unfilled orders, allowing warehouse staff to easily view and print out a summary of unfilled orders, enhancing efficiency and workflow.', 'Creating queries to track unfinished orders, enabling warehouse staff to immediately see all orders requiring attention, enhancing productivity and task management.', "By creating a query named 'unfilled orders', users can efficiently view all unfilled orders by simply double clicking on the query, promoting quick access to important data.", "Saving the query and naming it 'unfilled orders' creates a new category for queries, providing organized access to specific queries for easy reference and management.", 'Guidance on saving the database as an Access database, providing a comprehensive overview of the fundamental functionalities and proficiency in designing databases.']}], 'highlights': ['Microsoft Access is a relational database program for tracking customers, orders, and assets.', 'Illustrates the inefficiency of using Excel for tracking due to lack of data relationships.', "Excel's limitation to just over 1 million rows of data, restricting its ability to handle larger datasets.", "The potential for extracting insights from data using Excel's query, filtering, and pivot table features.", 'Demonstration of adding fields to a new table for customer and order information.', 'Understanding primary keys for unique identifiers.', 'The chapter discusses creating and managing tables in a database using Access, including adding sample data and establishing relationships between tables.', 'The process of defining relationships between tables is explained, including pulling tables into the view, identifying primary keys, and editing the relationships to connect specific fields.', 'The chapter demonstrates using a graphical user interface to create a query for retrieving unfilled orders, merging customer and order data, and then delves into the actual SQL query used, showcasing the process and its potential for advanced queries.', 'New unfilled orders are immediately displayed on the query page when new customers and orders are added, promoting real-time monitoring and efficient order management.', 'Creating a report to display unfilled orders, allowing warehouse staff to easily view and print out a summary of unfilled orders, enhancing efficiency and workflow.']}