ICDL Using Databases study plan

Define the terms database, table, record, field, and data type in your own words

Identify at least five real-world scenarios where a relational database is preferable to a spreadsheet

Open a database application and locate the objects pane, ribbon/toolbar, and navigation pane

Create a new blank database file and save it with a descriptive name

Create a single table in Design/Design View and assign a data type to every field

Select the most appropriate data type for text, numbers, dates, currency, and yes/no content

Set a primary key on an appropriate field and explain why that field was chosen

Apply field properties such as field size, required, default value, and input mask to at least three fields

Insert, edit, and delete records in Datasheet View without corrupting existing data

Sort records on a single field in ascending and descending order

Distinguish between flat-file and relational structures and describe why tables are split into related entities

Create a second table that stores related data and link the two tables with a one-to-many relationship

Enforce referential integrity on the relationship and predict what happens when it is enabled

Apply a validation rule and validation text to reject invalid entries

Modify an existing table structure by adding, renaming, and removing fields without losing records

Filter records using filter-by-selection and a filter-by-form/criteria approach

Build a query in Design View that returns selected fields from one table

Add numeric and date criteria to a query and verify the returned record count

Use comparison operators and wildcards in query criteria

Sort query output on more than one field

Create a query that draws fields from two related tables

Construct AND criteria across multiple fields and explain how it narrows results

Construct OR criteria and explain how it broadens results

Write a calculated field or aggregate query using at least one function such as Count, Sum, or Average

Use a parameter prompt so a query asks for its criterion at run time

Create a form using a wizard and adjust the layout and field order

Enter and edit records through the form rather than the table

Generate a report from a table or query and group the output on one field

Add a calculated total or summary to a report and preview it before saving

Export a query result or report to a common file format and confirm the output opens correctly

Customize the application environment by setting a startup option or default object view

Back up the database file and restore from the backup

Import data from an external file into a new table and reconcile data types

Use help or documentation to resolve one unfamiliar feature independently

Apply a consistent naming convention to all tables, queries, forms, and reports

Review all four domains against the official syllabus and flag any objective you cannot demonstrate

Rebuild a small two-table database from scratch in under 45 minutes without notes

Complete two timed practice assessments and record your score per domain

Re-study only the weakest domain identified by the practice scores

Verify every deliverable from weeks 1-7 still opens and functions correctly