Every object and control in Microsoft Access has a set of properties that can be defined to give more control over the database's operation. When working with queries, there are properties at the field level as well as the query level. In this movie, Adam tours through the property sheet and gives a description of the most important values that can be altered.
- Every object in control in Microsoft Access has a set…of properties that can be defined to give you more…control over your database.…Queries and the fields within your queries are no exception.…By understanding the options available…within the query property sheets, you'll gain more…control over the queries that you can construct.…In this movie, we'll take a look at some of the properties…that we can control for each of the fields in our query…and we're gonna use the products with alias query…that we created in the last movie.…Let's go ahead and right click on it and we can choose…to open it straight into design view by choosing that option…from the popup menu.…
There's a couple of different ways that we can turn on…the property sheet, there's a button right up here…on the ribbon to turn on the property sheet or I can use…the alt enter shortcut key on my keyboard to turn it…on or off, or I can right click anywhere…and choose properties from the popup menu.…Now as you click around on the screen, you'll notice that…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- 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.