Font size:

The content of this course allows an individual to gain knowledge of the main concepts of a database and how to use a database computer application. The individual will learn how to create and modify tables, queries, forms and reports. The individual will also learn to relate tables and to retrieve and manipulate information in a database by using queries and sorting tools.

Learning Objectives
  • Identify advantages of a relational database.
  • Identify the basics of a relational database.
  • Sequence the steps for planning a relational database.
  • Open Access 2000.
  • Open an existing database with the default layout.
  • Create a blank database.
  • Identify the options available when creating a database by using a database template.
  • Identify the functions of database object views.
  • Change the default toolbar display.
  • Create a table in Datasheet view.
  • Identify features of the Table Wizard
  • Create a table in Design view.
  • Delete a table.
  • Get help by using the Office Assistant.
  • Identify features of the Help window.
  • Create a field for a table.
  • Modify a field property in a table.
  • Set a field as a primary key.
  • Set an index for a field in a table.
  • Validate data integrity in a table.
  • Enter data into a table in Datasheet view.
  • Modify data in a table.
  • Find a record based on given criteria.
  • Sort records in a table.
  • Filter by selecting a value in Datasheet view.
  • Identify the options for navigating records.
  • Resize the width of a column in Datasheet view.
  • Move a field in a table in Datasheet view.
  • Identify features of relationship rules.
  • Create a one-to-many relationship between tables.
  • Identify features of the Form Wizard.
  • Add a header and a footer to a form.
  • Modify a header and footer in a form.
  • Add a record to a form.
  • Modify records in a form.
  • Sort records in a form.
  • Create a simple query.
  • Create a multiple-table query using search criteria.
  • Refine a query.
  • Identify ways of manipulating fields in a query.
  • Sort records in a query.
  • Identify features of the Report Wizard.
  • Modify a control layout in a report.
  • Set sorting properties for a report.
  • Set group properties for a report.
  • Add a header and footer to a report.
  • Modify the header and footer of a report.
  • Identify the options for summarizing fields in a report.
  • Identify print preview options.
  • Identify options in the Page Setup dialog box.
  • Identify options in the Print dialog box.
Register Now
ICDL Module 5: Database Online course
  • Course ID:
  • Duration:
    480 minutes
  • Price: