Menu Close

Microsoft Access

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions. MS Access has the RDBMS features that help us to create table, create relationships, create queries with drag and drop facilities, create customized forms and yet importantly the reports.

This course suits everyone who learns the basics of computer operation and word processing, to carry on routine daily operations and help them land employment or advance an existing career.

  • Computer Operator
  • Office Assistant
  • Admin Assistant.

On who intend to create and use data for implementing a full DBMS.

MS ACCESS

• Introduction to MS Access
• Database, DBMS, RDBMS
• Create Database
• Manage Database
• Create Tables
– Design View
– Table Wizard
– Datasheet View
• Add Records to Table
• Update data using queries
• Create Queries
• Types of Queries
– Select, Crosstab, Maketable
– Append, Update, Delete
• Create Forms with UI controls
• Form Wizard
• Fine-tune Form
• Sort Data
• Filter Data
• Generate Reports
• Report Wizard
• Custom Reports