How would you go about organizing and managing this collection? Countless unorganized notes probably will not help, and sooner or later everything will be a disarray of unrelated facts, such as the artist, band s founding year, lists of guest appearances on albums, or the name of the person who has borrowed the album. On top of that, albums are sometimes loaned to friends, leased out, or loaned to an archive. Introduction to Databases Imagine that you have a large collection of music records with more than 10,000 units. The material prepared for ECDL certification in accordance with Sylabus 5 requirements.Ģ Table of Contents DATABASES 4 Introduction to Databases 4 Tables 5 Forms 7 Queries 8 Reports 9 Creating a Database 9 Creating Databases and Objects with a Wizard 9 Saving a Database 16 Actions in a Database 19 Opening a Database File 19 Actions with Database Objects 20 Creating a Table in Design View 22 Modifying a Form in Design View 26 Entering, Modifying and Sorting Data 28 Entering Data in a Database 28 Creating a New Record 29 Deleting a Record (Data) 29 Field Index Management 30 Record Sorting 31 Record Search 32 Data Retrieval 35 Applying Filters 35 Creating Queries 37 Creating a Query with a Wizard 38 Creating a Query in Design View 41 Information Output 43 Reports 43 Data Export 49 Printing 51 Additional Actions in the Application 55 Application Help 55 Displaying and Hiding Toolbars 56Ĥ MODULE 5 DATABASES In this module, you will learn to: Understand how databases work Work in Base Create database objects Modify database objects Retrieve information from a database Select information according to set criteria Print out data.
The views expressed herein are those of the author and can in no way be taken to reflect the official opinion of the European Union. s/by-sa/3.0 This document has been produced with the financial assistance of the European Union. 1 STUDENT S BOOK 5 th module Using Databases Base This work is licensed under a Creative Commons Attribution- ShareAlike 3.0 Unported License.
0 kommentar(er)
