ECDL UK SAMPLES
    ECDL UK PRICES
    CONTACT US

  

INFORMATION

START HERE - UK ECDL   Practice Questions   What you get   ECDL in the UK   Company Profile   Client List   Newsletter   Contact Us

ECDL 5 UK Edition  Outlines & Samples

IT Security for Users   IT User Fundamentals   Internet & Email   Word Processing   Spreadsheets   Databases   Presentation   Improving Productivity

ECDL Advanced 2.0   Outlines & Samples

Word Processing   Spreadsheets   Databases   Presentation   Improving Productivity

1500 + ECDL 5  Practice Questions

Practice Questions

Course Outlines   Level 1 Courseware

IT Security for Users   I T User Fundamentals   Internet & Email   Word Processing   Spreadsheets

Course Outlines   Level 2 Courseware

Databases   Presentation   Spreadsheets   Word Processing

Course Outlines   Level 3 Courseware

Word Processing   Spreadsheets   Databases   Presentation

Windows 7 / Office 2010

Windows 7     Office 2010

Contact Us

ECDL 5 - Databases
BCS Level 2 Courseware - Course Outline

DATABASE CONCEPTS

• What is a database?
• What are databases used for?
• What is a relational database?
• What is a table?
• What is a record (row)?
• What is a field (column)?
• What is data?
• The difference between data and information
• Data types
• Common uses of large-scale databases
• Database designers, database administrators and database users

A FIRST LOOK AT ACCESS 2007

• Opening Access 2007
• Exploring the Access 2007 window
• The Ribbon (Toolbar)
• Ribbon tabs
• Groups & Dialog Box Launcher
• Navigating - Quick keys (shortcut keys)
• Navigating – Pointer keys & quick keys
• Navigating – Mouse wheel
• Contextual tabs
• Minimising the Ribbon
• Quick Access Toolbar
• The Office Button
• Microsoft Access Help

OPENING A DATABASE & SECURITY ISSUES

• Opening a database
• Security warnings
• Trusted Locations - Trust Centre
• Setting the default folder location within Access

CREATING A DATABASE & USING VIEWS

• Creating a new database
• Creating a new blank database
• Saving a table
• Adding and renaming fields
• Using Datasheet View
• Using Design View
• Changing the view

TABLE MODIFICATION AND NAVIGATION

• Adding Fields - Design ViewData Type - Overview
• Data Type - Descriptions
• Using the Attachment data type
• Adjusting column width
• Moving a column to rearrange the column order
• Adding records to a table
• Navigating through records within a table
• Navigation Pane

FIELD PROPERTIES, VALIDATION & INPUT MASKS

• Field Properties
• Input Mask
• Validation Rules
• Field Properties - Guides Tables

MANIPULATING RECORDS & TABLES

• Closing an Object - Table
• Renaming an Object - Table
• Editing data within a record
• Deleting data within a record
• Using the Undo command
• Deleting a single record
• Deleting multiple records
• Save As – Database Object
• Deleting a table

PRIMARY KEYS AND INDEXING

• Defining a Primary Key
• Indexing
• Creating a single-field Index
• Creating a multiple-field Index
• Deleting multi-field indexes

FILTERING & SORTING

• Text Filters
• Applying a single filter
• Clearing a single filter
• Creating multiple filters
• Clearing multiple filters
• Sorting

RELATIONSHIPS

• Table relationships
• One-to-many relationship
• Many-to-many relationship
• One-to-one relationships
• Creating relationships between tables
• Referential integrity
• Cascade options
• Cascade update related fields
• Cascade delete related records
• Enabling cascade options
• Deleting relationships

ACCESS 2007 FORMS

• Forms overview
• Creating forms
• Modifying forms
• Modifying a form title
• Modifying a form logo
• Modifying a form label
• Saving a form
• Form View
• Adding and formatting attachments
• Modifying records
• Deleting records
• Adding records
• Closing forms
• Opening forms
• Deleting a form

ACCESS 2007 QUERIES

• What are queries?
• Creating a simple query
• Adding criteria to a query
• Running a query
• Editing criteria in a query
• Saving a query
• Creating a two table query and sorting the results
• What are Wildcards?
• Deleting a query

ACCESS 2007 REPORTS

• What are reports?
• Creating a simple report
• Using the Report Wizard
• Modifying the layout of a report
• Widening a report column
• Modifying the report title
• Adding logos to a report
• AutoFormating a report
• Modifying field names within a report
• Inserting and formatting the date & time
• Adding available fields to a report
• Resizing reports for printing
• Closing a report
• Deleting a report

ACCESS 2007 PRINTING & EXPORTING ISSUES

• What does exporting data mean?
• What is a spreadsheet format?
• What is text only and CSV format?
• What is an XML file?
• Exporting a table or query output as an Excel spreadsheet using the Export Wizard
• Exporting a table or query output as a text file using the Export Wizard
• Exporting a table or query output as an XML formatted file using the Export Wizard
• Considerations before printing
• Print previewing
• Which orientation, portrait or landscape?
• Adjusting layout in Print Preview
• Setting margins
• Printing a complete table
• Printing selected records
• Printing a query or reports
• Printing forms