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