Database Management/Introduction

From Wikiversity
Jump to navigation Jump to search

Objectives and Skills[edit | edit source]

This lesson introduces relational databases, Microsoft Access, tables and data types.

Readings[edit | edit source]

  1. McFadyen: Relational Databases and Microsoft Access - Chapter 1

Additional Readings[edit | edit source]

  1. Wikipedia: Database
  2. DBMS Overview - TutorialsPoint
  3. Office Support - Append Query

Multimedia[edit | edit source]

  1. GCF Global: Access 2016 Introduction to Databases
  2. GCF Global: Access 2016 Introduction to Objects
  3. GCF Global: Access 2016 Getting Started
  4. GCF Global: Access 2016 Managing Databases and Objects
  5. Relational Database Concepts
  6. Microsoft Virtual Academy: Introducing Databases

Activities[edit | edit source]

  1. Complete the tutorial GCF Global: Access 2016 Working with Tables.
  2. Review McFadyen: Relational Databases and Microsoft Access Chapter 1. Complete all of the exercises in Chapter 1.

Lesson Summary[edit | edit source]

  • A database is an organized collection of data.[1]
  • A relational database is a collection of schemas, tables, queries, reports, views, and other elements.[1]
  • A relational database is a database based on the relational model proposed by E.F. Codd in 1970 where data is stored into one or more tables (or "relations") of columns and rows, with a unique key identifying each row.[2]
  • A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data.[1]
  • A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases.[1]
  • Microsoft Access is a database management system installed on personal computers.
  • Well-known DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle Database, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.[1]
  • A database is a collection of related tables.[3]
  • A table stores data as a collection of related data consisting of rows and columns.[4]
  • A record is a set of common fields saved in a table.[5]
  • A data field is a place where you can store data.[6]
  • A data type defines the data values for that specific data type stored in a field. [5]

Key Terms[edit | edit source]

Access Datasheet View
A view of a table that is much like a spreadsheet. It allows you to enter in your information quickly.[7]
Access Design View
A view that allows you to manipulate how data will be created, stored, and displayed on the screen and in reports.[7]
Place where rows and columns intersect.[8]
data manipulation language
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.[9]
data type
Specifying the type of data a certain field will hold. Access needs to know if you are going to work with a number, text, a time/date or a hyperlink.[7]
A database is an organized collection of data. It is the collection of tables, queries, reports, views and other objects. [1]
E. F. Codd
Edgar Frank "Ted" Codd was an English computer scientist who, while working for IBM, invented the relational model for database management, the theoretical basis for relational databases and relational database management systems.[10]
Each record gives information about one item and is made up of many fields. Each field is one specific piece of information.[7]
field size
Specifying how large the field will be. Access needs to know how large a text box needs to be created to hold text type data.[7]
Attractive layouts used for entering or looking up records in a table.[7]
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. [11]
Access databases include four objects: tables, queries, forms, and reports.
primary key
A unique identifier for a record. There can be only one . Every record must have a different value in a field that is set up to be a primary key. If it is a table of products and the PRODUCT ID is the primary key, no two records can have the same ID within the same table.[7]
The ability to access the data by asking questions.[7]
Records are a collection of fields possibly of different field types. Records in a database or spreadsheet are usually called "rows".[12]
relational database management system
A type of database system in which data is stored in tables related by common fields; the most widely used database model today.[13]
Attractive layouts used for printing out the data with sophisticated presentation.[12]
row (database)
A row (also called a record or tuple) represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields. Each row in a table represents a set of related data, and every row in the table has the same structure.[14]
A database table is a collection of related data held in a table format within a database. It consists of rows and columns or fields.[4]
Rows are also called records or tuples.[15]
Structured information that is expressed by a database designer.[15]

Review Questions[edit | edit source]

Enable JavaScript to hide answers.
Click on a question to see the answer.
  1. An Access database is a ___________ software product.
    An Access database is a Microsoft Office software product.
  2. In Access there is the _____ view and the _____ view.
    In Access there is the Datasheet view and the Design view.
  3. True or False: Indexed entries can result in duplicates?
  4. True or False: In Access, you can only have one primary key.
  5. True or False: Number is the best data type for calculations involving money.
    False, Currency is the best data type for calculations involving money.

See Also[edit | edit source]

References[edit | edit source]