单项选择题

A.Add an order by clause to the query. B.In the data mo……

In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）

A.Add an order by clause to the query.
B.In the data model double click the ID_number column and alter the break order.
C.In the layout model double click the ID_number filed and later the print direction.
D.Default the layout, choose a master/detail report style and select ID_number as the break order.

<上一题目录下一题>

热门试题

单项选择题Youarecreatingatabularreportforthesalesdepartmentwithadepartmentbreakgroup.Youneedtoensurethatifalleastsixsalesrecordswillnotfitatthebuttonofapage,thegroupwillstartonthenextpage.Whichprintingframepropertywouldyoualtertoachievetheseresults?（）

A.Source
B.Print direction
C.Maximum records per page
D.Minimum Widow records
E.Column mode

单项选择题Youaredevelopingareporttoallowcustomersinadepartmentstoretoviewproductinformation.Youaddedabuttontothelayouttoallowcustomerstoviewthepictureoftheproduct.Whichbuttonpropertywouldyoualtertospecifythesourceofthe.BMPfile?（）

A.Type
B.Multimedia file
C.Multi media file type
D.Label type

单项选择题Whichtoolinthelayoutmodelcouldyouusetocreateanexternalboilerplateobject?（）

A.Field
B.Frame
C.Button
D.Rectangle
E.Link file

单项选择题Thehumanresourcesdepartmentrequestedanemployeereporttohighlightthoseemployeeswhoareduefor30days6monthsand1yearevaluation.Thehigher_datafieldshoulddisplaybluetextfor30daysemployee,aredtextfor6monthsemployeesandagreentextforoneyearemployees.Youcreatedaformattriggeronthehigher_datafieldtohandlethistask.Whatwillhappeniftheformattriggerreturnsafalsevalue?（）

A.The report execution will be halted.
B.The higher_data file will not be displayed.
C.The record will not be displayed.
D.Nothing will happen.

单项选择题YoucreatedareportfromthehumanresourcesdepartmentbasedonallthecolumnsintheEMPtable.Afterviewingthereportusersrequestedthatthecmp_IDcolumnspeersfirstintheoutput.Howwouldyouchangethepositionofthecolumn?（）

A.After the query.
B.Enter the report and change the column's position in the field tab.
C.Alter the column's position in the object navigator.
D.Enter the report wizard and change the column's position in the data tab.
E.Alter the column's position within its group and change the layout.