Question: TO MYNAIT - Question 8 Time left 1 1 9 : 2 8 : 0 4 For this question, you need to download this database

TO MYNAIT -Question 8Time left 119:28:04For this question, you need to download this database fileon to your DesktopDesktop hsNot yet answeredUse the Save As... button Save asWhen prompted.Marked out of 1.00F FlagquestionOpen the database, and make a copy of the Staff query. Rename it Old Staff Last Name starts with N. Modify the query so that when executed it displays only names of employees whose name begins with the letter N and whose age is 65 or older.Hint: Use appropriate wildcards and comparison operators.Which of the following is the correct design that will get the expected results?Select one:Field: First NameLast NameIncome / Yr State of Residence PostAge: DateDiff("",[Birthdate],Now())Table: CompanyCompany 1 Company 1Company 1Company 1Sort:Show:Criteria:N>65.Field:First NameLast Name Income / Yr State of ResidencePostAge: DateDiff("yy".[Birthdate], Now()Table:Company 1Company 1 Company 1 Company 1Company 1Sort:Show:Criteria:>=65.Field:First NameLast Name Income / Yr State of Residence Post Age: DateDiff("yyyy",[Birthday]. Now))Table:Company 1Sort:Show:MCriteria:Like "N**>=65.Field:First NameLast NameIncome / YrState of ResidencePostAge: DateDiff("".[Birthdate], Now)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!