资源描述:
《计算机二级选择题(computer two level multiple-choice questions)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、计算机二级选择题(Computertwolevelmultiple-choicequestions)Operationquestions(2007-6)Completethefollowingoperations:(examineefolderisK:ADMINISTRATOR3720001)Note:ifthereisnospecificdescription,thefolderwherethefilesarecandidatesfolder.1.EstablishprojectCreateaprojectPROJ4.PJX,addfreetabl
2、ePUB22.DBFandprogramfilePROG1.PRG,andbuildintheprojectThefifthitemmenuMENU2.MNX.2.Databaseoperations1)createdatabaseGYDB2.DBC,addtableGYS41.DBFandGYXX42.DBF.2)completethefollowingoperationsontableGYS41.DBF:Thedefaultvalueofthe"city"fieldis"Beijing"";Second,theascendingmainindexna
3、med"supplyfirm"isestablishedaccordingtothesupplyfirm;3.Appendthefollowingrecords:S0401TorchGroupBeijing03/22/2007.T.3)establishaonetomanypermanentrelationshipbetweenthetableGYS41.DBFandGYXX42.DBFaccordingtothesupplyfirm.3,querydesignUsequerydesignertocreatequeryINQU4.QPR,andquery
4、bytablenumberintableSDB12.DBFandKCB12.DBFThetotalamountofmerchandiseinventoryineachstore,thedisplayfieldisfollowedbystorenumber,storenameandtotalinventory,andwillqueryResultsarestoredinfileINQU4.DBF.4,reportdesignUsethereportwizardestablishreportingtablewithBOOKBB2.FRXBOOK.DBF,in
5、press,ISBN,titleandoutputPrice,ISBNrecordsinascendingorder,summarizethebardisplaypricesummaryreporttitled"longitudinaloutputofbooksList".5,menudesignThemenuMENU2.MNXissetupwithmenudesigner,andtherearethreemaindishes:fileoperation,informationqueryanddataupdateThefileoperationitemi
6、ncludesthreesubmenuitems:open,saveandclose"TheshortcutkeyoftheitemisCtrl+X,andthefunctionistoclosethecurrenttablefile.Completethefollowingoperations:(examineefolderisK:ADMINISTRATOR3720002)Note:ifthereisnospecificdescription,thefolderwherethefilesarecandidatesfolder.1.Establish
7、projectCreateaprojectPROJ3.PJX,addfreetableSDB12.DBFandmenufileMENU42.MNX,andnewintheprojectBuildprogramfilePROG3.PRG(unlimitedcontent).2.Databaseoperations1)createdatabaseGYDB1.DBC,addtableCITY42.DBFandGYXX41.DBF.2)completethefollowingoperationsontableGYXX41.DBF:Insertthenewfiel
8、d"unitprice"beforethe"quantity"field,num