This Access course is designed with busy business professionals in mind who do not have time to sit through an entire training course. With these quick clips, you can watch and learn a specific topic in less than 6 minutes, which is great if you are proficient with Access but just have forgotten how to do something.
Patricia Ciszek, Microsoft Office Instructor, has worked with the ONLC for over 15 years and has been creating video courseware with ClipTraining since 2011. She teaches expert level course content on Microsoft Office solutions.
Creating Queries In this lesson, let's take a look at creating a query using the simple query wizard. I'd like to see the current schedule we have and who's teaching the classes. So to do that, I'm going to go create a query. I'm going to click on Create, Query Wizard, and then it brings up the New Query dialog box. I'm going to have a Simple Query, so I'll click OK, and then it wants to know what table I'd like to use, I'm going to pull down that drop-down, and I'm going to go tblSchedule. I would like the CourseID, CourseDate, and the InstructorID. So putting the CourseID, CourseDate, InstructorID on the right. And then, from tblInstructors, I want to know who that is, so I'd like the FirstName and the LastName. Now I have all the fields I need, so down at the bottom right I'm going to choose Next, I'm going to change the name of that, I'm going to name it qry, again starting all my queries with a qry, CourseInstructor, so qryCourseInstructor. I'm going to choose Finish and then there's my query, which shows it like a datasheet with the CourseID, the Date, the InstructorID, and then who that is. One way to create a query is to use a simple query wizard and then choose the fields that you want to design your query. Thanks for watching, and I'll see you in the next clip.
Creating Forms In this lesson, let's take a look at creating a form. I'm going to go open tblInstructors, and notice again I have my instructor information here, as well as over here if I click on the plus I have the sub-datasheet showing the courses they teach. When I want to add a new instructor, I can add one down here on this row that says New, but instead of doing it that way, I'd like to create a form. A form in Access is used for data entry or editing records. So to create a form for this table, I'm going to go up to Create, Form, and take a look, it created that form for me automatically, here's my course IDs down here for the courses that this instructor teaches. And then if I go down here to the bottom and I click on the next record, I can see the next person as well. I would like to make a few changes to this in that I would like to change that title just to say Instructors. So I'm going to come here to Design View, and then when I get to Design View I can come in here and I can delete and just call it Instructors, and then what I'd like to do is save this. So I'm going to go to Save, it's going to ask me for a name, I'm going to change this to frmInstructors, and then I'll click OK, notice the name there. Let me just close this, I'll close this while I'm at it, and then let me scroll down here and take a look, the first form, frmInstructors. If I double-click on it, there's my form. So one way to create a form in Access is just open a table or query, and then go to Create Form and it'll generate a form with all those fields. Thanks for watching, and I'll see you in the next clip.