Lynda Access 2007 Queries | CD51285F697E8AC9692309CB0DE30BD58CD18F8A

Lynda Access 2007 Queries

Name	Lynda Access 2007 -Queries	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	301.1 MB
Total Files	40
Hash	CD51285F697E8AC9692309CB0DE30BD58CD18F8A

/1. Creating Queries in Access/
Defining a single criterion.wmv	13.1 MB
Exploring the Query By Example (QBE) interface.wmv	11.6 MB
Naming conventions and best practices.wmv	4.8 MB
Query basics.wmv	14.2 MB
Using the Query Wizard.wmv	10.2 MB
/2. Creating Simple Select Queries/
Comparison operators.wmv	6.8 MB
Defining a single criterion.wmv	13.1 MB
Defining the column headers with aliases.wmv	5.6 MB
Exploring the field properties.wmv	9.0 MB
Printing query results.wmv	13.6 MB
Understanding query level properties.wmv	13.3 MB
Working with joins and primary keys.wmv	11.4 MB
/3. Creating Parameter Queries/
Obtaining parameters from other Access objects.wmv	8.1 MB
Understanding parameter queries.wmv	9.0 MB
Using Totals to calculate values.wmv	6.2 MB
/4. Creating Calculated Fields/
Introducing mathematical operators.wmv	7.1 MB
Using mathematical operators.wmv	4.2 MB
Using text.wmv	9.5 MB
Using Totals to calculate values.wmv	6.2 MB
/5. Using the Expression Builder/
Exploring some built-in functions.wmv	6.4 MB
The Expression Builder interface.wmv	5.1 MB
/6. Working with Dates in Queries/
Defining today's date.wmv	5.8 MB
Specifying a range of dates or times.wmv	5.4 MB
Understanding dates as serial numbers.wmv	6.5 MB
Using other Date-Time functions.wmv	6.8 MB
Using the DateDiff function.wmv	4.1 MB
Using the Format function.wmv	9.9 MB
Working with time intervals.wmv	6.4 MB
/7. Understanding Conditional Statements/
Creating an IIf function with the Expression Builder.wmv	8.0 MB
Introduction to the conditional IIf function.wmv	4.1 MB
Using the Switch function.wmv	7.0 MB
/8. Using Alternate Query Types/
Deleting queries.wmv	6.0 MB
Finding duplicate queries.wmv	4.0 MB
Finding unmatched queries.wmv	4.4 MB
Making tables and appending queries.wmv	5.6 MB
Updating queries.wmv	6.2 MB
Using crosstab queries.wmv	10.5 MB
Working with action queries and backups.wmv	2.5 MB
/Introduction/
Reviewing the Access interface.wmv	1.5 MB
welcome.wmv	8.2 MB
Total files 40