Register as Member or Log In To View Our Class ModulesLog In | Register
Have a question?
Send enquiry
Message sent Close

MOF 001 – Microsoft Access Training

MOF 001 – Microsoft Access Training

Teachers
Karen Cheah
Category:
In-House Programs / Information Technology / Microsoft Office /
6 Reviews
MOF 001 - Microsoft Access Training

Duration: 2 Days
Lectures: InHouse
Certificate of Completion

INTRODUCTION

Microsoft Access provides a wealth of powerful tools to assist you in building, organizing and sharing databases so that your targeted users can work smarter, faster and more accurately. Access gives you the capability to quickly analyze details, uncover critical relationship, and share the information throughout your organization via customized forms and reports. Just two-day of high-impact training takes you well beyond the basics and into the advanced capabilities of this essential business tool.

Objective

  • Understand the relational database concept.
  • Advanced data manipulation and filtering using queries.
  • Design forms with multiple Sub-form.
  • Design reports with multiple Sub-report.
  • Use macro to control the data and system flows.
  • Design quality database for end users.

Methodology

  • Hands-on
  • Exercise
  • Case Study
  • Test
  • Brain-Storming Session

CURRICULUM

This content is restricted to members only. Please log in to view more details

Day One

  • Creating multiple tables.
  • Refining tables with hyperlink controls, indexes and properties.
  • Data Validation.
  • Understanding the default value used.

  • Creating relationships.
  • One-to-one relationships.
  • One-to-Many relationships.
  • Referential Integrity.
  • Advanced link and table joins.

  • Queries in multiple tables.
  • Using formulas in a query.
  • Using funcitions in a query.
  • Grouping records.
  • Append Query.
  • Delete Query.
  • Update Query.

  • Creating main form.
  • Creating Sub-form.
  • Creating multiple Sub-form.
  • Using Tab Control.
  • Using Page Control.
  • Form properties.
  • Datasheet View Form.
  • Using formulas and functions in a form.

Day Two

  • Using queries in a report
  • Creating main report
  • Creating Sub-report
  • Creating multiple Sub-Report
  • Page Number Control
  • Using Running Number
  • Customizing report title by end users
  • Reprot Grouping
  • Report Sorting

  • Defining macro as an individual
  • Defining macro as a group
  • Activating macro
  • Adding actions to macros
  • Addidng arguments to macros
  • Attaching a macro to controls or forms
  • Setting conditional expressions to a macro

  • Creating main menu
  • Hiding design tools from end users
  • Splitting databases

About Instructors

Karen Cheah
Microsoft Office Training Information System Development PHP Programming