Access 2010 Tutorial — A Comprehensive Guide to Access — Access Made Easy

This is a Microsoft Access 2010 Database Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to extract unique values and unique records from your Query, use of Wildcards to help in less refined Query searches, Parameter Query that prompts the user for a set of criteria prior to generating the Query, Update Query to update number fields, Append Query to add records from one Table to another, Delete Query to delete records that meets specified criteria, Make Table Query to make a Table based upon a Query of data or records, arrange a Form’s layout using the Layout View and how to use Table Formats, Anchoring controls or labels to a part of a Form to keep it in a relative position to the other controls and, or labels, sorting and filtering Form records, creating a Combo Box or drop down list, Option Group for narrowing a front-end user’s choices and adding Form Tab Pages for additional space within the same window without having to scroll.

1. Unique Values \u0026 Records
2. Wildcard Query
3. Parameter Query
4. Update Query
5. Append Query
6. Delete Query
7. Make Table Query
8. Form Layout View \u0026 Table Formats
9. Form Anchoring
10. Form Sorting \u0026 Filtering Records
11. Enhancing a Form’s Appearance
12. Form Combo Box
13. Form Option Group
14. Form Tab Pages

All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access 2010 (77-885) exam and become certified!

DVD \u0026 DOWNLOAD AVAILABLE:
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET’S CONNECT!
— http://www.linkedin.com/in/kirt-kershaw-33874410

This is a Microsoft Access 2010 Database Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to format controls to change the number of decimals and dates, applying colors and fonts using Themes, insert images, or pictures in your Reports, adding background images, or watermarks, prepare your Reports for print including margins and columns, how to use a Table’s Field propertied, tracking changes or keep a history of changes in the Memo data type field, the Input Mask feature displaying a pattern for the frontend user on how to enter data, use the Lookup Field for more accurate data entry, create inner and outer temporary query joins, a query self-join and how to find the Top Values using the Top Values Query feature.

1. Formatting Controls in a Report
2. Applying Themes to a Report
3. Inserting Images into a Report
4. Adding Background Images to Reports
5. Prepare Reports for Print
6. Table Field Properties
7. Table Tracking Changes
8. Table Input Masks
9. Lookup Field
10. Inner and Outer Query Joins
11. Top Values Query

All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access 2010 (77-885) exam and become certified!

DVD \u0026 DOWNLOAD AVAILABLE:
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET’S CONNECT!
— http://www.linkedin.com/in/kirt-kershaw-33874410

This is a Microsoft Access 2010 Database Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to enter data into a table as a record, save a table as a PDF, or XPS file, structuring table data including: copying, importing and appending only the structure of the table or both the structure and that data, manage you tables including: deleting, renaming and hiding your tables, and about Primary, Composite and Foreign Keys, an introduction to Table Relationships, One to Many and One to One Relationships and about the Normalization Standard.

1. Enter Table Records
2. Save Table as PDF or XPS File
3. Table Structuring
4. Managing Tables
5. Primary, Composite and Foreign Keys
6. Introduction to Relationships
7. One-to-Many Relationships
8. One-to-One Relationships
9. Normalization Standard

All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access 2010 (77-885) exam and become certified!

DVD \u0026 DOWNLOAD AVAILABLE:
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET’S CONNECT!
— http://www.linkedin.com/in/kirt-kershaw-33874410

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.

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.