Microsoft Access 2010

Table of contents

1. Getting Started
   1. Overview Of Access 2010 00:08:01
   2. The New File Menu In Access 2010 00:09:24
   3. Making The Most Of The Navigation Pane 00:07:13
   4. Customize The Quick Access Toolbar 00:04:28
   5. Enable Content Using A Trusted Location 00:03:33
   6. Choose Between Tabbed Or Overlapping Windows 00:04:26
   7. Using The Files Included With This Course 00:01:54
   8. What Will I Be Able To Do At The End Of This Course 00:03:27
2. Database Theory And Design
   1. What Constitutes A Database 00:03:47
   2. The Components That Make Up A Database 00:02:18
   3. Why Do We Need A Relational Database Like Access 00:07:02
   4. Creating A Database Using The Database Wizards 00:06:45
   5. Create A Database WITHOUT The Wizard (Recommended) 00:03:31
3. Tables
   1. Designing Then Creating A Single Table Database 00:06:47
   2. Using The Correct Data Types 00:07:08
   3. Managing The Each Fields Properties 00:14:10
   4. Adding Lookup Options To A Field 00:05:01
   5. Adding An Input Mask To Safeguard Data Entry 00:04:10
   6. Adding A Validation Rule To Safeguard Data Entry 00:04:03
   7. The New Calculated Field In Access 2010 00:07:45
   8. The Primary Key 00:05:53
   9. Entering Data Into A Table 00:08:13
   10. Sorting Data In A Table 00:04:17
   11. Deleting Records From A Table 00:03:44
   12. Editing Records In A Table 00:04:59
   13. Finding Records In A Table 00:04:28
   14. Find And Replace Field Values 00:05:47
   15. Filtering Table Data 00:08:18
4. Queries
   1. What Is A Query 00:04:28
   2. Creating Saving And Running A New Query 00:06:29
   3. CAREFUL Editing Data In A Query 00:02:12
   4. Changing The Design Of A Query 00:03:29
   5. Add Criteria To A Text Field To Filter Records 00:04:25
   6. Filtering A Query On A Number Field 00:04:40
   7. Using Date Filters In A Query 00:05:26
   8. Boolean Fields In Querying 00:03:41
   9. Adding Wildcards To Query Criteria 00:07:04
   10. Retrieving Empty Values With A Query (NULL) 00:04:08
   11. Selecting Using Different Criteria On The Same Field (OR) 00:03:35
   12. Selecting Using Different Criteria On Different Fields (AND) 00:03:54
   13. Sorting The Results Of A Query 00:03:39
   14. Hiding Filtering Columns From A Query Result 00:02:07
   15. Evaluating Calculations With Queries 00:04:40
   16. Working Out The Current Age Of Contacts 00:05:02
   17. Produce Totals Using An Access Query 00:08:37
   18. Finding Duplicate Records With A Query 00:05:37
5. Forms
   1. Creating A Form Using The Wizard 00:05:56
   2. Column Or Tabular Forms - Which To Choose 00:02:54
   3. Viewing And Editing Records Through A Form 00:03:16
   4. Adding Records Through Forms And Associated Problems 00:04:12
   5. Searching For Records In Forms 00:04:18
   6. Deleting A Record In A Form 00:02:00
   7. Sorting Records 00:02:48
   8. Applying Filters Within Forms 00:05:04
   9. Modifying The Design Of A Form 00:07:58
   10. Adding Fields Not Currently Displayed 00:04:03
   11. Aligning And Spacing Form Controls 00:04:45
   12. Amending The Tab Order 00:03:44
   13. Add Logos And Images 00:03:38
   14. Adding Todays Date 00:03:48
   15. Calculating Fields In Forms 00:08:47
6. Reports
   1. Creating A Basic Report Using The Wizard 00:06:30
   2. Grouped Reports Through The Wizard 00:07:43
   3. Basing A Report On A Query 00:05:09
   4. The Quick Report Tool 00:04:03
   5. Editing The Layout Of A Wizard Generated Report 00:07:39
   6. Printing Reports 00:02:59
   7. Creating A PDF From A Report 00:05:11
7. Multiple Table Databases
   1. How To Create A Multi Table Database 00:06:56
   2. Creating Links Between Tables 00:06:25
   3. What Is The Foreign Key 00:01:18
   4. Removing Or Editing A Relationship 00:02:59
   5. Referential Integrity 00:05:51
   6. Viewing And Editing Data In A Sub Datasheet 00:04:22
   7. Creating A Query That Extracts Data From More Than One Table At A Time 00:07:45
   8. Create A Form Based On A Multi Table Query 00:02:47
   9. Generating A Report Based On More Than One Table 00:05:01
8. Database Normalization
   1. What Is Normalization 00:03:20
   2. Normalizing The Sample Database 00:05:44
9. Advanced Tables
   1. Importing Data Into Access From Excel 00:06:43
   2. Importing Data Into Access From Access 00:03:00
   3. Importing Data Into Access From Text Files 00:04:21
   4. Converting An Access 2010 Database To A Previous Version 00:03:29
   5. Making Use Of Lookups In Tables 00:06:59
   6. Why Do I Need To Index Fields In Tables 00:08:25
   7. Multiple Field Primary Keys 00:04:34
   8. Printing The Relationship Diagram 00:03:22
10. Advanced Select Queries
    1. Using More Than One Table To Feed A Query 00:05:06
    2. Changing The Join Type Of Links In Queries 00:05:57
    3. Watch Out For The Cartesian Join 00:04:23
    4. Parameter Queries 00:07:44
    5. Introducing The Crosstab Query 00:08:29
11. Action Queries
    1. The Make Table Query 00:07:25
    2. Use An Update Query To Change Data 00:07:15
    3. Appending Records To A Table Using The Append Query 00:05:59
    4. Removing Data Using The Delete Query 00:04:57
12. Advanced Forms
    1. Creating A Form With A Sub Datasheet 00:03:08
    2. Creating A Data Form With NO Wizard 00:07:17
    3. Adding A Drop Box (Combo Box) 00:06:29
    4. Special Use Of A Combo Box To Find Records 00:04:34
    5. Creating A Blank Form For Use As A Menu 00:03:51
    6. Adding Simple Action Buttons To A Form 00:09:31
13. Sub Forms
    1. Use A Sub Form To Display Related Data On One Screen 00:02:51
    2. Create A Sub Form And Add To The Main Form 00:06:27
    3. Using The Tab Control To Group Information Or Sub Forms 00:08:53
14. Advanced Reports
    1. Creating A Blank Report 00:07:01
    2. Adding Sorting And Grouping 00:07:14
    3. Adding New Fields To Carry Out Calculations 00:04:24
15. Sub Reports
    1. What Is A Sub Report 00:03:01
    2. Creating A Sub Report 00:03:19
    3. Inserting Sub Reports Into Main Report 00:04:37
16. About The Author
    1. About The Author 00:01:22