NETCOTECH

[ C/C++ ][ Access ][ SUN Java ][ ASP.Net ][ VB.Net ][ XML.Net ]

Microsoft Access Programming

Course Highlight

Module I: System analysis, design and programming tools and technique

a. Software development cycle
          1. Problem Identification
          2. Requirement Definition (Objectives to be fulfilled)
          3. Requirement analysis

          4. Design

                    a. Specification
                    b. ER- Diagram
                    c. Database analysis
                    d. Database design and specification

5. Implementation

                    a. Coding
                    b. Testing and Debugging
                    c. Installation
                    6. Review and update

b. ER-Diagram
          1. Identifying entities and relationships
          2. Types of entities
          3. Drawing ER- Diagrams
          4. Testing the ER- Model

c. Data Flow Diagram and Data Dictionary
d. Algorithm and flow-chart
e. Pseudo codes and programming constructs
          1. Character set (String)
          2. Constants and memory variables
          3. Array (Single and multi dimensional) and sorting techniques
          4. Input
          5. Output

         6. Processing Cycle

a. Decision: If…then……else, select…..case, nested
b. Looping while and Until, Repeat, for…..next, nested

Module II: Accessing Programming

1) Introduction to VBA Interface
2) Even Driven programming and events
3) Events occurrence
4) Variable declaration and Scopes
5) Character set, Constants and memory variables, Array and sorting technique
6) Input, Simple processing (manipulations), Output,

7) Conditional Statement and Looping

          a) If….then….else
          b) Select….case
          c) While….End, Do……..While, Do…Until, Repeat…..While, Repeat….Until
          d) For…..next

8) Error Trapping and handling

9) Form Module, Standard Module

          i) Sub and Functions
          ii) Standard Functions
                    (a) I/O Functions
                    (b) Conversion functions
                    (c) Options Statement
                    (d) String Handling
                    (e) Mathematical & Logical Functions

10) Arrays

          a) One Dimensional , Two Dimensional
          b) Static and dynamic array
          c) Array Sorting and manipulations

11) Constituent Controls and User Interface

          i) Text Box Control
          ii) Label
          iii) Combo and List
          iv) Frame Control
          v) Radio Button, Check Box
          vi) Imagine Control
          vii) Command Button

12) Database Programming

i) Bound Form
ii) Unbound Form

(a) DAO

1. Database
2. Recordsets
3. SQL Statements
4. Fields
5. Creating custom find/filter/sort using DAO
6. Master Details Form

13) Menu and Toolbar
14) Creating Application Startup and MDF file