BG@100 ERP Project
| Query Information | Viewer | Manager | Documentation | FAQs |
Query Manager Class Descriptions
This web page focuses on users who will be requesting Query Manager Access. The following classes are associated with Query Manager Access:
|
Query prerequisite classes are provided to Query users by online training available through MyBGSU. Offering classes in this manner allows users to proceed through the material at their own pace and users are invited to return to the course material as often as desired to review information and details.
Each class will present information on the designated topic and will also include a quiz component. For each class, completion of the quiz with a score of 80% or higher is required prior to requesting security access. The class material and quiz may be repeated as many times as the user desires. It is also possible to stop progressing through the material as needed and to return to the same point at a future time.
In addition to the prerequisite classes, a hand-on class is required.
Request for Security Access
Security Access for Query Manager may be requested following successful completion of the two prerequisite online classes and the hands-on class. Access may be requested by selecting Query Manager access using one of the Security Access Request forms and following the documented submission process.
The following is a listing of the classes associated with Query Manager training.
Users completing this class will learn the definitions of different types of software as well receiving an introduction to the concept of a database management system (DBMS) and relational database management system (RDBMS). This training class will also cover identification of the elements of a table or record using PeopleSoft terminology. This is an online course accessible via MyBGSU. Completion of this online prerequisite classes and successful completion of the associated quiz with a score of 80% or higher is required prior to requesting Query Manager security access. Campus Solutions (CSS) users are required to have successfully completed CSS 110-140 prior to enrollment in this class. |
Documentation for Query prerequisite online classes: |
This class covers two lessons pertaining to Query Viewer. Lesson One is entitled View a Query and it guides users through the Basic Search process. This process is covered through to viewing the query to HTML and saving the query to "Favorites". Lesson Two is entitled View a Query Using Prompts and it guides users through the process of using Advanced searching along with running the query results to Excel. This is an online UPK class accessible via MyBGSU. Completion of this online prerequisite classes and successful completion of the associated quiz with a score of 80% or higher is required prior to requesting Query Viewer security access. Campus Solutions (CSS) users are required to have successfully completed CSS 110-140 prior to enrollment in this class.
|
Documentation for Query prerequisite online classes: |
The Query Manager Class is a training environment with hands-on participation by attendees. The hands-on class is offered in a two-day, full day class format. Participants are also required to have PeopleSoft access. The Query Manager class will cover the creation of simple queries, editing of fields, editing of criteria, and will work with creating prompts. Other topics include applying join (auto, manual, and related records), writing expressions, using prompts with expressions and the use of aggregate functions. In addition, the lab will provide applicable examples and participants will work through group and individual query problems. Participants will perform exercises surrounding sub queries, the use of outer joins, using unions, and finding the right records and fields. Query Manager sessions will be offered on two days within a one week period. Participants will be required to attend both days during the same one week period. |
|
MyBGSU
Email
Search
Directory
Academics
Admissions
The Arts
Athletics
Library
A to Z Links
Bowling Green State University