chapter 5 comp

• Microsoft Access


  One of the most popular and powerful DBMS with many built-in features to assist in constructing databases and viewing information
• MS-Access is a Relational Database Management System (RDBMS) that can be used to store and manipulate large amounts of information
• MS-Access


  • Easy to understand with a graphical interface to create queries, forms, and reports
  • Even inexperienced programmers can use it to turn data into a relational database
• Benefits of using MS-Access

  • Sample databases to learn about real-world tables, forms, queries, and reports
  • Database Wizard makes it easy to create a database
  • Graphical interface in the Relationship Window makes understanding database structure easier
  • Integration with other Microsoft Office applications
  • Easier programming with macros and VBA
• MS-Access allows you to store, retrieve, sort, analyze, and print information contained in the database without data redundancy by defining relationships between sets of data
• Creating a New Database


  1. Choose File > New Database

  2. Specify a name and location for the database

  3. Click Create
• Creating a Database using the Database Wizard

  1. Select Access Database Wizards, pages, and projects

  2. Double-click the icon for the type of database to create

  3. Specify a name and location for the database

  4. Click Create
• Creating a Database without using the Database Wizard

  1. Select Blank Access Database

  2. Specify a name and location for the database

  3. Click Create
• Opening Existing Databases


  1. Select the database from the list of recent databases

  2. If not listed, choose More Files and select the database
• Exiting Microsoft Access


  1. Click File > Exit

  2. Or click the Close button
• MS-Access Application Window


  • Title Bar
  • Menu Bar
  • Toolbars
  • Scroll Bars
  • Status Bar
• Database Window


  Organizes all the objects in the database, including tables, queries, forms, reports, pages, macros, and modules
• IDE


  Integrated Development Environment
• Database


  Computerized record keeping system
• RDBMS


  Relational Database Management System
• Table


  Object used to store data in a database
• Query


  Object used to retrieve data from a database
• AutoNumber field


  Data type that is automatically incremented by Access each time a new record is entered
• Field


  Columns that each row of a table is divided into
• Record


  Each row of a table representing a set of information
• Datasheet view


  Window used to display, enter and edit data on the screen
• Major database objects


  • Tables
  • Queries
  • Forms
  • Reports
• A database consists of various components called objects
• Queries are used to retrieve data from the database
• The output of a query is in the form of a table
• Reports are used to retrieve data from the database and present it in a formatted way

  reports do not allow user to enter or change the data in database

  they can be printed
• Microsoft Access saves the database with the .mdb extension
• Record


  Complete set of related fields
• Table structure


  Created in Design View
• An IDE simplifies the tasks of creating and using a database
• The major objects of a database are Tables, Queries, Forms, and Reports
• Forms are provided by the database management system to enter, edit, and view data
• An integrated development environment is an interface used by database designers and application programmers to create database applications
• To view data in an Access table, the table is displayed in Datasheet View
• RDBMS stands for Relational Database Management System
• A request to extract data from a database is called a query, not a report
• Database design plays an important role in achieving the goals of efficiency, speed and consistency
• The two views for a table in Access are Design View and Datasheet View
• The window in a database IDE that is used to display, enter and edit data on the screen is called a form