MS Office training at APEC offers administrative assistants requiring a strong knowledge of Word to project management positions demanding strong Excel ability, yielding real benefits in the workplace. Microsoft Office is the world’s most popular productivity suite made by Microsoft, as a collection of computer programs for home users and business users. APEC also provides advanced Microsoft Office training online.
- How to design database and build tables
- To manage data
- How to run an SQL query
- To create forms and reports
- To navigate Access databases
CERTIFYING BODY
- Microsoft
- Inhouse Certification
CAREER PROSPECTS
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
SYLLABUS:
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