Mercu buana trainingand Consulting

Gedung Teja Buana

Jalan Menteng Raya 29, Jakarta Pusat 10340

Tel 021-3141335, 70222950; Fax 021-3141375

www.mercubuana.ac.id  e-mail: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it

Overview:

Microsoft Access is relational database application from Microsoft. Adatabase is a collection of information related to a particular subject orpurpose, such as tracking customer orders or maintaining a music collection.If your database isn't stored on a computer, or only parts of it are, you maybe tracking information from a variety of sources that you have to coordinateand organize yourself.

Prerequisites:

Knowing Windows application and how the systems workwill be an advantage in learning the program, and know how to make database(DBMS). Because the Microsoft Access will run the form, table, query, datatype, report etc. that required a good comprehension of logical thinks of theoperating system.

Objectives:

Once you’ve read the syllabusbelow the objectives of learning the Microsoft Access is more ranging thanmentioned above. Theoretically and practically using Microsoft Access is moreeasily if you joined our program.

I.      Learning Access Fundamentals.

1.       Access 2003 for Access 2000 User: What’s New

2.       Building Your First Access 2003 Application

3.       Navigating with Access

4.       Working With Access Databases and Tables

5.       Entering, Editing and Validating Data in Tables

6.       Sorting, Finding and Filtering Data in Tables

7.       Linking, Importing and Exporting Tables

II.         Getting The Most Out of Queries

1.          Designing Access Queries

2.          Understanding Query Operators and Expressions

3.          Creating Multi table and Cross tab Queries

4.          Modifying Data with Action Queries

III.       Designing Forms And Reports

1.       Creating and Using Forms

2.       Designing Custom Multitable Forms

3.       Printing Basic Reports and Mailing Labels

4.       Preparing Advanced Reports

IV.       Publishing Data On Intranets AndThe Internet

1.          Working with Hyperlinks and HTML

2.          Generating Web Pages from Tables and Queries

3.          Designing Data Access Pages

V.         Integrating Access With OtherOffice 2003 Applications

1.       Adding Charts and Graphics to Forms and Reports

2.       Using Access with Microsoft Excel

3.       Using Access with Microsoft Word and mail Merge

VI.       Using Advance Access Techniques

1.          Exploring Relational Database Design andImplementation

2.          Working with Structured Query Language

3.          Securing Multiuser Network Application

4.          Creating Access Data Projects

VII.    Programming And Converting AccessApplications

1.       Writing Visual Basic for Applications Code

2.       Understanding Universal Data Access, OLE DB, and ADO

3.       Responding to Events with VBA 6.0

4.       Programming Combo and List Boxes

5.       Working with ADO Record sets, Forms and Controls

6.       Migrating Access 9x applications to Access