Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

When you register for training with TrainUp.com, you are also supporting local education. Find out how.
  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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.

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.