Microsoft Access - Up to Speed | Roger Hyttinen | Skillshare

Microsoft Access - Up to Speed

Roger Hyttinen

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
160 Lessons (8h 39m)
    • 1. Introduction

      5:31
    • 2. Before You Begin

      1:03
    • 3. Understanding Databases

      3:49
    • 4. Using Database Templates

      3:51
    • 5. Opening an Existing Database

      4:08
    • 6. The Access Environment

      4:06
    • 7. A Look at Tables

      3:25
    • 8. A Look at Forms

      3:44
    • 9. A Look at Queries

      2:24
    • 10. A Look at Reports

      1:54
    • 11. Creating a Blank Database

      1:20
    • 12. Setting Access Options

      2:07
    • 13. Getting Help

      3:48
    • 14. Creating a Table using Application Parts

      3:13
    • 15. Entering Data into a Table

      1:55
    • 16. Adding New Fields to a Table

      4:10
    • 17. Creating a table from scratch

      6:53
    • 18. Setting a Primary Key

      2:39
    • 19. Changing Column Width and Row Height

      1:55
    • 20. Rearranging Fields

      1:22
    • 21. Inserting and Deleting Fields

      2:04
    • 22. Changing Field Properties

      7:10
    • 23. Designing in Datasheet View

      3:53
    • 24. Editing Data

      2:58
    • 25. Formatting Table Data

      3:14
    • 26. Importing Excel Data into an Existing Table

      4:08
    • 27. Importing a Text File into a New Table

      5:35
    • 28. Selecting and Deleting Records

      1:30
    • 29. Sorting Records

      3:07
    • 30. Finding and Replacing Data

      4:46
    • 31. Filtering Data by Selection

      2:21
    • 32. Filtering Data by Form

      1:55
    • 33. Using Common Filters

      2:37
    • 34. Hiding and Unhiding Columns

      1:40
    • 35. Freezing Columns

      1:50
    • 36. Rearranging Columns

      1:22
    • 37. Displaying Column Totals in a Datasheet

      2:02
    • 38. Setting Validation Rules

      5:30
    • 39. Formatting Fields

      5:42
    • 40. Indexing Fields

      3:31
    • 41. Requring Data Entry

      1:14
    • 42. Creating an Input Mask

      4:49
    • 43. Creating a Lookup Field

      4:13
    • 44. Creating a Value List

      1:54
    • 45. Modifying a Value List

      1:20
    • 46. Creating Calculated Fields

      1:58
    • 47. Creating Multiple Primary Keys

      3:15
    • 48. Creating Multiple Field Values

      2:27
    • 49. Working in Query Design View

      4:08
    • 50. Creating a Query in Design View

      0:57
    • 51. Adding Fields to a Query

      2:46
    • 52. Removing Fields from a Query

      0:34
    • 53. Saving a Query

      0:56
    • 54. Running a Query

      1:16
    • 55. Adding Criteria to a Query

      2:00
    • 56. Specifying Multiple Criteria

      3:00
    • 57. Sorting Data in a Query

      1:28
    • 58. Moving Columns in a Query

      1:28
    • 59. A Look at Relationships

      2:49
    • 60. Creating a One to One Relationship

      3:29
    • 61. Creating a One to Many Relationship

      2:53
    • 62. Creating a Many to Many Relationship

      3:08
    • 63. Enforcing Referential Integrity

      4:28
    • 64. Cascade Update Related Fields

      4:00
    • 65. Cascade Delete Related Records

      3:04
    • 66. Creating and Printing a Relationship Report

      2:28
    • 67. Creating Multi Table Queries

      2:30
    • 68. Using Calculations in Queries

      3:25
    • 69. Changing Query Properties

      1:20
    • 70. Working with the Expression Builder

      4:46
    • 71. Creating a Totals Query

      4:05
    • 72. Creating a Parameter Query

      5:01
    • 73. Creating a Find Duplicates Query

      2:02
    • 74. Creating a Find Unmatched Records Query

      2:32
    • 75. Modifying Query Joins

      4:01
    • 76. About Action Queries

      2:28
    • 77. Creating a Make Table Query

      4:47
    • 78. Creating an Append Query

      4:28
    • 79. Creating an Update Query

      3:03
    • 80. Creating a Delete Query

      3:41
    • 81. Creating a SQL Query

      4:05
    • 82. Using the Form Wizard

      3:46
    • 83. Entering Data into a Form

      2:31
    • 84. A Look at Design View

      3:10
    • 85. Adding a Field to a Form

      1:42
    • 86. Changing Control Properties

      2:51
    • 87. Using Layout View

      2:33
    • 88. Finding Records in a Form

      3:08
    • 89. Adding Headers and Footers

      5:06
    • 90. Adding Controls to a Form

      1:58
    • 91. Moving and Sizing Controls

      2:32
    • 92. Creating a Calculated Control

      3:20
    • 93. Changing Control Properties

      6:18
    • 94. Changing Form Properties

      2:58
    • 95. Changing the Tab Order

      4:30
    • 96. Adding a Lookup Control

      6:30
    • 97. Inserting Graphics

      2:47
    • 98. Creating a Subform

      3:45
    • 99. Creating a Basic Report

      3:00
    • 100. Applying a Theme to a Report

      1:43
    • 101. Using the Report Wizard

      2:54
    • 102. Report View and Layout View

      3:08
    • 103. A Look at Design View

      3:48
    • 104. Modifying Report Setup

      2:32
    • 105. Printing Reports

      1:21
    • 106. Using the Label Wizard

      4:39
    • 107. Working with Report Sections

      4:32
    • 108. Adding Controls to a Report

      3:46
    • 109. Changing Control Properties

      4:26
    • 110. Creating a Calculated Control

      9:13
    • 111. Changing a Control's Data Source

      3:08
    • 112. Changing a Report's Data Source

      1:58
    • 113. Sorting and Grouping Data

      5:51
    • 114. Changing Report Section Properties

      2:53
    • 115. Inserting Graphics

      2:20
    • 116. Applying a Theme to a Report

      2:04
    • 117. Applying Conditional Formatting

      4:46
    • 118. Adding A Subform Using the Subform & Subreport Tool

      5:23
    • 119. Modifying a Subform

      5:31
    • 120. Aligning Controls to each other

      3:17
    • 121. Creating an Option Group

      4:55
    • 122. Edit Sorting and Grouping Levels in a Report

      3:58
    • 123. Inserting Total Fields in a Report

      3:58
    • 124. Using Rectangles Lines and Borders

      4:23
    • 125. Importing Data from a Text File

      4:04
    • 126. Importing Data from Excel

      2:38
    • 127. Importing Data from another Access Database