Microsoft Office Access 2007 helps track information quickly, create meaningful reports with ease, and share data more securely using the Web. Its new library of pre-built solutions & new information-sharing capabilities lets you track and report information with ease. The prebuilt database solutions allow you to modify and adapt them to your changing business needs.
With its Microsoft Office Fluent User Interface and Interactive Design Capabilities that do not require intensive database knowledge, Access 2007 will make database development quite easy. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.
This training provides the use of one of the simplest and most flexible DBMS solutions in the market today, the Microsoft (MS) Access. The three major components of Access: tables queries and forms are included in the course coverage. In addition, extensive application of relational databases, generation of reports, web integration and SQL server integration shall also be discussed.
What will participants gain?
Using the 2007 version, participants will learn how to 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, they will learn how to create databases that makes use of tables; queries; forms; reports; and macros that define, sort, manage, and view data. Participants will be able to understand and identify tasks required for a given report, i.e. group and flow-chart the tasks, identify the required input data and calculations, organize the data into tables and queries, design mock-up forms, reports, and event procedures to follow task flow, construct the application, as well as test, review, and refine the application.
Who can participate?
Personnel involved or assigned in database management responsibilities. It is imperative that participants be computer literate and with at least fair background on the use of MS Excel.
Course Coverage
Introduction to Database Planning and Design
Program Logic Formulation
Getting Started with MS Access
Working with Tables/Database Tables and Relationships
Working with Table Relationships/Queries/Forms
Generating Reports
Writing Expression in Forms, Queries and Reports
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: 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.
.
