Technology Course

MICROSOFT OFFICE SPECIALIST

Course Type: Certification | Study Mode: Full-Time
Keywords: Microsoft office specialist
Course Provider:

Course Detail

Introduction
This course will help you to understand the basics of using MS Access. You will learn to design and use tables and to create various types of queries over them for effective information retrieval.
 
List of Lessons:
Introduction to databases
Becoming familiar with Access
Designing databases
Creation of a table in the datasheet view
Table design view
Special field types
Working with a table
Looking up and editing records
Filtering and sorting records
Fields selection and records sorting with a query
Working with criteria for the select query
Creating calculated items
Linked tables in queries
Analysis of relationships between tables
Relationships and referential integrity
Lookup column
Overviews
Queries with parameters
Action queries
Crosstab query
Intermediate
In this course you will learn advanced methods for designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.
 
List of Lessons:
Joins and their properties
Functions and Expression Builder
Aggregate functions
Data normalization
Create queries
Field indexing and data validation
Creating a form by using the wizard
Working with forms
Creating a form in design view
Working with form controls
Calculated items in the form
A combo box in the form
Buttons in the form
Organizing fields in the form
Creating a form with a subform by using wizard
Inserting subforms in the design view
A form as a user interface
Advanced
This course focuses on the creation of reports, data access pages and macros. You will also learn about the options for database management, for data import and export and also about SQL language.
 
List of Lessons:
Dependent objects and property inheritance
Creating reports
Reports with calculations
Graphic adjustments in reports
Pivot table and chart
How to work with macros
Matching macros and buttons
Verifying data by means of macros
Evaluating data by means of macros
Print and database documenter
Importing objects and splitting the database
Data export
Automatic import and export
XML Format
Navigation in databases
Database security and administration
SQL language