Join Robin Hunt for an in-depth discussion in this video Creating basic queries using tables, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- When you work with Access databases…that you either created yourself,…or you inherited, you might eventually…want to query the information for reporting.…Once you have your tables in place,…whether you linked them, imported them,…or manually created them,…you will begin to write your queries.…I want to show you how to create…just a standard select query.…Again, you want to plan out your queries…before you write them.…All right, we'll start by going to the Create tab,…and we'll go to the Query Design.…
For this example, I'm going to double click…Department List,…I'll double click Department List Names,…and then also the Zip Codes.…You probably already had the Access 2013…Essentials Course, where they covered relationships,…but here I have three tables,…and I actually need to create some relationships…in order to effectively report.…I'm going to left click and hold on Department,…and drag it to the Department Code.…I'm going to left click and hold on Zip Code,…and drag it to Zip Code in Zip Codes.…
Now, I'll double click on my department name,…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries
Skill Level Intermediate
Q: How do I open the exercise files?
A: Press and hold Shift when opening the exercise files for this course.
1. Understanding How to Use Excel and Access for a Solution
2. Building Tables in Excel and Access
3. Calculating Data in Excel and Access
4. Building Forms for Your Solution
Setting the database options2m 53s
5. Building Reports for Your Solution
6. Building Macros to Run Imports and Queries
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.