130 likes | 296 Views
Introduction to Databases. Microsoft Access. Overview. What is a Database? What is a Database Management System? How is information organized in a database? What is Access? Database terminology. What is a Database?.
E N D
Introduction to Databases Microsoft Access
Overview • What is a Database? • What is a Database Management System? • How is information organized in a database? • What is Access? • Database terminology
What is a Database? • A database is a collection of data that is related to a particular topic or purpose. • Examples: • Library • Telephone Book • School Records • Business Database - Visa
What are Database Management Systems? • A database management system (DBMS) is the software that lets you enter, maintain, retrieve, and output data from a database.
Understanding Databases Filing Cabinet Drawer #1 Customers Drawer #2 Suppliers Drawer #3 Employees Supplier #1 Supplier #2 Supplier #100 Name, Address, City, Phone #, etc.
How Data is Organized Database Table 1 Table 2 Table 3 Record 1 Record 2 Field 1 Field 2 Field 3 Field 1 Field 2 Field 3
What is Access? • Access is a database management system developed by Microsoft. It is part of the Microsoft Office software package (Word, Excel, Access, PowerPoint, etc.). • Access 2003 is the database management system we will be using.
Organizing information in Access • In Access, the database is organized into tables. For example: DATABASE Customer Employee Supplier Orders Table Table Table Table
Access 2003 • Data in a table (or tables) is organized into columns (called fields) and rows (called records) Field FieldField Record
Terminology • Words to know: • Table: a storage structure of data that is composed of columns of information (fields) and repeated in rows (records). • Query: a question asked of the data contained in tables or other queries. (e.g., What students passed the final?).
Terminology • Form: a screen used to format the output of a query or table for display or to allow for data entry. • Report: Formatted output of data for printing – it receives data from tables and queries
Terminology • Field: A column of data in a table. (e.g. Last Name in a table of names and addresses) • Primary Key: The field on which a table can be related to another table to join the two together. (e.g. Your account number at your bank ties you to a table of transactions, loans, personal data, etc.).