+ADwAIQ-DOCTYPE html PUBLIC +ACI--//W3C//DTD XHTML 1.0 Strict//EN+ACI- +ACI-http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd+ACIAPg- +ADw-html xmlns+AD0AIg-http://www.w3.org/1999/xhtml+ACI- xml:lang+AD0AIg-en+ACI- lang+AD0AIg-en+ACIAPg- +ADwAIQ--- Mirrored from /odesk-test-answers/databases/ms-access-2000-test-answers-2015.html by HTTrack Website Copier/3.x +AFs-XR+ACY-CO'2007+AF0-, Sat, 26 Mar 2016 18:05:05 GMT --+AD4- +ADw-head+AD4- +ADw-meta http-equiv+AD0AIg-content-type+ACI- content+AD0AIg-text/html+ADs- charset+AD0-utf-8+ACI-/+AD4- +ADw-link rel+AD0AIg-stylesheet+ACI- type+AD0AIg-text/css+ACI- href+AD0AIg-../../css/main.css+ACIAPg- +ADw-title+AD4-Upwork (oDesk) test answers - MS Access 2000 Test 2016 - Databases+ADw-/title+AD4APA-meta name+AD0AIg-keywords+ACI- content+AD0AIg-Upwork (oDesk) test answers, Elance test answers, +ACI- /+AD4APA-meta name+AD0AIg-description+ACI- content+AD0AIg-You'll find out here all Upwork (oDesk) test answers for MS Access 2000 Test 2016. See correct test answers ...+ACI- /+AD4- +ADw-link rel+AD0-'shortcut icon' type+AD0-'image/x-icon' href+AD0-'../../favicon.ico' /+AD4- +ADw-meta name+AD0AIg-viewport+ACI- content+AD0AIg-width+AD0-device-width, initial-scale+AD0-1, maximum-scale+AD0-3+ACIAPg- +ADw-/head+AD4- +ADw-body+AD4APA-div id+AD0AIg-fact+ACIAPg-Do you know that? +ADw-b+AD4-men (21+ACU-) are much more likely than women (11+ACU-) are to moonlight as a freelancer+ADw-/b+AD4- +ADw-a href+AD0AIg-ms-access-2000-test-answers-2015/questions.html+ACIAPg-next+ADw-/a+AD4APA-/br+AD4APA-/br+AD4APA-strong+AD4-Contact Email: teammmrem+AEA-yahoo.com+ADw-/strong+AD4APA-/div+AD4APA-div id+AD0AIg-test+ACIAPg- +ADw-p+AD4APA-a href+AD0AIg-../../all-odesk-elance-test-answers-2015.html+ACIAPgA8ADw- All Upwork (oDesk) and Elance Tests+ADw-/a+AD4- +ADwAPA- Upwork (oDesk) test answers +ADwAPA- Databases category+ADw-/p+AD4- +ADw-h1+AD4-Test answers for MS Access 2000 Test 2016+ADw-/h1+AD4- (+ADw-a href+AD0AIg-ms-access-2000-test-answers-2015/questions.html+ACIAPgA8-span id+AD0AIg-rb+ACIAPg-56+ADw-/span+AD4APA-/a+AD4-, +ADw-span id+AD0AIg-yb+ACIAPgA8-a href+AD0AIg-../../upwork-odesk-cover-letters/examples/ms-access.html+ACIAPg-CL+ADw-/a+AD4APA-/span+AD4-)+ADw-sup+AD4- Last updated: January 27+ADw-/sup+AD4APA-div+AD4APA-b+AD4-Upwork (oDesk)+ADw-/b+AD4AJg-nbsp+ADsAJgAj-8226+ADsAJg-nbsp+ADsAPA-b+AD4-Databases+ADw-/b+AD4APA-/div+AD4- Questions and answers are regularly updated. Answered and not answered tests questions.+ADw-p+AD4APA-strong+AD4-This helps getting job:+ADw-/strong+AD4- Hundreds of (+ADw-a href+AD0AIg-../../upwork-odesk-cover-letters/upwork-odesk-cover-letters-examples.html+ACIAPg-cover letter examples+ADw-/a+AD4- , +ADw-a href+AD0AIg-../../articles/interview-questions-answers/job-questions-answers.html+ACIAPg-interview questions+ADw-/a+AD4- , +ADw-a href+AD0AIg-../../upwork-odesk-freelancer-profiles/freelancers-profile-samples.html+ACIAPg-profile samples+ADw-/a+AD4- ) +ACYAIw-8226+ADs- +ADw-a href+AD0AIg-../../articles/odesk-how-to-earn.html+ACIAPg-Earn on Upwork (oDesk)+ADw-/a+AD4- +ADw-/br+AD4APA-strong+AD4-Job assistance:+ADw-/strong+AD4- +ADw-a href+AD0AIg-../../upwork-odesk-freelancer-job-positions/freelancers-job-positions-popularity.html+ACIAPg-jobs popularity+ADw-/a+AD4- +ACYAIw-8226+ADs- +ADw-a href+AD0AIg-../../freelance-job-rates/all-freelance-hourly-rates.html+ACIAPg-freelance rates+ADw-/a+AD4- +ADw-/p+AD4- +ADw-p+AD4-Popular test answers: +ADw-a href+AD0AIg-../../popular-odesk-elance-html-tests-answers.html+ACIAPg-HTML+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-net-tests-answers.html+ACIAPg-.Net+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-css-tests-answers.html+ACIAPg-CSS+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-english-tests-answers.html+ACIAPg-English+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-seo-tests-answers.html+ACIAPg-SEO+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-photoshop-tests-answers.html+ACIAPg-Photoshop+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-ios-tests-answers.html+ACIAPg-iOS+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-java-tests-answers.html+ACIAPg-Java+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-android-tests-answers.html+ACIAPg-Android+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-ruby-tests-answers.html+ACIAPg-Ruby+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-python-tests-answers.html+ACIAPg-Python+ADw-/a+AD4-, +ADw-a href+AD0AIg-../../popular-odesk-elance-javascript-tests-answers.html+ACIAPg-JavaScript+ADw-/a+AD4APA-/p+AD4- +ADw-p+AD4-See all +ADw-a href+AD0AIg-../../odesk-elance-test-answers-most-recently-updated.html+ACIAPg-6 tests answers+ADw-/a+AD4- updated +ADw-/p+AD4- +ADw-p+AD4-Find Upwork (oDesk) and Elance test answers on this website:+ADw-/p+AD4- +ADw-script type+AD0AIg-text/javascript+ACIAPg- var infolinks+AF8-pid +AD0- 2840970+ADs- var infolinks+AF8-wsid +AD0- 0+ADs- +ADw-/script+AD4- +ADw-script type+AD0AIg-text/javascript+ACI- src+AD0AIg-//resources.infolinks.com/js/infolinks+AF8-main.js+ACIAPgA8-/script+AD4- +ADw-script type+AD0AIg-text/javascript+ACIAPg- amzn+AF8-assoc+AF8-placement +AD0- +ACI-adunit0+ACIAOw- amzn+AF8-assoc+AF8-search+AF8-bar +AD0- +ACI-true+ACIAOw- amzn+AF8-assoc+AF8-search+AF8-bar+AF8-position +AD0- +ACI-top+ACIAOw- amzn+AF8-assoc+AF8-tracking+AF8-id +AD0- +ACI-ranahassan-20+ACIAOw- amzn+AF8-assoc+AF8-ad+AF8-mode +AD0- +ACI-search+ACIAOw- amzn+AF8-assoc+AF8-ad+AF8-type +AD0- +ACI-smart+ACIAOw- amzn+AF8-assoc+AF8-marketplace +AD0- +ACI-amazon+ACIAOw- amzn+AF8-assoc+AF8-region +AD0- +ACI-US+ACIAOw- amzn+AF8-assoc+AF8-title +AD0- +ACI-Search Results from Amazon+ACIAOw- amzn+AF8-assoc+AF8-default+AF8-search+AF8-phrase +AD0- +ACI-money online+ACIAOw- amzn+AF8-assoc+AF8-default+AF8-category +AD0- +ACI-All+ACIAOw- amzn+AF8-assoc+AF8-linkid +AD0- +ACI-8615ab8cb8f811a0ccf094e3388df4ee+ACIAOw- amzn+AF8-assoc+AF8-rows +AD0- +ACI-1+ACIAOw- +ADw-/script+AD4- +ADw-script src+AD0AIg-//z-na.amazon-adsystem.com/widgets/onejs?MarketPlace+AD0-US+ACIAPgA8-/script+AD4- +ADw-hr /+AD4- +ADw-/div+AD4- +ADw-div id+AD0AIg-container+ACIAPg- +ADw-div id+AD0AIg-row+ACI- class+AD0AIg-section group+ACIAPgA8-div id+AD0AIg-left+ACI- class+AD0AIg-col span+AF8-6+AF8-of+AF8-8+ACIAPgA8-div class+AD0AIg-column-in+ACIAPgA8-/br+AD4APA-div+AD4APA-a href+AD0AIgAj-hidecatt+ACI- id+AD0AIg-hidecatt+ACIAPg-Collapse+ADw-/a+AD4- +AHw- +ADw-a href+AD0AIgAj-showcatt+ACI- id+AD0AIg-showcatt+ACIAPg-Expand+ADw-/a+AD4APA-/div+AD4APA-/br+AD4APA-h2+AD4-56 NOT Answered Yet Test Questions:+ADw-/h2+AD4- (hold on, will be updated soon)+ADw-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-1. What effect does the +ACYAIw-39+ADs-Cascade Update Related Fields+ACYAIw-39+ADs- option in the Edit Relationships dialog box have?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Data updated in the main table will automatically be updated in the related table+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Whenever a parent record is deleted, all child records in the linked table are deleted+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Whenever the record is 0 or NULL, it is not allowed to be entered into the table+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Whenever the record is NULL, it is not allowed to be entered into the table+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-2. The students table has two fields, firstname and lastname. Which of the following Select Queries will only return the lastname from the students table?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select firstname and lastname from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select lastname from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select firstname from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from students+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-3. Which items other than column names can you include in the select clause?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Arithmetical expressions+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Column aliases+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Concatenated columns+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-4. Which of the following is not a section of a report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Page header+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Page footer+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Detail+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Summary+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-5. Which of the following is not a data type?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- OLE Object+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Hyperlink+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Yes/No+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Attachment+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-6. Which one of the following correctly selects rows from the table myTable that have null in column1?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from myTable where column1 is null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from myTable where column1 +AD0- null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from myTable where column1 EQUALS null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- None of the above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-7. What is the correct order of the clauses in the select statement? 1.select 2.order by 3.where 4.having 5.group by+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 1,2,3,4,5+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 1,3,5,4,2+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 1,3,5,2,4+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 1,3,2,5,4+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-8. Which Query can you use to delete records from the product table?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Delete from product where productid+AD0-1+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Delete +ACo- from product where productid+AD0-1+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Delete productid+AD0-1 from product+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- None of above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-9. Which event will you use to draw a border around the page in a report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Deactivate+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Page+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- No Data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Activate+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-10. Which of the following statements about the Primary Key are correct?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It cannot be null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It must be unique+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- There can only be one primary key defined per table+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- All of the above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-11. Access 2000 lets you restrict entries to text fields so as to control the formatting of the entered data through input masks. The 0 placeholder for input masks of the Text Field data type allows the data entry of which of the following types of data?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Numbers (0-9) or sign () required+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Numbers (0-9) optional (a space if nothing is entered)+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Numbers (0-9) or space optional (a space if nothing is entered)+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Letter (A-Z) required+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-12. Which of the following clauses is not allowed in a sub-query?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- group by+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- having+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- order by+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- None of the above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-13. What effect does the Strcomp function have on a text field data type?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It compares the length of two strings and returns the value 1 if the difference is even and the value 0 if the difference is odd+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It compares the number of capital letters, small letters and spaces in two strings and returns the result as an integer between 0 and 255+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It compares the number of blank spaces contained in two different strings and returns the difference as an integer+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It compares the two in a way specified by its third argument and returns -1,0 or 1 according to the comparison type+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-14. In the relational model, the columns of a table are also called:+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Attributes+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Rows+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Constraints+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Column+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-15. Which event will you use to cancel the previewing or printing of the report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Deactivate+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Page+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- No Data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Activate+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-16. How can you change the tab order of a Control in a data access page?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- In the Properties of the Control, change the TabIndex property box, type the new tab order number+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the Properties of the Control, change the TabOrder property box, type the new tab order number+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the Properties of the Control, change the TabSetting property box, type the new tab order number+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the Properties of the Control, change the TabRanking property box, type the new tab order number+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-17. A database contains two tables named Credits and Debits. Which of the following types of data integrity will have to be applied to create a relationship between the Credits and the Debits tables?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Primary Key+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Indexes+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Referential+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Entity+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-18. Consider the following tables: Books --------- BookId BookName AuthorId SubjectId PopularityRating (the Popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) What is the query to determine which German books (if any) are more popular than all the French books?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select bookname from books where language +AD0- +ACYAIw-39+ADs-German+ACYAIw-39+ADs- and popularityrating +AD0- (Select popularityrating from books where language+AD0AJgAj-39+ADs-French+ACYAIw-39+ADs-)+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select bookname from books where language +AD0- +ACYAIw-39+ADs-German+ACYAIw-39+ADs- and popularityrating +ACY-gt+ADs- (Select popularityrating from books where language +AD0- +ACYAIw-39+ADs-French+ACYAIw-39+ADs-)+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select bookname from books where language +AD0- +ACYAIw-39+ADs-French+ACYAIw-39+ADs- and popularityrating +ACY-gt+ADs- (Select max(popularityrating) from books where language +AD0- +ACYAIw-39+ADs-German+ACYAIw-39+ADs-)+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select bookname from books where language +AD0- +ACYAIw-39+ADs-German+ACYAIw-39+ADs- and popularityrating +ACY-gt+ADs- (Select max(popularityrating) from books where language +AD0- +ACYAIw-39+ADs-French+ACYAIw-39+ADs-)+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-19. Where does Access 2000 store the default properties for displaying and printing the contents of tables and reports?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- SYSTEM.MBA+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- SYSTEM.MDW+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the Windows registry+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the Office 2000 folder of Windows+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-20. Under the Advanced options for the Access system, there is an option entitled +ACYAIw-39+ADs-Open Databases Using Record Level Locking+ACYAIw-39+ADs-. Which of the following are true when this option is marked?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Access locks the record that is being updated+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Access locks the page that is being updated+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Access locks the table that is being updated+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Access locks the database that is being updated+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-21. The student+AF8-grades table has these columns: student+AF8-id number semester+AF8-end date gpa number Which of the following statements finds the highest Grade Point Average (GPA) per semester?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select max(gpa) from student+AF8-grades where gpa is not null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select (gpa) from student+AF8-grades group by semester+AF8-end where gpa is not null+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select max(gpa) from student+AF8-grades where gpa is not null group by semester+AF8-end+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select max(gpa) group by semester+AF8-end where gpa is not null from student+AF8-grades+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select max(gpa) from student+AF8-grades group by semester+AF8-end where gpa is not null+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-22. Which query will be used to return the current date?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select GetDate()+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Date()+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Date+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select CurrentDate()+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-23. Instr() returns a number specifying the position of the first occurrence of one string within another. What will be the result of the following: InStr(1, +ACY-quot+ADs-Northwind+ACY-quot+ADs-, +ACY-quot+ADs-r+ACY-quot+ADs-)+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 3+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 2+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 1+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 4+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-24. Which property of the group header, group footer, or detail section should you change if you want each group or record in a report to start on a new page:+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- NewRowOrCol property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- ForceNewPage property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- SetNewPage property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- defaultForceNewPage property+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-25. Which of the following aggregate functions can be used in a report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Sum()+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Count()+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Both a and b+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-26. The Nz Data-Type conversion function is new to Access 2000. What function does it perform?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It converts a NULL Value to the user determined value+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It converts only a NULL Value to 0 and a zero length string is left unaffected+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It converts an odd integer to 0+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It converts an even integer to 1+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-27. What is the maximum number of tables that can be joined in a Select query?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 2+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 4+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 10+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Any number of tables can be joined.+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-28. Which of the following statements are correct about the Report Snapshots and the Snapshot Viewer?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Using the Snapshot Viewer, you can electronically distribute Access Reports using either e-mail or a Web browser+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- The Snapshot Viewer consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), and other related files+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- A Report Snapshot is a file with a .snp extension+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-29. What is the maximum number of fields that may be assigned to an index?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 8+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 10+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 5+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 1+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-30. Access 2000 saves new databases in the default database folder. From where can you specify the path of this folder?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Tools+AOIAhgCS- Options+AOIAhgCS- General+AOIAhgCS- Default database folder+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Options+AOIAhgCS- Tools+AOIAhgCS- General-+ACY-gt+ADs- default database folder+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- View+AOIAhgCS- Options+AOIAhgCS- General+AOIAhgCS- Default database folder+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Tools+AOIAhgCS- Startup+AOIAhgCS- Options+AOIAhgCS- Default database folder+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-31. State whether True or False. In Access 2000, one can easily create a backup copy of the current Access database or of the current Access project by choosing the appropriate Access menu command.+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- True+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- False+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-32. Choose the appropriate Query for the Products table where data should be displayed primarily in the ascending order in the ProductGroup column. Secondary sorting should be in the descending order in the CurrentStock column.+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from Products order by CurrentStock,ProductGroup+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from Products order by CurrentStock DESC,ProductGroup+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from Products order by ProductGroup,CurrentStock+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from Products order by ProductGroup,CurrentStock DESC+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- None of the above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-33. What is the maximum number of indexes that you can create in an Access 2000 table?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 8+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 16+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 32+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 64+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-34. Which of the following queries is correct?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from students order by marks where subject +AD0- +ACYAIw-39+ADs-SQL+ACYAIw-39+ADsAPA-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select stname from students order by subject+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from students having subject +AD0AJgAj-39+ADs-SQL+ACYAIw-39+ADsAPA-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select stname from students group by stname+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-35. Which Query will you use to count the number of records in a result set?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select count(+ACo-) as total from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select count(amount) as total from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select total from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select +ACo- from students+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-36. How would you insert the Date and Time into a report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select the Layout view. On the Formatting tab, in the Controls group, click Date and Time.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select the Design view. On the Design tab, in the Controls group, click Date and Time.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Either a or b+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- None of the above+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-37. The +ACYAIw-39+ADs-Required+ACYAIw-39+ADs- and +ACYAIw-39+ADs-AllowZeroLength+ACYAIw-39+ADs- properties control how blank fields are handled. If you want to be able to distinguish between a field that is blank because the information is unknown and a field that is blank because it doesn+ACYAIw-39+ADs-t apply, how will you set the properties?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Set the +ACYAIw-39+ADs-Required+ACYAIw-39+ADs- property to No and the +ACYAIw-39+ADs-AllowZeroLength+ACYAIw-39+ADs- property to Yes+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Set the +ACYAIw-39+ADs-Required+ACYAIw-39+ADs- property to No and the +ACYAIw-39+ADs-AllowZeroLength+ACYAIw-39+ADs- property to No+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Set the +ACYAIw-39+ADs-Required+ACYAIw-39+ADs- property to Yes and the +ACYAIw-39+ADs-AllowZeroLength+ACYAIw-39+ADs- property to Yes+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Set the +ACYAIw-39+ADs-Required+ACYAIw-39+ADs- property to Yes and the +ACYAIw-39+ADs-AllowZeroLength+ACYAIw-39+ADs- property to No+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-38. A Database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a view named View1, which combines the data from both the tables. If the Products table is dropped accidentally, what will happen when the users try to retrieve the data through View1?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Only the data of the Products table will be retrieved.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Only the data of the Orders table will be retrieved.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- An error will be generated.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- The data will be successfully retrieved.+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-39. You can use the RunPermissions property in a multi-user environment with a secure workgroup to override the existing user permissions. What effect does the +ACYAIw-39+ADs-Owners+ACYAIw-39+ADs- setting of the RunPermissions property have?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It allows all users their own permissions to view or run the query+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It allows a user to view, modify and insert but not delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It allows all users the owner+ACYAIw-39+ADs-s permissions to view or run the query+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It allows users to view but not modify data+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-40. Which of the property will you use for printing the section at the top of the next page if it can+ACYAIw-39+ADs-t print the entire section on the current page.?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- GrpKeepTogether Property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- KeepTogether+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- FastLaserPrinting Property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- SinglePagePrint+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-41. While designing a table in Access, an appropriate data type helps in which of the following ways?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It saves space in your database.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It can improve join operations.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It can improve performance of table locks.+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It could lead to fast data retrieval and updates.+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-42. How can you specify whether a user can add or delete data in a form or not?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- In the form+ACYAIw-39+ADs-s property box, set +ACYAIw-39+ADs-Data entry+ACYAIw-39+ADs- to Yes or No+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the form+ACYAIw-39+ADs-s property box, set +ACYAIw-39+ADs-AllowDeletions+ACYAIw-39+ADs- and/or +ACYAIw-39+ADs-AllowAdditions+ACYAIw-39+ADs- to Yes or No+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the form+ACYAIw-39+ADs-s property box, set +ACYAIw-39+ADs-Data entry+ACYAIw-39+ADs- to Yes and +ACYAIw-39+ADs-Recordset Type+ACYAIw-39+ADs- to Dynaset+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In the form+ACYAIw-39+ADs-s property box, set +ACYAIw-39+ADs-Record Locks+ACYAIw-39+ADs- to No Locks or All record+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-43. In what form do file data sources (also called DSN files) store connection information?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- In the Windows Registry+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In a Table located at Windows/System Folder/dsnrecord.mdb+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In a Table located at Windows/Access2000/dsnrecord.mdb+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- In a text file+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-44. In Access 2000, you can control the access that a user has to data through permissions. The +ACYAIw-39+ADs-Insert data+ACYAIw-39+ADs- permission allows a user to:+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- view, modify, insert and delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view, modify, insert but not delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view and insert but not modify or delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view but not modify, insert or delete data+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-45. What is the function of the format painter?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- It copies a table design to the buffer for later use+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It copies a control+ACYAIw-39+ADs-s format to another control+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It helps to format a report so that it looks tidy and presentable+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- It copies a report design to the buffer for later use+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-46. How many twips is 1 inch equal to?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 1440 twips+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 567 twips+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 20 twips+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 100 twips+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-47. Which of the following options most clearly defines the meaning of a bound HTML Control on a data access page?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- A Control that is bound to the HTML code residing online on a Web Server+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- A Control that displays information in the HTML code which is later used for publishing data on the internet+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- A Control that is bound to the HTML code that is stored in a field in a table+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- A Control that computes user defined expressions and stores the result in an table in the form of the HTML code.+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-48. What is the error in the following Query? select name from students where name +AD0- (select name from students order by name)+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- The order by clause in the subquery should be preceded with a group by clause+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- The group by clause should be applied to the outer query+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- An order by clause is not allowed in a subquery+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- There is no error+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-49. In Access 2000, you can control the access that a user has to data through permissions. The +ACYAIw-39+ADs-Update data+ACYAIw-39+ADs- permission allows a user to:+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- view and modify but not insert or delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view, modify, insert and delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view, modify, insert but not delete data+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- view but not modify, insert or delete data+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-50. What will be the result for the following expression: Len(+ACY-quot+ADs-Robert King+ACY-quot+ADs-)+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- 12+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 11+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 10+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- 8+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-51. By adding a background picture to a Report, you can simulate a watermark. You can determine the proportions of the picture by setting the PictureSizeMode property. This property has three settings. What are they?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Stretch+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Color+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Clip+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Zoom+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Width+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-52. You have a table named Students in which there is a column called Studentname for storing the names of the students. What will be the correct Query to display the names of the students in reverse alphabetical order?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- Select Studentname from students reverse+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Studentname from students reverse name+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Studentname from students order by name descending+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Studentname from students order by name reverse+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select Studentname from students order by Studentname desc+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select desc Studentname from students+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Select reverse Studentname from students+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-53. How do you hide duplicate data on a report?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- By Setting the +ACYAIw-39+ADs-HideDuplicates+ACYAIw-39+ADs- property to Yes+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- By Setting the +ACYAIw-39+ADs-DuplicateRecords+ACYAIw-39+ADs- property to No+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- By Setting the +ACYAIw-39+ADs-DuplicateRecords+ACYAIw-39+ADs- property to No and setting the +ACYAIw-39+ADs-GrpKeepTogether+ACYAIw-39+ADs- property to +ACYAIw-39+ADs-Per Page+ACYAIw-39+ADsAPA-/p+AD4APA-p+AD4AJgAj-8226+ADs- Duplicate Data should be handled at the time of data entry and cannot be controlled while reporting+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-54. How many databases can be opened at one time in a single Access 2000 instance?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- One+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Two+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Three+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Ten+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- Fifty+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-55. If you have to store a hyperlink in a field of an Access 2000 table, which data type would be most suitable?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- OLE Object+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- char+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- hyperlink+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- memo+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-pre id+AD0AIg-catpre+ACIAPgA8-span+AD4-56. Which of the following properties will you use for printing a section at the top of the next page if the entire section cannot be printed on the current page?+ADw-/span+AD4APA-/pre+AD4APA-div id+AD0AIg-answers+ACIAPgA8-p+AD4APA-b+AD4-Answers:+ADw-/b+AD4- +ADw-/br+AD4APA-p+AD4AJgAj-8226+ADs- GrpKeepTogether Property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- KeepTogether+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- FastLaserPrinting Property+ADw-/p+AD4APA-p+AD4AJgAj-8226+ADs- SinglePagePrint+ADw-/p+AD4APA-/p+AD4APA-/div+AD4APA-/div+AD4APA-/div+AD4APA-div id+AD0AIg-right+ACI- class+AD0AIg-col span+AF8-2+AF8-of+AF8-8+ACIAPgA8-div class+AD0AIg-column-in+ACIAPg- +ADw-div id+AD0AIg-related+ACIAPgA8-div id+AD0AIg-article+AF8-left+AF8-menu+ACIAPgA8-strong+AD4-Recent:+ADw-/strong+AD4APA-br+AD4- - +ADw-a href+AD0AIg-../../articles/from-lathe-machine-workshop-to-fiverr.html+ACIAPg-How lathe machine worker started on fiverr+ADw-/a+AD4APA-br+AD4- - +ADw-a href+AD0AIg-../../articles/from-making-stipends-on-streets-to-earning-as-freelancer.html+ACIAPg-From making stipends on streets to ...+ADw-/a+AD4APA-br+AD4- - +ADw-a href+AD0AIg-../../articles/benefits-of-working-freelance-for-developer-writer-scientist.html+ACIAPg-Benefits of being freelancer. Short 5 stories+ADw-/a+AD4APA-br+AD4- - +ADw-a href+AD0AIg-../../articles/how-to-get-jobs-in-odesk-upwork-for-ga-specialists.html+ACIAPg-I got first job with experience in Google Reports+ADw-/a+AD4APA-br+AD4APA-p+AD4- +ADw-ins class+AD0AIgAi- style+AD0AIg-display:block+ACI- data-ad-client+AD0AIg-ca-pub-9264047024749722+ACI- data-ad-slot+AD0AIg-7068867097+ACI- data-ad-format+AD0AIg-auto+ACIAPgA8-/ins+AD4- +ADw-/p+AD4- +ADw-strong+AD4-Popular:+ADw-/strong+AD4APA-br+AD4-- +ADw-a href+AD0AIg-../../articles/odesk-how-to-get-the-first-project-task-on-odesk.html+ACIAPg-Getting your first project+ADw-/a+AD4APA-br+AD4-- +ADw-a href+AD0AIg-../../articles/odesk-welcome-newcomers.html+ACIAPg-Upwork(oDesk) For Beginners+ADw-/a+AD4APA-br+AD4-- +ADw-a href+AD0AIg-../../articles/odesk-profile-what-is-important.html+ACIAPg-Tips to complete Upwork(oDesk) profile+ADw-/a+AD4- +ADw-/div+AD4- +ADw-h2+AD4-Related Tests Answers:+ADw-/h2+AD4- +ADw-ul+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-system-analysis-test-answers-2015.html+ACIAPg-System Analysis Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-data-warehousing-test-answers-2015.html+ACIAPg-Data Warehousing Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-sql-test-answers-2015.html+ACIAPg-SQL Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-10g-database-administration-answers-2015.html+ACIAPg-Oracle 10g Database Administration 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-plsql-10g-test-answers-2015.html+ACIAPg-Oracle PL/Sql 10g Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-plsql-9i-test-answers-2015.html+ACIAPg-Oracle PL/SQL 9i Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-10g-test-answers-2015.html+ACIAPg-Oracle 10g Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-mysql-test-answers-2015.html+ACIAPg-MySQL Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-ansi-sql-test-answers-2015.html+ACIAPg-ANSI SQL Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-postgresql-rdbms-test-answers-2015.html+ACIAPg-PostgreSQL RDBMS Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-ms-sql-server-2005-test-answers-2015.html+ACIAPg-MS SQL Server 2005 Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-data-structures-test-answers-2015.html+ACIAPg-Data Structures Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-ms-sql-server-2000-test-answers-2015.html+ACIAPg-MS SQL Server 2000 Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-sql-9i-test-answers-2015.html+ACIAPg-Oracle SQL 9i Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-ms-access-2003-test-answers-2015.html+ACIAPg-MS Access 2003 Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-postgresql-test-answers-2015.html+ACIAPg-PostgreSQL Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-9i-administration-test-answers-2015.html+ACIAPg-Oracle 9i Administration Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-db2-admin-test-answers-2015.html+ACIAPg-DB2 Admin Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-postgresql-8+AF8-1+AF8-3-test-answers-2015.html+ACIAPg-PostgreSql 8.1.3 Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-li+AD4APA-h3+AD4APA-a href+AD0AIg-oracle-forms-9i-test-answers-2015.html+ACIAPg-Oracle Forms 9i Test 2016+ADw-/a+AD4APA-/h3+AD4- +ADw-/li+AD4APA-/ul+AD4APA-/div+AD4APA-/div+AD4APA-/div+AD4APA-/div+AD4APA-/div+AD4- +ADw-script src+AD0AIg-../../../ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js+ACIAPgA8-/script+AD4- +ADw-script async src+AD0AIg-../../js/main.js+ACIAPgA8-/script+AD4- +ADw-script type+AD0AIg-text/javascript+ACIAPg- var infolinks+AF8-pid +AD0- 2840970+ADs- var infolinks+AF8-wsid +AD0- 0+ADs- +ADw-/script+AD4- +ADw-script type+AD0AIg-text/javascript+ACI- src+AD0AIg-//resources.infolinks.com/js/infolinks+AF8-main.js+ACIAPgA8-/script+AD4- +ADw-script+AD4- (function(i,s,o,g,r,a,m)+AHs-i+AFs-'GoogleAnalyticsObject'+AF0APQ-r+ADs-i+AFs-r+AF0APQ-i+AFs-r+AF0AfAB8-function()+AHs- (i+AFs-r+AF0-.q+AD0-i+AFs-r+AF0-.q+AHwAfABbAF0-).push(arguments)+AH0-,i+AFs-r+AF0-.l+AD0-1+ACo-new Date()+ADs-a+AD0-s.createElement(o), m+AD0-s.getElementsByTagName(o)+AFs-0+AF0AOw-a.async+AD0-1+ADs-a.src+AD0-g+ADs-m.parentNode.insertBefore(a,m) +AH0-)(window,document,'script','https://www.google-analytics.com/analytics.js','ga')+ADs- ga('create', 'UA-83277534-1', 'auto')+ADs- ga('send', 'pageview')+ADs- +ADw-/script+AD4- +ADw-/body+AD4- +ADwAIQ--- Mirrored from /odesk-test-answers/databases/ms-access-2000-test-answers-2015.html by HTTrack Website Copier/3.x +AFs-XR+ACY-CO'2007+AF0-, Sat, 26 Mar 2016 18:05:06 GMT --+AD4- +ADw-/html+AD4-