Lynda com Access 2007 Queries in Depth | B09A0A13F8879452072EC573179C5AD5EF5732F4

Lynda com Access 2007 Queries in Depth

Name	Lynda.com.Access.2007.Queries.in.Depth	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	255.6 MB
Total Files	80
Hash	B09A0A13F8879452072EC573179C5AD5EF5732F4

/00 Introduction/
0001 Welcome.mov	7.7 MB
0002 Using the exercise files.mov	505.7 KB
0003 Reviewing the Access interface.mov	899.2 KB
/01 Creating Queries in Access/
0101 Query basics.mov	6.9 MB
0102 Naming conventions and best practices.mov	2.6 MB
0103 Using the Query Wizard.mov	6.5 MB
0104 Exploring the Query By Example (QBE) interface.mov	6.9 MB
/02 Creating Simple Select Queries/
0201 Defining a single criterion.mov	6.9 MB
0202 Comparison operators.mov	4.1 MB
0203 Defining the column headers with aliases.mov	2.9 MB
0204 Exploring the field properties.mov	4.3 MB
0205 Understanding query level properties.mov	6.5 MB
0206 Working with joins and primary keys.mov	6.0 MB
0207 Printing query results.mov	7.6 MB
/03 Creating Parameter Queries/
0301 Understanding parameter queries.mov	4.7 MB
0302 Obtaining parameters from other Access objects.mov	4.0 MB
/04 Creating Calculated Fields/
0401 Using Totals to calculate values.mov	3.3 MB
0402 Introducing mathematical operators.mov	3.8 MB
0403 Using mathematical operators.mov	2.6 MB
0404 Using text.mov	6.4 MB
/05 Using the Expression Builder/
0501 The Expression Builder interface.mov	3.2 MB
0502 Exploring some built-in functions.mov	3.9 MB
/06 Working with Dates in Queries/
0601 Understanding dates as serial numbers.mov	3.6 MB
0602 Specifying a range of dates or times.mov	2.9 MB
0603 Using the Format function.mov	5.2 MB
0604 Using other Date Time functions.mov	4.5 MB
0605 Defining today's date.mov	3.1 MB
0606 Working with time intervals.mov	3.6 MB
0607 Using the DateDiff function.mov	2.1 MB
/07 Understanding Conditional Statements/
0701 Introduction to the conditional IIf function.mov	2.5 MB
0702 Creating an IIf function with the Expression Builder.mov	4.1 MB
0703 Using the Switch function.mov	3.9 MB
/08 Using Alternate Query Types/
0801 Using crosstab queries.mov	6.3 MB
0802 Finding duplicate queries.mov	2.6 MB
0803 Finding unmatched queries.mov	2.8 MB
0804 Working with action queries and backups.mov	1.6 MB
0805 Updating queries.mov	3.8 MB
0806 Making tables and appending queries.mov	3.2 MB
0807 Deleting queries.mov	3.6 MB
/09 Conclusion/
0901 Goodbye.mov	204.4 KB
/Exercise Files/Chapter 0/
Access Review.accdb	1.2 MB
/Exercise Files/Chapter 1/
Naming Conventions.accdb	1.3 MB
QBE Design.accdb	1.2 MB
Query Basics.accdb	1.4 MB
Wizard.accdb	1.3 MB
/Exercise Files/Chapter 2/
Comparison.accdb	1.2 MB
Criteria.accdb	1.4 MB
Field Properties.accdb	1.2 MB
Joins.accdb	1.3 MB
Printing - Start.accdb	1.3 MB
Printing.accdb	1.3 MB
Query Properties.accdb	1.3 MB
SampleText.txt	0.3 KB
Using Aliases.accdb	1.1 MB
/Exercise Files/Chapter 3/
Obtaining Parameters.accdb	1.5 MB
Parameters.accdb	1.5 MB
/Exercise Files/Chapter 4/
MathOps.accdb	3.7 MB
TextFunctions.accdb	3.7 MB
Totals.accdb	3.7 MB
UsingMathOps.accdb	3.7 MB
/Exercise Files/Chapter 5/
Expression Builder.accdb	3.7 MB
Functions.accdb	3.7 MB
/Exercise Files/Chapter 6/
DateDiff - Copy.accdb	1.2 MB
DateDiff.accdb	1.2 MB
DateFunction.accdb	3.7 MB
Format.accdb	3.7 MB
Intervals.accdb	3.7 MB
Range.accdb	3.7 MB
SerialDates.accdb	2.2 MB
Today.accdb	3.7 MB
/Exercise Files/Chapter 7/
Conditional.accdb	1.5 MB
Switch.accdb	1.5 MB
/Exercise Files/Chapter 8/
Action Queries.accdb	3.7 MB
Append.accdb	3.7 MB
Archive.accdb	286.7 KB
Crosstab.accdb	3.7 MB
Delete.accdb	3.7 MB
Duplicates.accdb	3.7 MB
Unmatched.accdb	3.7 MB
Update.accdb	3.7 MB
Total files 80