ELECTRONIC DATA PROCESSING

Data Processing Fundamentals: Introduction, Data, Information and Data Processing, Data structure, Need for data processing, Data Processing cycle and functions, Methods of data processing, Applications of data processing, major functional areas within the data processing department. Advantages and disadvantages of electronic data processing, use of computers in management.

Computer Processing Techniques: Introduction, On line, Batch and Real time processing systems, Time sharing, Multi-Programming system, Multi-Processing system, Distributed data processing system, Spooling, Office automation, Modular Programming, Interactive Processing.  File Organization: Introduction, Elements of a computer file, types of files, File organization, factors in file design, file handling, database, Introduction to DBMS: advantages and disadvantages of database management system, comparison with conventional file system

DBMS package (ACCESS): Introduction to Access, Creation of database & tables, Data Types, Field Properties, primary key, indexes. Operations on tables: Add record, delete record and edit text Sort, find/replace, and filter/select, re-arrange columns, freeze columns. Edit a Tables- move, copy, delete, rename, and modify table structure

Setting up Relationships- Define relationships, add a relationship, delete a relationship, save relationship.

Linking, Importing, Exporting data: basic concepts, importing or linking other Access databases, using linked tables, importing or linking spreadsheets, text & HTML files; exporting data from Access to text file, Access to Excel files, Access to HTML files & other Access databases.

Convert Access 2007 Databases to Other Access Formats Queries: basic concepts, types of queries, Query wizard; creating, running, saving and changing a query; selection criteria, Autolookup & cross-tab queries.

Introduction to Forms: Types of Basic Forms (Columnar, Tabular, Datasheet, Hierarchical), Forms Wizard, opening & saving a form, Form Controls

Designing queries in design view & SQL view ( Select, where , order by, Aggregate functions: max, min , sum , count ) using forms

Introduction to Reports: Types of Basic Reports (Columnar, Tabular, Groups/Total, Summary), Report Wizard, opening, saving, previewing and printing report.