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.
CONTENT AND OBJECTIVES:
Coding a parameter query is similar to the select query; the difference is that the select query is static and the parameter query prompts the user for selection criteria before running.
Code and test a AutoLookup queries.
Enter one value into a query; based on a related table, the query fills in the remaining values in the table datasheet.
Use the wizard to generate and design a form.
Modify the generated form.
Create a form and subform at the same time.
Create a subform and add it to another form.
Create a form with two subforms.
Create a form with nested subforms.
Test the performance benefits of using an index.
Create and use a unique index.
Use the Macro Builder to create a macro.
Create a stand-alone macro.
Macros: Adding Functionality
Create an embedded macro.
Specify conditions to control a macro.
Group Macro: Creation
Create a macro group with several related macros.
Create a switchboard.
Add and delete items to a switchboard.
Edit items in a switchboard.
Display the main switchboard on startup. n~Report Design.
Use control layouts to align data.
Add and remove report page header and footer sections.
Alternating line colors on the report.
Conditional formatting of the report.
Grouping Data in a Report
Create a report that allows data to be grouped on a column using the Report Wizard.
Create a report that allows data to be grouped on non-standard numeric ranges.
Running Summary: Creation
Use a DSum function and criteria in a query to create a running sum.
Use a totals query with a DSum() function to create a running total over a group.
Date/Time Control: Inserting
Place the DateTime picker control on the form; then specify whether the user is to select a date or time.
Bind the form to a Date/Time field and the format for the date or time.
Effective February 27, 2012, the course dates listed on the SYS-ED 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. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED 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 SYS-ED course and that the employer has a licensed version of the software.