Core Concepts of Accounting Information Systems, 12th Edition

Chapter 4

Organizing and Manipulating the Data in Databases

INTRODUCTION

CREATING DATABASE TABLES IN MICROSOFT ACCESS

Database Management Systems

An Introduction to Microsoft Access

Creating Database Tables

Creating Relationships

ENTERING DATA IN DATABASE TABLES

Creating Records

Ensuring Valid and Accurate Data Entry

Tips for Creating Database Tables and Records

EXTRACTING DATA FROM DATABASES: DATA MANIPULATION LANGUAGES

Creating Select Queries

Creating Action Queries

Guidelines for Creating Queries

Structured Query Language

Sorting, Indexing, and Database Programming

Online Analytical Processing and Data Mining

RECENT DATABASE ADVANCES AND DATA WAREHOUSES

Cloud Computing

Data Warehouses

AIS AT WORK—USING DATA MINING TO PREDICT FINANCIAL DISASTERS

SUMMARY

KEY TERMS YOU SHOULD KNOW

TEST YOURSELF

DISCUSSION QUESTIONS

PROBLEMS

CASE ANALYSES

BSN Bicycles I (Creating a Database from Scratch with Microsoft Access)

Furry Friends Foundation I (Creating a New Database from Scratch)

Bonnie P Manufacturing Company (Data Validation Using a DBMS)

Clifford Cohen University (Enforcing Referential Integrity)

BSN Bicycles II (Creating Queries in Access)

Furry Friends Foundation II (Creating Queries for Databases)

READINGS AND OTHER RESOURCES

ANSWERS TO TEST YOURSELF

After reading this chapter, you will:

1.  Be familiar with database techniques for validating data inputs.

2.  Know how to create tables, records, and relationships using Microsoft Access.

3.  Understand the importance of extracting ...