Professor Lisa Friedrichsen's
Computer Science YouTubes, Resources & Reference Material
Relational Database Design Using Access playlist
- Why create a relational database in the first place?
- The why and how of 1-to-1, 1-to-many, and many-to-many relationships
- Analyzing 1-to-many and many-to-many relationships using Students and Classes
- A deeper dive into 1-to-1 relationships: Why and How?
- Enforcing referential integrity, the cascade options, and orphan records
- Analyzing the relationships of the Vehicle Maintenance template
- Analyzing the relationships of the Nutrition tracking template
Lookup Tables and Fields playlist
- Creating a Lookup table: what, why, and how
- Modifying Lookup field properties (aka modifying drop-down lists)
- Modifying Lookup field list values(aka adding values to a drop-down list)
Microsoft Access Troubleshooting and Error Messages playlist
- Trouble with the AutoNumber field: why are there gaps and how do I fix it?
- Record cannot be deleted or changed because table 'x' includes related records
- Can't create this relationship and enforce referential integrity
- Control can't be edited; it's bound to AutoNumber field
- The specified field could refer to more than one table
- Enter Parameter Value (in a query)
- Enter Parameter Value (on a form or report)
- Displaying a missing or hidden query grid in Query Desigm View
- Fixing the #Name? error on a form or report
- Query displays too many fields
- Query displays fewer fields than expected
- Query displays too many records
- Query displays fewer records than expected
- SQL could not be executed - ambiguous outer joins
- Database application is running very slow -- performance issues
- What is the .laccdb file and how do I use it?
- Displaying missing (or changing) subdatasheets in Table Datasheet View
- Some data may be lost (when shortening the Field Size property of a Short Text field)
- Data type mismatch in criteria expression
- Data integrity rules have changed (when changing the Validation Rule and Validation Text properties)
- Fixing a report that is too wide
- Adding or editing a form or report caption
Microsoft Access A to Z playlist
- Microsoft Access A to Z: Start Here! WHY and when should we use Access in the first place?
- Microsoft Access A to Z: An overview of what Access can do
- Microsoft Access A to Z: Creating tables
- Microsoft Access A to Z: Relating tables
- Microsoft Access A to Z: Designing Table Relationships
- Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships
- Microsoft Access A to Z: Relationship Roundup (a summary of why table relationships are important)
- Microsoft Access A to Z: Creating select queries with fields from multiple tables and criteria
- Microsoft Access A to Z: Creating calculated fields in queries
- Microsoft Access A to Z: More on calculated fields, field names, and foreign key fields in queries
- Microsoft Access A to Z: More on primary and foreign key fields and indexes
- Microsoft Access A to Z: Summary queries (also known as aggregate calculations)
- Microsoft Access A to Z: Preparing and importing data from Excel
- Microsoft Access A to Z: Building lookup tables to create drop-down lists (combo boxes)
- Microsoft Access A to Z: Building Reports using Sections, Labels, and Text Boxes
- Microsoft Access A to Z: Adding subtotals to reports and other report tips
- Microsoft Access A to Z: Reverse engineering Northwind multi-column and parameter reports
- Microsoft Access A to Z: Introduction to Forms
- Microsoft Access A to Z: Form Creation Tools and Form Views
- Microsoft Access A to Z: How to Best Use the Form Wizard to Create Forms/Subforms
- Microsoft Access A to Z: Everything You Need to Know about Subforms
- Microsoft Access A to Z: Forms and Command Buttons
- Microsoft Access A to Z: Creating combo boxes (drop-down lists) for data entry on a form
- Microsoft Access A to Z: Creating Lookup fields and how that relates to combo boxes on forms
- Microsoft Access A to Z: Creating and using combo boxes (drop-down lists) to FIND records
- Microsoft Access A to Z: Adding option (radio) buttons to a form
- Microsoft Access A to Z: Lookup tables and how they relate to combo boxes and option groups
- Microsoft Access A to Z: Storing and displaying images in your database
- Microsoft Access A to Z: 10 indispensable form development tips
- Microsoft Access A to Z: Macros 101
- Microsoft Access A to Z: Creating custom functions with VBA
- Microsoft Access A to Z: Access and the Internet
- Microsoft Access A to Z: Breaking the first and last name out of a single field
- Microsoft Access A to Z: Relating a query of calculations to the rest of the database
- Microsoft Access A to Z: Finding orphan records using join properties
Learn Access Using the Northwind Sample Database playlist
- Creating and exploring a new Microsoft Access Northwind database
- Finding, Moving, and Renaming a Microsoft Access database
- Using the Trust Center to automatically enable content for an Access database
- Examining Startup features including the AutoExec macro for the Access Northwind database
- Exploring Access Navigation Pane options using the Northwind database
- Exploring the startup navigation form in the Access Northwind database
- Creating and comparing calculated fields in tables and queries using the Access Northwind database
- Connecting a query with calculated field to other tables in Query Design View
- Exploring how data macros are applied to the tables in the Northwind sample Access database
- Sorting an Access report by subtotals
Older Access Screencasts
(Note that some of these were created using Access 2010 but remain relevant to current versions of Access)
- Northwind Sample database used for YouTube demos
- Starting Access
- Key Access and database terminology
- Getting comfortable with an Access database that someone else has created
- Controlling the navigation pane
- Table object views
- Table relationships
- Subdatasheets and how they show one-to-many relationships between tables
- Labels vs. text boxes
- Query, Form and Report Views
- Changing a text box into a combo box with a drop-down list