Buy Dideo Subscription
An easy to follow tutorial on understanding how Microsoft Access works and how to use it for creating a database. Learn Access in just a couple hours and enhance your resume: Concepts based. Easy to understand. For more info. visit http://learn.kaceli.com. The concepts learned here apply also to other versions. Table of Contents/Markers for each section/topic covered in the video. Also use this working file as you follow along: https://kaceli.com/a/access2016files/ You will need to unzip the files first. 1:00 Database Components 7:48 Creating a Database with one table in Microsoft Access 18:40 Importing data from other systems to create tables in Microsoft Access 27:50 Linking tables in a database in Microsoft Access 40:40 Designing queries using one or more tables in Microsoft Access 48:40 Designing a query in using the design view in Microsoft Access 54:10 Sorting and applying filtering in a query in Microsoft Access 1:00:03 Advanced queries and creating a calculated field in Microsoft Access 1:10:10 Simple and compound forms in Microsoft Access 1:24:45 Designing and modifying reports in Access in Microsoft Access 1:32:40 Creating a Mail Merge and exporting data to Excel in Microsoft Access This video covers: - General concepts on databases and components of a database - Creating a database from scratch with one table - Importing data from other systems to populate tables - Linking tables in Access - Designing queries using the design view - Sorting and filtering data - Advanced queries - Simple and compound forms - Designing and modifying reports - Creating a mailmerge from access If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
