Lisa Friedrichsen

6.45K subscribers

302 videos

Professor Lisa Friedrichsen's list of HTML, CSS, JavaScript, and Access relational database YouTubes. These were created for my students at Johnson County Co...

Latest Videos

Microsoft Access The Why and How of creating 1-to-1 relationships between two tables

Microsoft Access Modifying values in the drop-down list of a Lookup field

Microsoft Access Modifying a Lookup field by adding a column to a drop down list

Microsoft Access Creating a Lookup table (breaking a single table into two related tables)

Microsoft Access Analyzing table relationships in the Nutrition tracking template

Microsoft Access Studying the table relationships in the Vehicle maintenance template

Microsoft Access Enforcing referential integrity, the cascade options, and orphan records

Microsoft Access Analyzing 1-to-many and many-to-many relationships using Students and Classes

Microsoft Access 1-to-1, 1-to-many, and many-to-many relationships

Microsoft Access What is a relational database and why are one-to-many relationships important

Microsoft Access How to add or edit the Caption on a form or report tab

Microsoft Access Fixing a report that is too wide (or prints blank pages)

Microsoft Access Data Integrity Rules Have Changed message and the Validation Rule property

Microsoft Access Understanding and fixing the Data type mismatch error message

Microsoft Access The error message Some Data May Be Lost - calculating the length of a text field

Microsoft Access How to display the expand collapse buttons to display a table subdatasheet

Microsoft Access What is the .laccdb file and how do I use it

Microsoft Access Troubleshooting poor Access database application performance

Microsoft Access The SQL statement could not be executed - ambiguous outer joins

Microsoft Access Troubleshooting a query that selects fewer fields than expected

Microsoft Access Troubleshooting a query that selects fewer records than expected

Microsoft Access Troubleshooting a query that selects too many records

Microsoft Access Troubleshooting a query that displays too many fields

Microsoft Access Fixing the #Name Error

Microsoft Access Enter Parameter Value dialog box (on a form or report)

Microsoft Access Missing Query Grid

Microsoft Access Query Error Enter Parameter Value

Microsoft Access The specified field could refer to more than one table

Microsoft Access Control can't be edited it's bound to AutoNumber field

Microsoft Access Can't create this relationship and enforce referential integrity