Databases

Databases

Sub Topics

  • Introduction to databases
  • Creating databases using Microsoft Excel (2007-2010)
  • Modifying a database
  • Form Design
  • Querying a database
  • Creating reports and labels
  • Using advanced Access
    • DATABASES (18 LESSONS)
    • Definition of Database
    • Database concepts
    • Traditional filing methods (manual and flat files
    • Functions of databases
    • Types of database models
    • Database software
    • Features of a database (e.g. data Structures, report generating, querry language, modules)
    • Data Organization
    • Character types
    • Fields
    • Records
    • Files
    • Database
    • Creating a database
    • Design a database structure
    • Field properties and data types
    • Key- fields and index
    • Data ently
    • Editing a database
    • Modify structure
    • Updating database
    • Form Design
    • Form Layout
    • Data manipulation
    • Formatting fields
    • Queries
    • Creating
    • Updating
    • Viewing
    • Printing
    • Reports layout
    • Creating (using rational and logical operator, logical operators — AND OR, NOT)
    • Modifying
    • Sorting and grouping
    • Labeling
    • Printing

Comments