CSIS 1514 - Business Computer Systems

Topic 5 - Access

From The Book

Access Chapters 1 through 6

Topic Outline

Introduction

  • What is Access?

The Database Table

  • Creating Tables
  • Editing Tables
  • Importing and Linking Data

Selecting and Summarizing Data from Tables

  • Know Your Data
  • Fundamental Query Techniques
  • Advanced Queries

Applying Calculations to Data

  • Formulas
  • The IIF Function
  • Financial Functions

Reports

  • Fundamental Report Techniques
  • Advanced Report Techniques

Real World Scenarios

  • Using Multiple Tables in Queries
  • Comprehensive Access Project

Slides

Note

The slides are password-protected.

Chapter 1 - Introduction

Available in:

Chapter 2 - The Database Table

Available in:

Chapter 3 - Selecting and Summarizing Data from Tables

Available in:

Chapter 4 - Applying Calculations to Data

Available in:

Chapter 5 - Reports

Available in:

Chapter 6 - Real World Scenarios

Available in:

Additional Information

News du jour