Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions