ICDL ECDL Module 5 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
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
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
check back soon there are more topics