Access 2010 Tutorial: A Comprehensive Guide to Access - Access Made Easy

Опубликовано: 20 Январь 2014
на канале: Kaceli TechTraining

81,318

288

An easy tutorial on understanding and learning how to use databases in Access and how to build your own. Not as difficult as you might think. Give it a try. You will not be disappointed and will not be a waste of your time. See also my website: http://kaceli.com for more info.

Table of Contents/Markers for each section/topic covered in the video. Also use this working file as you follow along: https://kaceli.com/access2016files/ You will need to download button at the top of the screen and then unzip the files first.
1:00 Database Components
7:48 Creating a Database with one table
18:40 Importing data from other systems to create tables
27:50 Linking tables in a database
40:40 Designing queries using one or more tables
48:40 Designing a query in using the design view
54:10 Sorting and applying filtering in a query
1:00:03 Advanced queries and creating a calculated field
1:10:10 Simple and compound forms
1:24:45 Designing and modifying reports in Access
1:32:40 Creating a Mail Merge and exporting data to Excel

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.