2. Which of the following is the correct syntax for a value list? O'Option 15,"Option 2', 'Option 3 "Option 1";"Option 2":"Option 3" "Option 1":"Option 2":"Option 3" 21 3. To create one-to-many relationships, you do which of the following? Turn off indexing for the primary key field. Use a junction table with at least two foreign key fields. Use the primary key from the table on the "one" side as a foreign key in the table on the many side. 4. To create a one-to-one relationship, you do which of the following? Turn on indexing in the foreign key field, but allow duplicate values. Turn on indexing for the foreign key field without allowing duplicato values. Enable referential integrity. Turn off Indexing for the foreign key field. 5. Referential integrity is useful because it does which of the following? Takes the place of an index. Allows you to orphan" dati safely. Keeps primary and foreign key values in synch 8. To create a many-to-many relationship between Table A and Table B, you do which of the following? Create one-to-one relationships between A, B, and at least two other tables Add the primary keys from A and B to a "link" or "Junction" table. Add as many fields as needed from table A to table B, and vice versa, until ench table contains all the da ta you need to track. 00:49:12 7. A split form offers the best way to: View data from different sources Change the form without altering data in the underlying table. Enter or view individual records and large amounts of data. 8. When you design a form, what's your goal? (Pick one answer.) Make the formaggical and complete, meaning it captures all the data you need Help users understand your data with just a glance. Provide room for graphics, because they make your database seem triendly. 9. You can add controls to a form when working in Layout view. True. False. 00:49:00 "11. There are three tables, Customer, Product, and Purchase. Which of the following statement is true Customer Field Name Data Type CustomerId Short Text First Name Short Text Last Name Short Text Phone Number Short Text Birthdate Date/Time Male/Female Yes/No Product Field Name 1 Product ID Product Name Unit Price Data Type Short Text Short Text Currency Purchase Field Name 4 ID ProductID Data Type AutoNumber Short Text ProductName UnitPrice Short Text Currency 00:48:51 E Purchase Field Name TID ProductID Customer ID Units Data Type AutoNumber Short Text Short Text Number Customerld is the primary key of Customer table. Productld in the primary key of Purchase table, The data type of Birthdate in Customer table is number The data type of Customerld in Customer table is number *12 ha 20 Preda *12 Purchase VID Product Customer 00:48:42 Customer Customer FietName Last Name Phone Number Birthdate Male/Female Product Product Product Name UP The relationship between the Customer and Purchase table is: one to one one to many many to many 13. The relationship between the Product and Customer table is: one to one "13. The relationship between the Product and Customer table is: one to one many to many one to many many to one 00:48:24 The data in the database are as follows: Product ProductID ProductNam. UnitPrice - Chick to Add Computer $899.00 Desk $199.00 Bread $2.39 Paper $1.00 50.00 P3 P4 1 Customer Customerld- First name Emma Jason Elis Last name Smith Cruise Island - Phone Numbe 304-23412345 737-34522345 737-23455600 Birthdate Male/Female 3/20/1986 2/12/1975 2/15/1960 2 Purchase D Product Units Criek to Add - Ortomed CI 2 7 P1 New 14. If the "Phone Number" in the customer table needs to be formatted as 3 digits area code followed by a DIR *14. the "PhoneNumberin the customer table needs to be formatted as 3 digits area codo followed by a and 7 digits phone number, which one is correct for input mask 000-0000000 000-0000000 990-9999999 *000-0000000 00:48:12 *15. If the "Units" in the Purchase table needs to be between 0 and 99, how can we set the validation rule? >=0 And and >> > or -99 To get the query result as follows, please answer question 16-17 First name - Last name - Product Nam Units Smith Computer Ellis Island Computer 2 UnitPrice $899.00 $999.00 Total $899.00 $1,798.00 16. Which tables are necessary for building the query? Customer. Product Customer, Product Purchase Customer, Purchase Purchase, Product ks.wix.top/q/99739032.aspx *17. For calculate the "Total field in the query, which expression for this field is correct: Total: (UnitPrice"(Units Total: UnitPrice"Units [Total UnitPrico)"Units) Total UnitPrice Units DIR 00:47:57 To get the query result as follows, please answer question 18-19. Totalby ProductName Product Nami- Total Computer $2,697.00 *18. Which tables are necessary for building the query? Customer. Purchase Purchase. Product Customer, Product Customer. Purchase, Product 10. Which of the following design is correct for this query? Total: unit(unitprice) Field Product Name Table Product Total drop By Bort 19. Which of the following design is correct for this query? Total: [units]*[unitprice] 7:49 Sum Field: Product Name Table: Product Total: Group By Sort Show Criteria: > or: Query design 1 Exprl: (Total) Sum Field: Product Name Table: Product Total: Group By Sort: Show: Criteria: or: [units]*[unitpricel Query design 2 Query design 2 Exprl: [Total] 00:47:43 Sum Field: Product Name Table: Product Total: Sum Sort: Show: Criteria: or: [units]*[unitprice] Query design 3 Total: [units]*[unitprice] Sum Field: Product Name Table: Product Total: Count Sort: Show: Criteria: or: Query design 4 20. Customer Query design 4 20.3 cm Customer 00:47:36 Custom a Emma La Smith Phallur 964-2341235 3/20/30 Mee/url U - Product SPA Which type of form is it? navigation form subform datasheet form split form 21. Which of the following is not a view for interacting with a form object? Layout view kwx.top/1/90739032.aspx 21. Which of the following is not a view for interacting with a form object? Layout view Design View Form view Datasheet view 00:47:27 22. In computer store database, what's the primary key of the Order Details" table? Order OD Our Orderobe Ceder Details OD educto Products . Pred Unock UnitOrder Order Products Order or Product the composite of Order and Product 30.aspx S 23. When the cascade update related fielde" option is ticked, it meana: Edit Relationships ? X Table/Query: Products Related Table/Query: Order Details OK 00:47:16 Cancel Product ID ProductID Join Type. v Create New.. Enforce Referential Integrity Cascade Update Related Fields Cascade Delete Related Records Relationship Type: One-To-Many When Product in Order Detail table is changed, the ProductiD in Products table will be changed accord ingly When Product in Order Detail table in changed, the Productio in Products table is not allowed to chang od by the system When Product in Products table is changed the Product in Order Detall table is not allowed to chang o by the system When Production Products table is changed, the ProductiD in Order Detail table will be changed accord CI DI 51 th @ : w GS1 Ed PI GD ks.wix.top/jq/99739032.aspx . D This is a "Student-Course" database. Please answer question 23-25. StudentCourse Course Coursel Course name CD 00:47:10 Coursel Studenti Grade Student Studenti First name Last name Phone number Notes 38 Course CourseID Course name English Math Course Description english literature math problems C2 Student Studentid Last name Phne number First name 51 BE PE les.wix.top/1/99739032.aspx Student Studentld First name Emma Last name Smith - Phne number 123-234 234-345 234-234 Jason Ellis Cruise Island 00:47:04 3 - Grade Student Course ID Courseld 1c1 2 c1 3C2 4 C2 (New) Student ID 1 2 1 3 . Click to Add 78 89 60 45 -24, is this a crosstab query? Studenti C1 C2 Average of Grade 78 60 69 89 45 89 2 3 45 True Fais 25. Which of the following is true about crosstab query: (pick multiple answer QUICO WI GM PE ks.wix.top/ig/99739032.aspx Faise 00:46:58 *25. Which of the following is true about crosstab query (pick multiple answers) Am Crosstab query can only have one table/query as a resource. Crosstab query can have more than one table/query as a resource. We can use query design or query wizard to create a crosstab query 28. We want to know each student' average score. In the query correct or not? Student Course Student TD Coursel Studenti Grade 1 Studentld First name Last name Phone number Notes Field Student Tele Stridestore Prote Srodot at Student Cade rent count A SORT Crosstab query can only have one table/query as a resource. Crosstab query can have more than one table/query as a resource. We can use query design or query wizard to create a crosstab query 26. Wo want to know each student' average score. la the query correct or not? 00:48:47 Student Course Student ID Course Studenti Grade Studentid First name Last name Phone number Notes Fit Student Group Last Student Pred: Student Table Student Course Total Group Sort Show Criteria Grade Studentore AYE Correct Wrong
