Access 2007, Beginner AC-014

Course Overview

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


Prerequisites

Microsoft Access 2007 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 2007;
  • 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.

Share

[ssba]


Duration : 2 days
Regular Rate : $290
Preferential Rate : $220
Notes :


Upcoming Dates

[ESPRESSO_TICKET_SELECTOR event_id=13350]

Duration : 2 days
Regular Rate : 290.00 $
Preferential Rate : 220.00 $
Note :
Upcoming Dates :
price
qty