Section outline

  • Databases are crucial tools for storing, managing and manipulating data. Using Databases will help you understand what a database is and what it is used for. This module will also allow you to demonstrate a range of key skills relating to building and using a database.

    On completion of this module you will be able to:

    •  Understand what a database is and how it is organized and operated.
    •  Create a simple database and view the database content in various modes.
    •  Create a table; define and modify fields and their properties; enter and edit data in a table. 
    • Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database. 
    •  Understand what a form is; create a form to enter, modify, and delete records and data in records. 
    •  Create routine reports and prepare outputs ready for distribution.

    What are the benefits of this module?

    This module covers the key functions and characteristics of databases and how to organize and operate them. Once you have developed the skills and knowledge set out in this module, you will be in a position to become certified in  Databases.

    • Students must
      Mark as done

      CHAPTER ONE– EXPLORING ACCESS 

      In this Chapter, you will learn how to:

      •   Work with Access 
      •  Start Access 
      •  Open an existing database 
      •  Familiarise with the Ribbon
      •  Use the contextual tabs 
      •  Use the Quick Access Toolbar 
      •  Understand database objects
      • Use the Navigation Pane 
      • Open a database object
      • Delete a database object
      • Use tabbed documents
      • Close a tabbed document 
      • Close all tabbed documents 
      • Switch between the view modes 
      • Use the Options dialog box 
      • Close a database 
      • Create a new database 
      • Use Help 
      • Exit Access

    • EXPLORING ACCESS Book
      Students must
      Mark as done