The Most Fun You'll Have Learning about Databases and Access 2016 - Pt. 2

Welcome back to another in the FastGadgets tutorial series! Join me as we discuss databases, their design and maintenance, and how to work in an Access database.

Database download: https://media.pearsoncmg.com/ph/bp/bp_exploring_office_2016/sdf/Access_Chapter_02.zip

Objectives:

• Database design
• Creating a new database
• Importing data from an Excel spreadsheet into a database
• Importing data from an Access database into another database
• Editing fields in design view
• Joining tables together with relationships
• Testing referential integrity
• Creating a query from a single table
• Creating a multi-table query
• Using criteria in a query to limit query results

For more FastGadgets: http://fastgadgets.info

Social Media: Facebook: https://facebook.com/FastGadgetsChannel Twitter: https://twitter.com/FastGadgetsTech YouTube: https://www.youtube.com/FastGadgetstech Vid.me: https://vid.me/FastGadgets ... https://www.youtube.com/watch?v=J4bUoeowJMI