WorksheetsDATABASE
Total questions: 30
Worksheet time: 12mins
What is the visual indication of table relationship?
line connection
pop up lines
broken lines
asterisk on the table
What output can be created with this mmmm: dd : ddd : yyyy
Feb : 14 : Thursday : 2019
February : 14 : Thurs : 2019
February : 7 : Thursday : 2019
February : 07 : Thurs : 19
Which of the following is a procedure under creating of table?
create criteria
SQL mode
insert forms
grouping and tabular layout
editing lookup values
Which are orientation of reports?
portrait
landscape
slant
zoom out
Which object cannot be inserted in the form?
textbox
button
toggle button
option group
timer
What SQL code means all?
astrerisk *
parenthesis ( )
slash /
hypen -
Which operator should be used for either criteria must be satisfied?
and
or
but
not
Which operator must be used if either of the conditions must be satisfied, refer as to union as well?
OR
NOT
AND
YET
"Babe, I'm done appending the new records", Lian told to Zac... What does append means?
New record added at the last
New record added at the middle
New record added at the first
New record added at both first and last
"My love Lyan, I want you to make this every record match to several record to other table", Zach said. What relationship does the couple wanted to establish?
one to many
one to one
many to one
many to many
Which one is a literal values?
"mango shake"
[brandName]
max( )
sum()
What sql code is as sames as the criteria?
where
as
select
sort by
from
What is codes indicate table name?
Select Name, Age, Address from Dynamics where Age >=18
Dynamics
Age >=18
Select Name, Age, Address
Ascending or Descending is
types of _____.
sorting
filtering
select
category
Functions that show table's lowest number or value.
min()
lower()
low()
lowest()
Kyan Ysibido will put pictures on the record of Francheska on the table. What data type could allow it?
attachment
text
photo
image
What is the view that is only for reports only?
print preview
edit view
i love view
design view
mines view
Which layout is intended for reports with groupings?
block
tabular
columnar
justified
What makes the primary key autonumber?
increment
no duplication
numbering
When you use Lookup values,
______ will appear.
Combo box
textbox
label
toggle text
using of criteria is as same as ________.
filtering
sorting
grouping
updating
sending
What is count() ?
count the records returned by a query.
total the records returned by a query.
averaging the records returned by a query.
maximizing the records returned by a query.
Selecting items from lists, helping you create expressions faster and more accurately is involved in_______.
sql
query wizard
query design
expression builder
Which procedure involved reports?
computing using criteria
print preview of query
building forms
data types
Answerable by two answers
yes/no
attachment
ole object
text
Format of this : hh-nn-am/pm
07:13:pm
12-02-am
11-5-pm
1-05pm
Startup Screen means _______.
shortcut to the selected screen
screen to be terminated immediately
first screen to be display
last screen to be display
Several records match to Several records
one to one
one to many
many to many
many to one
Default values can be found in what part of database
field properties
lookup values
criteria
expression builder
Report Layout with grouping
Stepped
Tabular
