DB Web Applications
WebsiteDeployment DistributedNetworks
prev next prev next
  Course navigation
 
Lesson 1
What is a database?
 
This module discusses the elements that make up a database in Microsoft Access.
Databases can be quite simple or quite complicated. Of course, we will start the discussion with simple databases.
Before you can build a database you need to have an idea about what you need to build. Creating a database is not as familiar to most people as other types of work you may do on a computer such as writing a document or creating a spreadsheet.
In this module you will learn some official database terms and definitions and see some examples of the types of data that can be stored and analyzed in a database. In additions, you will learn the steps for designing and creating the final product, you will create the beginnings of the database that will become your course project.
After completing this module you will be able to:
  1. Describe what a database is
  2. Describe what a relational database is
  3. Describe how to design a relational database
  4. Describe how an Access database stores data in a table
  5. Describe the purpose of the other Access database objects: forms, reports, and queries
  6. Design an Access database
  7. Create an empty Access database file
  8. List the steps involved in creating an Access database
  Course navigation