Subscribe

Introduction to Access Databases – Course Content

  • Introduction to Database Theory and Design:
    • Designing a data structure
    • Table relationships
    • Database normalization
  • Tables:
    • Primary keys
    • Data types and field lengths
    • Creating tables
    • Editing, adding and deleting records
    • Sorting data
    • Relating tables
    • Enforced data integrity
  • External Data:
    • Importing data into Access
    • Linking data from other external sources
    • Linking to ODBC data sources
    • Exporting data
  • Queries and SQL:
    • An introduction to SQL
    • Creating simple queries on a single table
    • Creating complex queries on multiple tables
    • Logical operators and Boolean queries
    • Numerical operators
    • Table Joins
  • Forms:
    • Creating a form
    • Working with form objects
    • Generating combo boxes and drop down lists
    • Creating subforms for related data
  • Reports:
    • Creating a report
    • Working with report objects
    • Creating a chart
    • Creating subreports for related data