Guest User

Untitled

a guest
Sep 16th, 2020
70
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Lesson 1: Access Basics (Saturday 19/09)
  2. - Introduction (Me + Them)
  3. - The Book Library Example
  4. - What is a Database?
  5. - What is Microsoft Access?
  6. - Access vs Excel
  7. - Launching Access And A Brief Overview Of The Backstage
  8. - Opening The (Home Inventory) Template And Going Over The User Interface
  9. - Learning How To Close The Project And Opening Another One (Types Of Templates -> Sharepoint Server Databases and Desktop Databases)
  10. - Creating A Blank Database (File Location And Database Extensions)
  11. - Objects in Access (Tables, Queries, Forms, and Reports)
  12.  
  13. Lesson 2: Tables in Access (Monday 21/09)
  14. - Review of Tables (+ Relational Tables)
  15. - Anatomy of a Table (Rows (Records), Columns (Fields), Why Named As Such?)
  16. - Opening the (Home Inventory) Template And Going Through One Of The Tables And The Changes That Happen In The Ribbon Of Access
  17. - Creating a Table Named (Books) And Setting Up The Field Names And Types
  18. - Editing The Table Structure In Design View
  19. - Entering Data Into Our (Books) Table
  20. - Primary and Foreign Keys
  21. - Creating Another Table Called (Authors) And Setting Up The Field Names And Types
  22. - Creating A Foreign Key In The (Authors) Table
  23. - Connecting The (Books) And (Authors) Table Together Using Primary And Foreign Keys
  24. - Importing A Table From Excel
  25.  
  26. Lesson 3: Forms in Access (Wednesday 23/09)
  27. - Forms in Real Life
  28. - Why Use Forms?
  29. - Automatically Generating Forms From Tables
  30. - Adjusting Form Elements In Layout View
  31. - Generating Forms Using The Form Wizard
  32. - Creating Form Elements In Design View
  33. - Adding, Removing, And Resizing Controls In The Canvas
  34. - Exploring The Form Property Sheet
  35. - Finishing The Form Design (Images, Input Boxes, etc...)
  36. - Setting The Data Source For The Form
  37.  
  38. Lesson 4: Queries in Access (Saturday 26/09)
  39. - An Example Of A Query Like Operation In Real Life
  40. - What Are Queries?
  41. - Creating A Simple Query Using The Query Wizard
  42. - Creating Another Query Using The Design View
  43. - Using Criteria In Order To Set Constraints
  44. - Using Criteria With Wildcards
  45. - Making Use Of Multiple Criteria With AND / OR
  46. - Criteria With Mathematical Comparisons
  47. - Creating An UPDATE Query
  48. - Creating A MAKE TABLE Query
  49. - Creating A DELETE Query
  50.  
  51. Lesson 5: Reports in Access (Monday 28/09)
  52. - Reports In Real Life
  53. - What Are Reports?
  54. - Example of a Report From The (Home Inventory) Template
  55. - Creating A Report Using The Report Wizard
  56. - Creating A Report Using The Design View
  57. - Editing A Report Using The Layout View
  58.  
  59. Lesson 6: Goodbye (Wednesday 30/09)
  60. - Q/A
  61. - Quiz Maybe?
RAW Paste Data