Microsoft Office 2010 Access Advanced - Video Training Course
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
3h
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
This Microsoft Office 2010 Access Advanced – Video Training Course builds on the skills and concepts taught in Access 2010: Intermediate. You will learn about querying with SQL, Advanced Queries, Macros, Advanced Macros, Importing, Exporting, And Linking, Database Management, Access, OneNote, PowerPoint, Windows, Excel, Outlook, Publisher, Word, and much more. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and subqueries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data. This course will empower you with the knowledge and skills necessary to be a proficient user. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Microsoft Access 2010 at an expert level.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods.
Reviews
Subjects
- Word
- Access
- Database Management
- Office IT
- Database
- SQL
- Database training
- Design
- Ms Office
- Microsoft Office
- Ms Word
Teachers and trainers (1)
Alpha Academy
Instructor
Course programme
COURSE CURRICULUM
Querying with SQL
- SQL and Access
- Writing SQL Statements
- Attaching SQL Queries to Controls
Advanced Queries
- Creating Crosstab Queries
- Creating Parameter Queries
- Using Action Queries
Macros
- Creating, Running, and Modifying Macros
- Attaching Macros to the Events of Database Objects
Advanced Macros
- Creating Macros to Provide User Interaction
- Creating Macros that Require User Input
- Creating AutoKeys and AutoExec Macros
- Creating Macros for Data Transfer
Importing, Exporting, and Linking
- Importing Objects
- Exporting Objects
- Working with XML Documents
- Linking Access Objects
- Using Hyperlink Fields
Database Management
- Optimizing Resources
- Protecting Databases
- Setting Options and Properties
Microsoft Office 2010 Access Advanced - Video Training Course