Section 1 : Before We Get Started

lecture 1 About Certification Pdf
lecture 2 0101 What Is Our Target 3:16
lecture 3 0102 Access 2013 Interface Tour 8:8
lecture 4 0103 Managing The Navigation Pane.
lecture 5 0104 Customize The Quick Access Toolbar 4:46
lecture 6 0105 Editing The Layout Of A Wizard Generated Repo 7:35
lecture 7 Make A Choice From Overlapping Or Tabbed Windows 4:17
lecture 8 0107 What Is A Custom Web App 3:35
lecture 9 0108 Using The Working Files 2:22

Section 2 : Database Theory And Design

lecture 10 0201 What Is A Database 4:23
lecture 11 0202 Why Do We Need A Relational Database 6:3
lecture 12 0203 Create A Database Using Database Templates 5:50
lecture 13 0204 Creating Your First Database

Section 3 : Tables

lecture 14 0301 Data Types Explained 3:1
lecture 15 0302 Why Do We Need A Primary Key 4:58
lecture 16 0303 Design And Then Create Tables 8:0
lecture 17 0304 Editing The Common Field Properties 7:48
lecture 18 0305 Field Properties Unique To Date-Time Data Typ 5:2
lecture 19 0306 The Field Size Property 5:29
lecture 20 0307 Using The Lookup Wizard On A Field 6:50
lecture 21 0308 Safeguard Data Entry With Input Masks 9:28
lecture 22 0309 Safeguard Data Using Validation Rules 5:29
lecture 23 0310 Using The Calculated Field Type 4:41
lecture 24 0311 Enter, Delete, And Edit Data In Tables. 9:6
lecture 25 0312 Finding And Replacing Data In A Table 6:48
lecture 26 0313 Sorting And Filtering Data 6:5

Section 4 : Queries

lecture 27 0401 Exploring Queries 2:35
lecture 28 0402 Creating, Saving, And Running A Select Query 6:44
lecture 29 0403 Sorting Data Within Queries 5:21
lecture 30 0404 Filtering Text Fields 6:9
lecture 31 0405 Operators For Numeric Filtering
lecture 32 0406 Querying Date-Time Fields 7:0
lecture 33 0407 Use Of Wildcards In Criteria 6:19
lecture 34 0408 Locating Empty Fields- Is Null 3:30
lecture 35 0409 Multiple Criteria On The Same Fields- Or 4:48
lecture 36 0410 Multiple Criteria On Different Fields- And 6:13
lecture 37 0411 Why Do I Need SQL View 6:35
lecture 38 0412 Add Calculating Fields To A Query 9:0
lecture 39 0413 Using Text Fields In Calculated Fields 5:10
lecture 40 0414 Calculated Fields Based On Date-Time Fields
lecture 41 0415 Calculating Age With A Query 5:58
lecture 42 0416 Producing Totals In Access 6:46

Section 5 : Forms

lecture 43 0501 Using The Wizard To Create A Form 6:21
lecture 44 0502 The Super Quick Form 3:42
lecture 45 0503 Viewing, Editing, And Deleting Records 5:23
lecture 46 0504 Adding Records Through Forms 5:17
lecture 47 0505 Searching For Records 4:26
lecture 48 0506 Sorting And Filtering Records 5:57
lecture 49 0507 Layout And Design View Explained 5:55
lecture 50 0508 Adding Colour To Forms 6:21
lecture 51 0509 Adding Fields And Controlling Alignment And S 6:52
lecture 52 0510 Controlling Tab Order Of Added Fields 4:22
lecture 53 0511 Add Images To Forms 4:32
lecture 54 0512 Adding Calculated Fields 8:55

Section 6 : Reports

lecture 55 0601 Creating A Report Using The Wizard 7:3
lecture 56 0602 Grouping Within Wizard Reports 6:29
lecture 57 0603 A Report In A Hurry- Quick Report 4:32
lecture 58 0604 Editing The Layout Of A Wizard Generated Repo
lecture 59 0605 Print Or Convert A Report To PDF 5:16

Section 7 : Multiple Table Databases

lecture 60 0701 Designing A Multi-Table Database 9:41
lecture 61 0702 Relationships Between Tables 3:11
lecture 62 0703 Creating Relationships In Access 6:37
lecture 63 0704 Why Do I Need Referential Integrity 6:56
lecture 64 0705 The Subdatasheet Tool 4:38
lecture 65 0706 Queries With Multiple Tables 6:21
lecture 66 0707 More Than One Table In A Form 7:48
lecture 67 0708 Reports On Multiple Tables 7:28

Section 8 : Database Normalization

lecture 68 0801 What Is Database Normalization 2:49
lecture 69 0802 Normalizing The Customer Database 9:8

Section 9 : Advanced Tables

lecture 70 0901 Using Lookups In Data Tables 8:29
lecture 71 0902 Converting Access Databases Between Versions
lecture 72 0903 Introduction To Indexing Fields 8:32
lecture 73 0904 Using More Than One Field As The Primary Key 4:34
lecture 74 0905 Creating And Printing Relationship Reports 4:18
lecture 75 0906 Importing Or Linking Data Into Access From Ac 4:33
lecture 76 0907 Importing And Linking Excel Data 6:36
lecture 77 0908 Importing Data From Text Files 4:24

Section 10 : Advanced Select Queries

lecture 78 1001 Using More Than One Table In A Query 7:2
lecture 79 1002 Changing The Join Type Of Links In Queries 3:53
lecture 80 1003 Watch Out For Cartesian Or Cross Join 4:0
lecture 81 1004 Using Parameters In Queries 6:12
lecture 82 1005 The Crosstab Query 6:30

Section 11 : Action Queries

lecture 83 1101 Make A New Table From A Query 7:44
lecture 84 1102 Update Queries For Amending Data 8:20
lecture 85 1103 Appending Records To A Table 7:44
lecture 86 1104 The Powerful Delete Query 4:0

Section 12 : Advanced Forms

lecture 87 1201 Adding A Subdatasheet Or Subform 5:0
lecture 88 1202 Creating A Form Without The Wizard 6:34
lecture 89 1203 Add A Drop Box (Combo Box) 6:25
lecture 90 1204 Special Use Of A Combo Box 4:58
lecture 91 1205 Using A Blank Form As A Menu 6:43

Section 13 : Advanced Reports

lecture 92 1301 Creating A Blank Report Without The Wizard 7:30
lecture 93 1302 Sorting Records In A Report 3:3
lecture 94 1303 Grouping Within Reports 5:49
lecture 95 1304 Adding Calculated Fields 6:34
lecture 96 1305 Creating And Using A Subreport 6:24
lecture 97 1306 Add Summaries To Groups 7:31

Section 14 : Custom Web Apps

lecture 98 1401 Prerequisites For Running A Custom Web App 2:18
lecture 99 1402 Creating Your First Web App. 6:49
lecture 100 1403 Adding Tables To The Web App 4:17
lecture 101 1404 Create And Edit Views 6:35
lecture 102 1405 Queries Are Possible In Web Apps 4:37
lecture 103 1406 Add A Blank Menu Form 4:14

Section 15 : Conclusion

lecture 104 1501 Summary And Beyond 4:2