ECDL - Module Five
Database
Overview
This module requires the candidate to understand some of the main concepts of databases and demonstrate the ability to use a database on a computer. The candidate shall be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The candidate shall be able to relate tables and to retrieve and manipulate information from a database by using query and sort tools available in the package.
Duration
1 day.
Course Content
Using the Application
Database Concepts
- What is data?
- What is a database?
- What is a relational database?
- What is a table?
- What is a record?
- What is a field?
- What is meant by 'Field data types'?
- What is meant by 'Field properties'?
- What is a primary key?
- What is an index?
- Why relate tables?
- Design and document your database!
- Questions to ask yourself
- Define your needs
- Basic design rules
First Steps with Databases
- To start Access
- To close Microsoft Access
- To open a database
- To create a new database
- To save a database
- To save a database file to a diskette
- What is the Microsoft Office Assistant?
- To display the Microsoft Office Assistant
- To hide the Microsoft Office Assistant
- To disable the Microsoft Office Assistant
- To use "What is this" Help
- The Help drop down menu
- Help Menu - Microsoft Access Help command
- Help Menu - Office on the Web
- Help Menu – Activate Product
- Help Menu - Detect and Repair
- Help Menu - About Microsoft Access
- To close a database
Adjust Settings
- To switch between views when using tables, forms or reports
- To switch between Design and Datasheet View
- To display or hide a toolbar (using the View menu)
- To display or hide a toolbar by right-clicking
Tables
Main Operations
- To create a table and specify field data types
- To add records to a table
- To delete records within a table
- To add a field to an existing table
- To add data to a record
- To modify data within a record
- To delete data within a record
- To use the Undo command
- To navigate through a table to edit records
- To move to a field using the mouse
- To move through the table using the keyboard
- To move from record to record using the scroll bar and mouse
- To move to a specific record using the Edit menu
- To move to a specific record using the keyboard
- To delete a table
- To save a table
- To close a table
Define Keys
- To define a primary key (automatically when creating a table)
- To define a primary key (manually after a table has been created)
- Index a field without duplications allowed
- Modifying the way a field is indexed
Table Design Layout
- To change field format attributes.
- Make sure that your field size attributes are long enough!
- To create a validation rule for a number
- To create a validation rule for text
- To create a validation rule for a date or time
- To create a validation rule for currency
- To change the width of a column
- To move a column(s)
Table Relationships
- To create a one-to-one relationship between tables
- To create a one-to-many relationship between tables
- To delete a relationship between tables
- To enforce referential integrity
Forms
Working with Forms
- To open a form
- To create a form using the AutoForm Wizard
- The Form Wizard
- To create a form using Form Wizard
- To enter data into a form
- To modify data using a form
- To delete records using a form
- To navigate through a form
- To add text into headers or footers within a form
- To modify the header or footer text within a form
- To delete a form
- To save a form
- To close a form
Retrieve Information
Main Operations
- To begin a search
- To search using wildcard characters
- To find a specific value
- To find another occurrence of the same value after you have closed the dialog box
- What is a filter?
- To filter records in a table datasheet by selection
- To filter records in a table datasheet by form
- To apply the filter
- To remove the filter
Queries
- What are queries?
- To create a query using the Simple Query Wizard
- To select fields which you wish to add to your simple query
- To create a query without the wizard
- To use the query grid
- To run a query
- To search using wildcard characters
- To add criteria to a query
- To remove criteria from a query
- To add a field to a query
- To remove a field from a query
- To move a field in a query
- To hide a field in a query
- To show a field in a query
- To run a query
- To delete a query
- To save a query
- To close a query
Sort Records
- Sorting records
- To sort records in a table datasheet
- To sort records in a form or query
Reports
Working with Reports
- Introduction to reports
- To create a columnar report using AutoReport Wizard
- To create a tabular report using AutoReport Wizard
- To create a report using Report Wizard
- To select which fields to add to a report
- To add grouping levels to a report
- To sort records within a report
- To determine the layout of a report
- To determine the style of a report
- To name a report
- To alter the position of fields and headings in a report
- To group information in a report
- To calculate statistics for groups in a report
- To add text to a report header or footer
- To modify text within a report header or footer
- To delete a report
- To save a report
- To close a report
Prepare Outputs
Prepare to Print
- To preview a table, form or report, prior to printing
- To change a reports orientation
Print Options
- To set what you want to print
- To print a query
- To print a table, query or report to a file