Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
The first query we're going to make is called a Select Query. That means we'll want to see some but not all of the fields in the table. We'll use the Query Wizard to do this. To start, click on the Create tab, and then on Query Wizard. In the dialog box, we want a Simple Query Wizard. Click OK. So let's say you want to make a Phone List for your Sales Reps. Drop down the Table and choose SalesReps. Click on LastName and move it over, and FirstName and move it over, then HomePhone, CellPhone and Email. But wait.
Maybe you decide that you'd rather see the CellPhone first. Move these three over and then click on CellPhone, HomePhone and Email. Go ahead and click Next. Enter in the Query Name. We're going to change this to Sales Reps Phone List Query. It gives you the option to either run the Query or open it up in Design View to further edit it. We want to run it, so just click the Finish button.
You now have a complete list of all your Sales Reps and their contact information. You can double-click on the columns to resize them, and then let's close it and save it when it asks. Now, we see Queries with our Sales Reps Phone List Query on the Navigation Pane, and I can double-click on it to run it anytime to get a complete up-to-date list of my employees. Later, we can use this Query as the source to make a printed report.
The Query Wizard and Select Queries make it easy to pull out just the fields you want to see.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.