DATABASE MANAGEMENT

CURRICULUM FOR EXCEL (BASIC & ADVANCE)

Introduction to excel sheet

• Total rows & columns, worksheet.
• Editing a worksheet
• Insertion of extra rows, columns, worksheet
• Chart (design, layout, formats)
• Calculations using functions (sum, min, max, average, count etc)
• Using logical functions(if, and, or etc)
• Use of text functions (upper, lower, concate, len, replace, proper, left, right etc)
• Lookup Functions(H lookup &V lookup)
• Formatting a worksheet Hide & unhide of rows, columns
• Protecting a worksheet, Use of scenario, auditing, macro, goal seek.
• Database management using sort & filter, sub-total
• Combining a different sheet using consolidate
• Use of pivot table
• Proofing , comments & changes
• Get External Data & data tools
• Formula auditing , calculation & link etc

CURRICULUM FOR ACCESS

• Introduction to Access.
• Planning and Creating Tables:
  Designing, Creating, Entering data and modifying data in a table
• Creating and using Form:
  Auto forms, printing and sorting, Records and forms.
• Working with External Data:
  Importing data, linking to a spreadsheet or database.
• Creating Relational database, creating and working with relationships.
• Enhancing Form Design:
  Modifying form design, adding controls and changing properties of forms and controls.
• Creating Queries:
  Simple and cross tab.
• Producing Reports:
  Creating modifying a report, adding and deleting report controls, using a report wizard.

Duration : 30 DAYS.

Certification : DATAPOINT COMPUTERS.