0 of 15 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 15 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
You are designing a table in Access database, and it is used for querying customer’s information later. The Customers table has CustomerID as its PK. When you are thinking to query data by searching the customer’s country, which of the following is the proper design?
You are making a decision to design a workflow for your data loading into Access database. Two tables holding the data are Orders and Suppliers, as below, and you want to determine their relationship. Please choose the correct option for that.
When selecting data from InventoryCode on the table Inventory, you want to use a condition to list the data only if its InventoryName contains the word “Shipping’s”. Which is the good SELECT statement for this goal?
You are building a SQL query for pulling data from Employees table with condition that EmployeeID is no more than 10000. Can you tell which of the following queries can run and return result?
When writing a query, you want the query to possibly return some result. Please choose one of the WHERE clause to achieve the goal.
SELECT OrderID, ProductID
Which of following SELECT queries can return some result, if you want to look for the products without any orders placed?
When evaluating Inventory Code on a table column as Text, which of the following is a proper text value when writing a SQL query?
You are building an on-click event response in VBA, with a pop-up message to show if the event causes the corresponding sub to be called. What will you see when clicking button named btnSetCaption?
Private Sub btnSetCaption_Click ()
Private Sub btnSetCaption_Clicked ()
Private Sub btnSetCaption_OnClick ()
Private Sub btnSetCaption_OnClicked ()
Your manager is asking you to list a report, including Year-Month of Order-sold, Ship-to-Country, with total sales amount received, with the table Orders and OrderDetails as below, and OrderID is the linking key between them. Please choose the correct query for this report.
When determining a variable type in your VBA code, which of the following can take the assignment for the value 8,956,398.2897?
You are designing a form in Access, and wish to pre-load and display some data on the screen when the form is popped up, which of the following is the proper place to do so?
You are trying to design a routine as a function, so that it returns a value when being executed in your VBA code. When designing your function, how to let it return a value when the function is called?
In your VBA code design, you have a number of forms. When a form opens another form, you need to share a data between them, for calculating, storing, and processing. You need to determine a variable used for this data sharing, what of the following is most accurate choice?
List the following steps in correct sequence for running queries and getting result using ADO.
(1) Dim conn As ADODB.Connection
(2) Dim rs As ADODB.Recordset
(3) Dim sql As String
(4) Set connection to conn
(5) Set rs as NEW …
(6) rs.Open sql, conn
(7) Sql = “SELECT … YOUR QUERY …”
(8) Get the query result from rs and process it
(9) Close rs and Set rs = Nothing
(10) Close conn and Set conn = Nothing
However, there is a logic issue with the design above, with two lines in the wrong sequence. Can you tell which as marked in the workflow are in the incorrect order?
When tuning your VBA code, you want to use debugging to trace the code running. Which of the following step is usually the first step to take when you start the debugging?