Access 2003, Beginner AC-011

Course Overview

Working with databases from the creation of tables to the printing of reports.

Prerequisites

Microsoft Access Beginner

Syllabus

Day 1

Tables:

  • Basic concepts;
  • Tables;
  • Creating a table using a wizard;
  • Entering data in a table;
  • Creating a table without using a wizard;
  • The “Input Mask” property;
  • The concept of primary key;
  • Using the Help function;
  • Importing data;
  • Working with data in a table;
  • Entering data;
  • Copying a record;
  • Deleting a record;
  • Modifying a record;
  • Undoing;
  • Undoing with Access 2002;
  • Modifying the column width;
  • Modifying the row height;
  • Moving columns;
  • Hiding/unhiding columns;
  • Freezing columns;
  • Unfreezing columns;
  • Sorting, filtering, and exporting;
  • Sorting records;
  • Finding and replacing data;
  • Filtering records;
  • Manipulating tables;
  • Exporting data to Word or Excel.

Queries:

  • Queries using wizards;
  • Creating a detailled query;
  • Creating a summary query;
  • Queries without using wizards;
  • Modifying the size of items in the window;
  • Creating a detailled query;
  • Creating a summary query;
  • Creating a calculated field;
  • Modifying a query;
  • Relationships;
  • Understanding the concept of relationships;
  • Creating a relationship;
  • Creating a query based on two tables.

Day 2

Forms:

  • Forms using wizards;
  • Creating an autoform;
  • Creating a form using a wizard;
  • Using a form;
  • The views;
  • Entering data;
  • Copying a record;
  • Deleting a record;
  • Modifying a record;
  • Undoing;
  • Navigating a form;
  • Sorting data;
  • Finding and replacing data;
  • Filtering in a form;
  • Modifying a form;
  • Identifying the form design window components;
  • Hiding/showing a section;
  • Defining a control;
  • Discovering the Toolbox;
  • Modifying the appearance of controls;
  • Autoformatting; Previewing form properties;
  • Inserting a calculated field.

Reports:

  • Reports using wizards;
  • Creating a report without grouping;
  • Creating a report with grouping;
  • Viewing and printing data;
  • Viewing data; Printing data;
  • Modifying a report;
  • Identifying the report design window components;
  • Hiding/showing a section;
  • Defining a control;
  • Discovering the Toolbox;
  • Manipulating controls;
  • Sorting and grouping in a report;
  • Autoformatting;
  • Tips and tricks on reports.
Duration : 2 Days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty
Montreal, 22 to 23 Oct. 2018 - 9:00 to 16:00
290.00 $
Brossard, 22 to 23 Oct. 2018 - 9:00 to 16:00
290.00 $
Laval, 22 to 23 Oct. 2018 - 9:00 to 16:00
290.00 $
Montreal, 5 to 6 Dec. 2018 - 9:00 to 16:00
290.00 $
Brossard, 5 to 6 Dec. 2018 - 9:00 to 16:00
290.00 $
Laval, 5 to 6 Dec. 2018 - 9:00 to 16:00
290.00 $
Montreal, 14 to 16 Jan. 2019 - 9:00 to 16:00
290.00 $
Brossard, 14 to 16 Jan. 2019 - 9:00 to 16:00
290.00 $
Laval, 14 to 16 Jan. 2019 - 9:00 to 16:00
290.00 $