Hands-On 01 (Schema Builder)
Q:
How can you create
a table using the "Schema Builder" tool?
Q:
How can you define a
column, attribute, and primary key using the "Schema Builder" tool?.
Q:
How can you define a
required field and unique key using the "Schema Builder" tool?.
Q:
How can you grant an object
privilege to the public using the "Schema Builder" tool?
Q:
How can you check what other
users can access using the "Schema Builder" tool?
Q:
How can you remove a table using
the "Schema Builder" tool?
Hands-On
02 (Query Builder)
- Manuscript
Q:
Create a query using the
"Query Builder" tool.
Q:
How can you join multiple tables using the "Query Builder" tool?
Q:
How can you establish table relationship between multiple tables using the
"Query Builder" tool?
Q:
Execute a query using the "Query Builder" tool.
Q:
Sort a query using the "Query Builder" tool.
Q:
How can you add a "WHERE" clause condition to a query using the
"Query Builder" tool?
Q:
List a query using the "Query Builder" tool.
Q:
Save a query using the "Query Builder" tool.
Hands-On
03 (Procedure Builder)
Q:
Write a stored procedure
to add a record into the department table using the "Procedure
Builder" tool.
Hands-On
04 (Form Builder)
Q:
How can you create a "Datablock" for a form application using
the "Form Builder" tool?
Q:
How can you create a
"layout" for a form application using the "Form Builder"
tool?
Q:
How can you use a "Content canvas" for a form application using
the "Form Builder" tool?
Q:
Use the "Execute Query" option to query customer's information.
Q:
How can you navigate a table using the "Form Builder" tool?
Q:
What does the "NEXT RECORD" option do?
Q:
What does the "PREVIOUS RECORD" option do?
Q:
What does the "Enter Query" option do?
Q:
How can you manipulate table's reocd?
Q:
Insert, delete and update a record.
Q:
How can you save a transaction using the "Form Builder" tool?
Hands-On
05 (Report Builder)
Q:
How can you use the "Report Wizard" tool in the "Report
Builder" tool?
Q:
How can you use the "Object
Navigator" window?
Q:
How can you write a report?
Q:
How can you save a report?
Q:
How can you use the "Data Model" tool?
Q:
What is the "Property Palette" sheet?
Q:
What is the "Query" box in the "Data Model" window?
Q:
What is the "Group" box in the "Data Model" window?
Q:
How can you change a report style?
Q:
Use a tabular style for a report.
Q:
How can you navigate through your report?
Q:
How can you change a format mask for an item in the "Report
Builder" tool?
Hands-On
06 (Graphics Builder)
Q:
How can you create a chart using the "Graphics Builder" tool?
Q:
How can you run a query
against a chart?
Q:
How can you modify a query?
Q:
How can you save a query?