SMTC Training Center

Ms Access for SMEs
Work developing with Microsoft Access Database

This course design for a YOUNG professional new comer for Access Database developer. This course will enable trainee to create and manage a small desktop database as well as web application. Details covering database fundamental design and planning which suitable for small business owner ( SMEs ) , small private organization or company. This actual practice by learning covering topics from creating a table, storing data, creating form for input, control security and access, how to assigned authorized user only, how to add, edit, modify data. The first step toward further development in database programming.

This course is suitable and recommend for anyone with or without basic for Ms Access. The learning process is suitable for student from high school up to college or university student. Class designs to be easy to apply and practical for private small business owner or SMEs. Splendid training program for corporate, government staffs, and bank staffs and anyone who wish to be involved in this high demand Ms Access Job market.

Days : 3 days
TIME : 9:00 till 17:00 (Overtime Expected).
INCLUDE: Free parking + 2 Snack meals and beverages. Disk support to trainee.
EQUIP: Computer at least Pentium II

Software Involved (Depend on instructors) :
Microsoft Access 2000 (Ms Access 2000)

Gaining from this course :

1. Able to create database using Access
   
2. Create nice and function FORM
   
3. Create REPORTS
   
4. Search Database and using all tools related to search feature
   
5. Able to published your data in Internet
   
6. Know vocabulary need for Computer and Ms Access
   
   

CLASS COVERING DETAILS & CONTENTS OF (In brief) :

• Learn MS Access Database structural
  
• Learn how to use tools, and menus in this software to create Form Such as; Label, Text,
  Combo Box, List Box, Button, Tab Control, Option Button, Subform, Image and etc.
  
• Learn about Object Table, Form, Query, Report, Page, Macro
  
• Workshop on Object in MS Access
  
• Create Table
  
• Create Query
  
• Create Form
  
• Using tools to create and manage your Form
  
• Understand the "Form Properties" and how to set properties value
  
• Create Page
  
• Create Macro
  
• Actual Workshop include tips and techniques such as; popup, login, Auto Open / Close (Exit) program, Command (event) buttons such as find data, search, print , Open other programs
  
• Creating Form with Ms Access (without any typing)
  
• How to Export data and publish in HTML format (or WebPage)