Access 2016 Introduction – Tables, Forms, Filters and Queries Video Tutorial

Access 2016 Introduction - Tables, Forms, Filters and Queries Video Tutorial

  This video is an introduction to Microsoft Access 2016. It assumes very little knowledge or prior use. I gives an introduction to the interface, how to use it for a company's data and then how to create and use Tables, Forms, Filters and Queries on the data.  
Transcript (machine generated so it contains errors)
 
Video is a short video about how to basically get into access if you haven't use it before you just use a little bit of as we know is a database and when you click on it, it opens up and opens up like this. Now, you might need to create a blank database. You might have one already ready or you might use a template. Okay, were gone. I use one that will have just created. But it's base of the blank database before we get into any depth of access will discreetly say this is the ribbon over here and basically these are the resources that you will have over here. If we need to the back and offered over here. For example, you go now when you start access with a blank database, you will not have any tables created. We have created one.


Okay, and will show you just quite simply, what were trying to do okay. How does access actually work. It looks a little bit low light, Excel and your creating different tables for different objects. Think of it like that. For example, customers. Okay, so all our customers can be in one table and our orders will be another table and for example, employees purchases, all those will be on separate separate tables. The idea behind action centre make inefficient is you don't retype all the data that you have in one table in another. For example, in an orders table, you would not be tight being bald okay, the customer name barbs may have his address, et cetera and then the items you purchase. Instead, all you will be using is a customer ID or an ID to the primary key over here again and in that table, we will insert this ID number and it'll be called a foreign key in the other table that saw Liz as a naming thing will now go ahead and show you how to create a simple table like this.


Okay, we got our customers going, let's create now a table okay and we will save it as orders so will click save changes that two orders, and we have here is a are to generate a number we can change them, but we are going to keep it as ordinary number will change the name to order ID okay and then for a first feel short text. What shall we say, okay, so for example, we might want to have our order ID now wondering in our customer ID, this is going to be linked to our customers. Okay, and were do not automatically populate that in a bit now. Over here we are gone, I'll show you. Basically the let's say arming order date. Okay, so give it a name at the top order date and then sipping a Brit living in simple okay, so does like Excel now you fill in the details. Okay, as I did mention we would want to have our customer ID basically linked. Okay, so we have a primary ID over here and we Wanna bring in the following key.


Okay, so basically this is going to be find yes next. The table will be customers next and is gonna be the customer ID next next and this is just the name of the field. The top so that's quite simple, and drive came over here, so he's right over there when we want to enter information. Okay, just like Excel. We enter information. This order ID will automatically generated over here for this case in over here work in a finer customer ID from our table. It will be we have customers. We know which ones they were okay. For example, if I want Bob to be the one who's ordering it customer ID is Bob order date. It gives me a nice little date shipping date and over here when were entering the data again, we get that so we have created one record. Now you have more fuels if you needed okay, so now of credit one record over here and I have my customers table. My orders table. I'm currently in my orders table okay for the close table disclose over there you have two views for tables. One is the datasheet view, which is like Excel 1 is basically where you just create the kind of feels that you want and what type they will be, and then you enter the data over here or you import the data into okay to create a form all you really need to do is go to create create form, you could use form design and all one. This is basically doing its creating collar based scenarios. Okay, now what happens is everything in this column will be the same with same height this one.


Same with same height, et cetera change that one were gonna try and do over here is basically reduced. This we could do in the properties field and doing over there will discuss try and bring a small as possible. Okay, what we want to do is create three buttons. Okay, our form automatically is generated, we could literally go through and it will literally show the different order which customer ID when the shipping date order date and all other data that we would create for normal real-world this is a sample okay, so abundant. All you do is go to design and make this another year, but in an you've clicked on button. Bring him over here. Okay, he will come there. Don't worry, that's fine, we'll bring him back again. So when I created a dollar. The next record got the last. The previous record and save data. Okay, so in navigation golfer who next next skim text next record, we could add pictures the button if you wanted to next and okay there we go ease over their now having another button. Let's bring in over here, he'll the previous record. Okay, it's text ago. Now if you need to add more on this side okay, you have to literally click over here and insert insert to our right because we are going the right of this, it adds another set: okay, now what I want to do is basically add woman but an, there. This is going to be a wrecker operation where it saves a record next. Okay there we go. So now I can go the next regard of sorry my mistake, this is basically the simple create, view, which is call a view. The form view is where you actually do use it. Okay, so next record exec electric an extra that bring us to know you can go any further I got the previous record. Okay, very go the next order dates. It literally uses the system that was an orders.


Okay, so it's basically giving calendar customer ID once again, which customers we were using shipping date. Okay, bad night, that's fine. In this system, how can you resize this column. Okay, or any: for example, okay, click on that click shift okay and then basically you can resize an individual column. Okay, so if I click save record. Okay, I should have a fourth record over here. Let's go to orders okay and refresh all its cred my fourth order now let's look at some basic filtering and create this little bit more advanced filter and savour the query I want to filter based on shall we say names in ascending okay, okay, now what I want to do is basically create a advanced filter which basically allows me to filter based on whatever my requirements. For example, I want to list all of them that have a last name there add starts with okay S. And this Asterix is a special key. This little star, which allows basically anything after it searches for that.


So now, if I was to run this apply filter and you'll see it's found all of my guesses. For now, I thing we've done enough with krill tables with great filters of graded forms and the last thing, and this can assure you it is basically this one I'm going to save it as a query, give it any name in this is honestly this query one. So that's how we can create a basic query. Our future videos should go into in-depth the individual different parts and in more detail. Hopefully this video has helped. Thank you for watching

Visit our YouTube channel: https://www.youtube.com/channel/UCFj1BHYIUYfPWPb1Xn5qFIg