This course prepares the participants to understand the principles and the elements of Database Management and design simple databases using MS Access.
At the end of the course, the participants will be able to;
- Understand what Database Management.
- Understand the usage of different objects in MS-Access.
- Create tables, Queries Forms.
- Use different objects.
- Develop Reports.
- Create applications using MS Access features and functions.
- Role of Database in the business applications.
- Usage of different objects in MS-Access.
- Different Data types of table.
- Create tables, and knowing the concept of relationship in tables.
- Create Queries (Select, update, delete, append, make table).
- Usage of Forms and Create different Forms.
- Create forms using Wizard and also by using Design View.
- Use Query to create a Form.
- Use different objects in form like text box, buttons, labels, combo box, list box, and image.
- Develop Reports using wizards.
- Create and using Macros in forms.
- Develop an application using MS-Access program, with above functions and features.
- All training hours will be conducted in a computer lab equipped with MS Access DBMS software and smart projector.
- Should have minimal computer basic knowledge
4 Days