Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Lesson 1: Access Basics (Saturday 19/09)
- - Introduction (Me + Them)
- - The Book Library Example
- - What is a Database?
- - What is Microsoft Access?
- - Access vs Excel
- - Launching Access And A Brief Overview Of The Backstage
- - Opening The (Home Inventory) Template And Going Over The User Interface
- - Learning How To Close The Project And Opening Another One (Types Of Templates -> Sharepoint Server Databases and Desktop Databases)
- - Creating A Blank Database (File Location And Database Extensions)
- - Objects in Access (Tables, Queries, Forms, and Reports)
- Lesson 2: Tables in Access (Monday 21/09)
- - Review of Tables (+ Relational Tables)
- - Anatomy of a Table (Rows (Records), Columns (Fields), Why Named As Such?)
- - Opening the (Home Inventory) Template And Going Through One Of The Tables And The Changes That Happen In The Ribbon Of Access
- - Creating a Table Named (Books) And Setting Up The Field Names And Types
- - Editing The Table Structure In Design View
- - Entering Data Into Our (Books) Table
- - Primary and Foreign Keys
- - Creating Another Table Called (Authors) And Setting Up The Field Names And Types
- - Creating A Foreign Key In The (Authors) Table
- - Connecting The (Books) And (Authors) Table Together Using Primary And Foreign Keys
- - Importing A Table From Excel
- Lesson 3: Forms in Access (Wednesday 23/09)
- - Forms in Real Life
- - Why Use Forms?
- - Automatically Generating Forms From Tables
- - Adjusting Form Elements In Layout View
- - Generating Forms Using The Form Wizard
- - Creating Form Elements In Design View
- - Adding, Removing, And Resizing Controls In The Canvas
- - Exploring The Form Property Sheet
- - Finishing The Form Design (Images, Input Boxes, etc...)
- - Setting The Data Source For The Form
- Lesson 4: Queries in Access (Saturday 26/09)
- - An Example Of A Query Like Operation In Real Life
- - What Are Queries?
- - Creating A Simple Query Using The Query Wizard
- - Creating Another Query Using The Design View
- - Using Criteria In Order To Set Constraints
- - Using Criteria With Wildcards
- - Making Use Of Multiple Criteria With AND / OR
- - Criteria With Mathematical Comparisons
- - Creating An UPDATE Query
- - Creating A MAKE TABLE Query
- - Creating A DELETE Query
- Lesson 5: Reports in Access (Monday 28/09)
- - Reports In Real Life
- - What Are Reports?
- - Example of a Report From The (Home Inventory) Template
- - Creating A Report Using The Report Wizard
- - Creating A Report Using The Design View
- - Editing A Report Using The Layout View
- Lesson 6: Goodbye (Wednesday 30/09)
- - Q/A
- - Quiz Maybe?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement