All Computer Skills ||
Office 2007 Skills ||
Office 2010 Skills ||
Office 2016 Skills ||
Office 2013 Skills ||
Office 2016 Expert ||
Office 2016 Essentials ||
Office 2007 Essentials ||
Office 2007 Advance ||
Office 2010 Advance ||
Office 2010 Essentials ||
Office 2010 Expert ||
Office 2013 Advance ||
Office 2013 Essentials ||
Office 2013 Expert ||
Office 365 Essentials ||
Windows ||
Access 2010 Advanced
Your participants will learn how to use the advanced features of Access 2010. This workshop is designed to teach you a basic understanding of Access 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database—among other things. By the time your participants finish this course, they will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!
Objective:
- Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
- Add, move, remove and format both regular and calculated controls
- Set the Primary Key
- Create a sub-form, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
- Group and sort data
- Understand, view and edit relationships
- Understand and establish referential integrity
- Sort and filter a query
- Add calculated fields
- Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
Introduction :
Getting Started
Welcome to the Access 2010 Advanced workshop. You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL and publish a Web database—among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!
Module 1 :
Advanced Table Tasks
In this module you will acquaint students with six different advanced table tasks: using the quick start group, using the property sheet, adding, moving, and removing controls, formatting controls, setting the primary key and using table macros.
Module 2 :
Advanced Form Tasks
In this module, students will learn how to create three different advanced forms: a subform, Web form and split form. They will also learn how to create three advanced tasks: a Modal Dialog, PivotTable and PivotChart.
Module 3 :
Advanced Reporting Tasks
In this module, students will learn how to perform certain advanced reporting tasks, including using the report sections, using conditional formatting, grouping and sorting data, adding calculated controls and creating labels.
Module 4 :
Understanding Relationships
This module will teach students about the different types of relationships, how to view relationships, how to edit relationship, what referential integrity is and how to establish it.
Module 5 :
Advanced Query Tasks
In this module, students will learn about advanced query tasks, such as sorting and filtering a query, adding calculated fields, using the Expression Builder and using logical functions.
Module 6 :
Working with SQL
In this module, students will learn about the relationship between Access 2010 and SQL. They will discover what SQL is, what an SQL statement is, they will learn about basic SQL syntax and they will learn about the various uses of SQL in Access 2010.
Module 7 :
Linking Data
In this module, students will learn how to link data. Topics will include linking to an Excel spreadsheet, linking to an Access database, linking to a SharePoint list and linking to a text or XML file. We will also look at other types of links.
Module 8 :
Importing Data
In this module, students will learn how to import data. Topics will include importing from an Excel spreadsheet, importing from an Access database, importing from a SharePoint list and importing from a text or XML file. We will also look at other types of imports.
Module 9 :
Exporting Data
In this module, students will learn how to export data. Topics will include saving an object as a PDF, exporting to an Excel spreadsheet, exporting to a SharePoint list and exporting to a Word or text file. We will also look at other types of exports.
Module 10 :
Advanced Database Tools
In this module, students will learn how to use advanced database tools. These tool include the database documenter, the analyze performance functions and the repair/compact database tool.
Conclusion :
Wrapping Up
Although this workshop is coming to a close, we hope that your journey to improve your Advanced Access skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels!