PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
User
Business Professional
DATES:
CONTENT AND OBJECTIVES:
Table Creation
Create a new database and an inventory table.
The columns in the table will contain text, numeric and date attributes.
Table Data
Populate the table with data using basic data entry screens.
Table Modification
Change a single row.
Change all the rows.
Field Properties: Setting
Add a new column to the table and populate the column.
Finding and Filtering Data
Extract all rows from a specific warehouse.
Extract all rows from multiple warehouses.
Simple Queries
Search columns for a string.
Extract based on a range of values.
Use the LIKE clause to extract data.
Create a derived column.
Calculate values using an aggregate function.
Calculate a value using a scalar function.
Operators in Queries
Perform concatenation of string.
Reformat a string.
Execute basic mathematical expressions.
Perform data arithmetic.
Query design
Use the GUI to generate and execute SQL.
Code a simple join and subquery.
Action Queries: creating
Using SQL DML statement insert, change, and delete rows in the table.
Form Creation
Create a form to perform data entry on the inventory table.
Design View
Design a basic detail report.
Design multiple summary reports.
Design a detail report with subtotals and grand totals.
Reports
Display and print a report.
Modify the reports design and display the results.
Change the sort order of the report.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
