by | Released November 2010 | ISBN: 9781926873206

In this Microsoft Access 2010 training video, expert author Guy Vaccaro introduces you to the creation of Access databases and associated forms and reports.Starting with the basics of the interface, this computer based training video takes you through the creation of a single table, field types and properties, creating an input form, report generation, and all the associated functions you would expect. As you move through the video tutorial, Guy covers some advanced features such as Crosstab Queries, importing data from various sources, Join queries, and much much more.By the completion of this software training tutorial, you will be fully versed in the creation and use of Microsoft Access 2010 databases, and how to get data in and out of the databases. Extensive exercise files are included to allow you to work alongside the author as you learn. Show and hide more Publisher resources Download Example Code

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