Remaining Time: 38 minutes, 23 seconds. Question Completion Status QUESTION2 i t
ID: 3745873 • Letter: R
Question
Remaining Time: 38 minutes, 23 seconds. Question Completion Status QUESTION2 i tables and when you nun the form you get the foliowing emor "Type Mis Match in Expression What O Data Filed Lengths are not consistent across tables Data Filed Types are not consistent across taibles O Primary Key Field missing O Foreign Kay Filed missing is this telling you about your QUESTION 3 Access) Ben is working in a database that stores sthuadent information. He wants to determine each student's age based on the shudent's birthday Whikh of the to determire each students designed? elowing satements accurabely describe how the ieldhs should be The birthday should be a calculated feld and the age should be a stored feld O Both the birthday and age fields should be stored fields O The birthday should be a stored feld and the age should be a calculated feld O Both the birthday and nge fields shouid be calelated felds QUESTION 4 Access) A form can be used to: O sort data in ascending or descending order O automate the retrieval and update process select records that meet speofic teria. O enter, view records in a daialbase QUESTIONS Access) A s a question you ask about data stored in a databaneExplanation / Answer
Answer 3:-
correct option is C:-The Birthday should be a stored field and the age should be calculated field.
Explaination :- if you know the birth date then you can easily calculate the age of the person, for example if date of birth is 14th sept 1994, and if todays date is 14th sept 2018 then you can calculate age i.e 24 Years so option C is correct.
Answer 4:-
correct option is D is correct
Because we use form to enter,edit and view records in database.
Rest all the options are incorrect, because to sort data in ascending or descending order we select the field we want to sort and click and then
and to automate the process
Every Access developer knows you can create an autommation proces by naming your macro “autoexec”. so we use macro for automation.
and to select records that meet specific criteria we do following steps:-
Open your query in Design view.
In the query design grid, click the Criteria row of the field where you want to add the criterion.
Add the criteria and press ENTER.
You can use several types of criteria like text, dates (read about applying criteria to text and using datesas criteria) and functions.
Click Run to see the results in Datasheet view.