Join Adam Wilbert for an in-depth discussion in this video Exploring the field properties, part of Access 2007: Queries.
In the previous movie we took a look at how we can apply aliases to our column…headers to be a little bit more specific about the types of data that we're…returning in our queries.…Now, we can go into our qry_Products one more time and we can see the saved…aliases that we created in the last movie.…Now, I'm taking a look at our table here that's being returned by this query and…I'm noticing a few other areas that we can clean this up.…Let me go ahead and maximize this.…And let's take a look at retail price.…Now, I know this is supposed to represent a dollar value, but our decimals…are all over the place.…We've got 2 decimals here, we've got no decimals here, and we've even got values…that have only a single decimal.…
So I want to clean that up a little bit.…Same thing with Markup $, and Markup % actually has a different problem here.…Right now we're saying this as a percent, but it's written as a decimal fraction.…So for instance, we've got our Wholesale Cost of $10, our Retail Price is $15,…which represents 150% markup, but we're multiplying that by 1.5, so this the…
Author
Released
9/9/2010- Naming conventions and best practices
- Working with joins and primary keys
- Using comparison operators
- Printing query results
- Creating parameter queries
- Creating calculated fields
- Using the Expression Builder
- Making conditional statements
- Appending queries
- Updating queries
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2007: Shortcuts
with Alicia Katz Pollock3h 25m Intermediate -
Access: VBA
with Curt Frye4h 38m Advanced
-
Introduction
-
Welcome50s
-
-
1. Creating Queries in Access
-
Query basics5m 37s
-
Using the Query Wizard4m 8s
-
-
2. Creating Simple Select Queries
-
Comparison operators3m 42s
-
Printing query results5m 38s
-
3. Creating Parameter Queries
-
4. Creating Calculated Fields
-
Using text4m 6s
-
5. Using the Expression Builder
-
6. Working with Dates in Queries
-
Using the Format function4m 34s
-
Defining today's date2m 53s
-
Working with time intervals3m 15s
-
Using the DateDiff function1m 55s
-
7. Understanding Conditional Statements
-
Using the Switch function3m 43s
-
8. Using Alternate Query Types
-
Using crosstab queries4m 46s
-
Finding duplicate queries2m 11s
-
Finding unmatched queries2m 10s
-
Updating queries2m 57s
-
Deleting queries2m 54s
-
-
Conclusion
-
Goodbye14s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Exploring the field properties