Microsoft Access 2010 Tutorial
4.0 /5- Offered byUDEMY
Microsoft Access 2010 Tutorial at UDEMY Overview
Duration | 7 hours |
Total fee | ₹529 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Access 2010 Tutorial at UDEMY Highlights
- Certificate of completion
- Access on mobile and TV
- Full lifetime access
- 30-Day Money-Back Guarantee
Microsoft Access 2010 Tutorial at UDEMY Course details
- The course is intended for anyone new to database concepts and wishing to use Access 2010.
- Learn the Access 2010 interface including the Backstage View, Ribbon Features, and Quick Access Toolbar
- Explore the fundamentals of a database including records, fields, table objects, relationships, and primary keys
- Discover techniques for creating forms that present data in a visual way
- Understand and set-up the expression builder
- Filter data in single and multiple columns in tables and forms
- Learn how to create reports
- Discover how to improve your report design, add existing fields, and how to group and sort right on the report
- Learn how to update the database quickly using update queries, append queries, and delete queries
- This Microsoft Access 2010 training course offers a ground-up guide to form and database creation and management with this powerful office productivity tool. You learn to create a single table, understand field types and properties, create input forms and generate reports. Advanced features covered under this are Crosstab Queries, importing data from multiple sources, join queries, and more. By the end of the MS Access course, you will be fully versed in the creation and use of Microsoft Access databases, and know how to get quickly get your data in and out. Course provided by Udemy
Microsoft Access 2010 Tutorial at UDEMY Curriculum
Getting to Know the Workspace
READ ME: Essential Information for a Successful Training Experience
Course transcripts
Access Basics
Understanding Database Concepts
Introduction to Building a Database
Tables
Using Quick Parts to Setup New Table, Importing Spreadsheet
Entering Data Types into Tables
Forms
Course Review
Auto-Create Forms, Filtering & Searching
Expression Builder
Understanding and Setting Up the Expression Builder
Conditional Formating
Format Control on Forms/Reports
Sorting and Filtering
Sorting Single & Multiple Columns; Filter One Field Data Records
Sorting & Filtering Data in Form View; Find & Replace in Forms
Reports
Creating Reports; Using Print Preview to Check Report Outcome
Advanced Reporting; Formatting Reports
Queries
Select Queries; Sorting; Defined Criteria
Change Fields wthin Query; Specifying Criteria for Numbers/Text
Security
Securing Database and Views; New Features
Quiz
Assessment Test
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?