Demand for data at the quickest possible time frequently rises among decision makers, analysts and other data users. Businesses and corporations often face problems on the quantity of data for business intelligence. Data are often developed, retrieved, and monitored from among various sources. The filing system, text documents or use of spreadsheets are common methods of gathering and storing data in an office environment, and oftentimes may lack the flexibility when managing demand for these data increase. Such a challenge is what a database management system (DBMS) can conveniently provide.  This training provides the use of one of the simplest and most flexible DBMS solutions in the market today, viz., the Microsoft (MS) Access. MS Access is a powerful program for creating and managing databases as it has many built in features for constructing and viewing information. MS Access is a more involved and genuine database application than other programs. 

Three of the major components of Access: tables; queries; and forms are included in the course coverage.  In addition, more extensive application of relational databases, generation of reports, web integration and SQL Server integration shall also be discussed.

Course Aim

Create Access Database that can make groups of interrelated objects perform specific database tasks such as data entry, table generation, information retrieval with queries, report generation for presenting information on paper and forms. Also, create a database that enables the use of tables, queries, forms, reports, and macros that define, sort, manage, and view data. Participants will be able to identify tasks ultimately represented in the form of a report, group and flow chart the tasks, identify the needed input data and calculations performed on data, organize the data into tables and queries using normalization rules, design mock up forms, reports, and event procedures to follow task flow, construct the application, as well as test, review, and refine the application.

Course Participants

Personnel who are involved or about to be assigned in database management responsibilities. It is highly preferred that participants be computer literate.

Course Coverage

Introduction to Database Planning and Design
Getting Started with MS Access
Working with Tables
Database Table and Relationship
Working with Table Relationships
Working with Queries
Working with Forms
Generating Reports
Writing Expression in Forms, Queries and Reports
Action Queries
Management of Learning (MOL)
Action Queries
Definition of SQL/DDL/DML
SQL Statement
Introduction to Macro
Creating Macros
Macro Groups
Importing and Exporting Data/Tables
Linking Office Tables

Course Duration: 56 hours/8 days

Registration:

To register and further inquiry, please contact the Training Division at Telefax Nos. (632) 436-1426/9297543 or email it to japebenito@srtc.gov.ph or cemojica@srtc.gov.ph.

.