Computer Operator Practical Question Ms Access; How to calculate the current age of candidate?

Dear friends, here I present the collection of computer practical questions that are asked previously in the computer practical exam of the Public Service Commission (Lok Sewa Aayog).

These questions are collects from the students that are included in the final exam, from the internet, from Facebook, from friends.

If you need Practical Questions on Ms-Word, Ms-Excel, Ms-Powerpoint, HTML & Interview, Please Go through the following link.

CLICK BELOW LINK:-

Ms-Word Practical Questions:

Ms-Excel Practical Questions:

Ms-Powerpoint Practical Questions:

Ms-Access (Database) Practical Questions:

HTML Practical Questions:

If you want also mcq questions on following topic, click the link

Computer Fundamental MCQ Questions Collection:-

Ms-Word (Word Processing) MCQ Questions Collection:-

Ms-Excel (Excel Spreadsheet) MCQ Questions Collection:-

Ms-Powerpoint (Presentation) MCQ Questions Collection:-

Ms-Access (Database Management System) MCQ Questions Collection:-

HTML (Web Page Designing) MCQ Questions Collection:-

Interview Questions Collection:-

And further if you need the preparation and practical guide for the final exam. 

The post or article Practical Exam Guide for Computer Operator Exam of PSC. 

The another articles about Sample Job Interview Questions really helps you.

I have collected questions for Ms-Access (Database Management System) Practice. Practice well and try to solve those questions in time.

If you need other similar questions, please write in the comment box below. I will upload it on the website for your preparation. If there is any problem in solving it, please write in the Comment Box. 

Join My Social Profile for more updates:

Telegram Group:-  Mohan Bhatt

(Where upload learning materials more about Computer Practical and upload pdf file related with)

Facebook Page:- Mohan Bhatt Facebook Page

Youtube Channel:- Computer Operator & Blogging 

Now I will put a Practical Question for Ms-Access here and also present a way to solve it. Follow the steps below.

Ms-Access Practical Question:- Create the following table, insert 4 records and calculate the current age of candidate in Ms Access.

CN (Citizenship Number)

Name

Gender

DOB

Address

Solution:

a) To create a database and make a table.

Step 1:- Start Ms Access app. 

Step 2:- Rename the database as 'AgeDBMS'. 

Step 3:- Click Create.

Step 4:- Edit the ID field name to CN.

Step 5:- To add more fields to a table in Datasheet view, double-click the Add New Field header.

Step 6:- Next, we've added the fields Name, Gender, DOB and Address to the salary table.

Step 7:- Press Ctrl + s to save the table name as 'Candidate_INFO'.

Step 8:- Insert suitable 4 records in table and again save the record of table.

b) To create a required queryfor the calculation of Age of Candidate.

Step 1:- Select the Create tab. Then click on the Query Design button under the Other group.

Step 2:- Next, highlight the Candidate_INFO table and clicked on the Add button. When you are done selecting the tables, click on the Close button.

Step 3:- In the first field, 

type Age: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) 

Step 4:- Add the other fields to the query. You can do this by double-clicking on the field name of the table. In this example, we've added the Name and Address. 

Step 5:- Then click on the Save button at the top left of the window.

Step 6:- The Save As window should appear. Enter the name 'Query1' and click on the OK button. 

Step 7:- Run Query to view Result. 

-That's all the steps.