What This Document Is
This is the first tutorial in a series for Boston University’s Introduction to Information Systems (QST IS 223) course, specifically focused on getting started with Microsoft Access 2016. It introduces the fundamental concepts of database management and provides a hands-on introduction to building a simple database.
Why This Document Matters
This tutorial is essential for students in QST IS 223 who need to learn how to manage and organize data using a database management system. It’s used at the beginning of the course to establish a foundational understanding of database terminology and the Access interface. Mastering these initial concepts is crucial for subsequent labs and assignments that build upon this knowledge.
Common Limitations or Challenges
This tutorial focuses on the very basics of database creation and table design. It does *not* cover advanced features of Access, such as complex queries, report generation, or data analysis. Users will still need to develop proficiency in these areas through further study and practice. This document provides a starting point, but significant learning will be required to become fully competent in using Microsoft Access.
What This Document Provides
This tutorial includes an overview of database terminology – tables, records, and fields – explained with an everyday example (an address book). It then guides users through the initial steps of creating a database file named “Bookstore Inventory” and building the first table, “Author,” in Design View. The document outlines how to define field names and select appropriate data types (specifically, Short Text). It also previews the overall goal of the lab: to create five interconnected tables (Author, Wrote, Inventory, Publisher, Book) and establish relationships between them. The tutorial begins with Task 1: Creating and Naming a Database and continues with Task 2: Creating the Author Table, providing specific instructions for these initial steps.