Full Description
Preface This book is intended to help you successfully complete the test for Module 5 of the European Computer Driving Licence (ECDL). However before we start working through the actual content of the guide you may find it useful to know a little bit more about the ECDL in general and where this particular Module fits into the overall framework. What Is The ECDL? The European Computer Driving Licence (ECDL) is a European-wide qualification that enables people to demonstrate their competence in computer skills. It certifies the candidate's knowledge and competence in personal computer usage at a basic level and is based upon a single agreed syllabus. This syllabus covers a range of specific knowledge areas and skill sets, which are broken down into seven modules. Each of the modules must be passed before the ECDL certificate can be awarded, though they may be taken in any order but must be completed within a three year period. Testing of candidates is at audited testing centres, and successful completion of the test will demonstrate the holder's basic knowledge and competence in using a personal computer and common computer applications. The implementation of the ECDL in the UK is being managed by the British Computer Society. It is growing at a tremendous rate and is set to become the most widely recognised qualification in the field of work-related computer use.
Contents
IntroductionDatabase 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.
