The European Computer Driving Licence (ECDL) is a European-wide qualification that enables you to demonstrate your competence in computer skills. It covers a range of specific knowledge areas and skill sets, broken down into seven modules. Module 5: Database covers the basic concepts of databases and the ability to use a database on a personal computer. It addresses the design and planning of a simple database, and the retrieval of information from a database through the use of query, select and sort tools. This study guide will take you through all the knowledge areas and skills required to understand and pass Module 5 of the ECDL syllabus. Throughout each chapter we have used clear, jargon free, self-paced exercises that will provide you with an understanding of all the key elements which will prepare you for the ECDL Test.
Introduction: Using this Guide. Data, Databases and Information. Database Management Systems. Uses of Databases. Relational Databases. Queries, Forms and Reports. Some Conventions.- Getting Started: Starting Up Access 97. The Access Window. Opening a Database. Viewing a Table. Modifying a Record. Saving a Database. View Options. Selecting and Modifying Toolbars. Using Access 97 Help. Creating a Database: Designing Tables. Derived Data. Primary Keys. Types of Data. Indexes. Access Database Wizards. The Table Design Toolbar. Creating Tables. Adding Fields. More Data Types. Choosing Field Options. Setting Up Relationships. Entering Data into a Table. Sorting Table Data. Re-arranging Table Columns. Find and Replace. Checking Spelling of Text Fields. Filtering Rows. Printing Tables. Closing Exercises.- Retrieving Information: Queries. Using the Query Wizard. Creating a Simple Query. Specifying Criteria and Using.- Expressions: The Query Design Toolbar. Adding Calculations to Queries. Adding a Filter. Queries Based on More than One Table.- Using Forms: Why Forms are Useful. Basic Forms Ideas. Types of Access Forms. Designing a Form. Creating a Form with the Form Wizard and AutoForm. Form Design Toolbar. Creating a Form using Design View. Adding Graphics to Forms. Printing a Form.- Reporting: When to Use Reports. Some Example Reports. Using the Report Wizard. Report Design Toolbar. Creating a Report Using Design View. Sequence and Group Information in Reports. Using Graphics in Reports.
Overview
The European Computer Driving Licence (ECDL) is a European-wide qualification that enables you to demonstrate your competence in computer skills. It covers a range of specific knowledge areas and skill sets, broken down into seven modules. Module 5: Database covers the basic concepts of databases and the ability to use a database on a personal computer. It addresses the design and planning of a simple database, and the retrieval of information from a database through the use of query, select and sort tools. This ...