Microsoft Access - Up to Speed | Roger Hyttinen | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Microsoft Access - Up to Speed

teacher avatar Roger Hyttinen

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

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