Database Series –

Access Basics I

--------------------------------------------------------------------------------------

Course Outline:
  1. Databases on the Market
    1. Simple SOHO Databases
      1. Access
      2. Paradox
      3. Foxpro
      4. ACT!
    2. Complex Enterprise Databases
      1. Oracle
      2. IBM DB2
      3. MicrosoftSQL
    3. Flat-file versus Relational
  2. Databases: What they are and what they can do
    1. Store and analyze data
    2. They save you massive amounts of time
  3. Making your first database
    1. Before you start – why reinvent the wheel?
    2. Learning Access
      1. Windows and Computer Basics
      2. The Access Environment
        1. Parts
          1. Tables
            1. Rows (records)
            2. Columns (fields)
          2. Queries
          3. Forms
          4. Reports
          5. Macros and Modules
        2. Printing, Saving, and Getting Help
    3. Planning is always first – we will be coming back to this!!!
    4. Building your first table