About this Course
The course empowers the trainee to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer.
The course introduces the skills required to design and plan a database using a standard database package as well as how to retrieve information from an existing database by using queries, select and sort tools available in the data-base. The trainee shall also be able to create and modify forms and reports.
This course prepares the participants for the Microsoft Office Specialist exam.
COURSE OUTLINE
Module 1.Exploring Access 2013
Module 2.Creating Tables
Module 3.Setting Field Properties
Module 4.Working with Tables
Module 5.Editing Tables
Module 6.Finding and Filtering Data
Module 7.Creating Relationships
Module 8.Using Simple Queries
Module 9.Using Operators in Queries
Module 10.Modifying Query Results
Module 11.Designing Advanced Queries
Module 12.Creating Action Queries
Module 13.Using Advanced Query Wizards
Module 14.Creating Basic Forms
Module 15.Manipulating Form Controls inDesign View
Module 16.Using Other Form Techniques
Module 17.Using Advanced Form Design
Module 18.Creating Basic Reports
Module 19.Using Controls and Layouts
Module 20.Using Editing Tools
Module 21.Using Advanced Report Design
Module 22.Using Advanced Database Features
PRE-REQUISITE
A basic working knowledge of Windows and older versions of Microsoft Access would be an advantage.
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider COMAT TRAINING SERVICES PTE LTD
- Course Category Technology
- Course Price n/a
Comments