MS Access Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MS Access Interview Questions

Questions Answers Views Company eMail

Can you create a updatecascade, Deletecascade relation in Ms-Access? If yes, give an example?

2 9180

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

4578

how to u retrieve all tables along with all the data

Satyam,

1 6385

can primary key of one table be a primary key in many other tables

4 10344

What’re ERD and the main elements of an ERD? Please explain using an ERD example.

3 14335

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 5358

How can I give discount condition in a sales table in MS Access?

1 4722

How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?

2786

By using Macromedia Director How to fetch the data from Microsoft Excel?

2228

I am using ms access and am stumped trying to determine the last three entries ( by date ) for each name in the database. Any help would be appreciated.

1 4282

can we create relastionship bet 2 tables in ms-access

2 6138

can ms access be used in a website instead of sql server?

3 9229

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

2316

what is the 4 types of validation

2 7407

Which of the following is used to enter or display data via Internet? Data in it is stored as HTML files, with data read from and written to the database. Macros Queries Forms Pages

Wipro,

1 5028

Post New MS Access Questions

Un-Answered Questions { MS Access }

Can you put an access database on sharepoint?

810

How do I install microsoft access 2013?

804

Where is microsoft access located?

819

What is the difference between microsoft access and excel?

886

What is microsoft access 2013 runtime?

820

What can you do with access 2010 data?

848

Does microsoft 365 come with access?

777

Explain superior keys and candidate keys. How are they different?

837

Would you easily automate your ms access database through menu driven selections?

820

How do I install a microsoft access driver?

860

I am using the switchboard manager in ms access. I am getting an error message "there was an error executing this command." What could be wrong?

904

What is microsoft access database engine 2010?

915

In ms access 2013 what are the different ways you can enter data?

1010

What are the advantages of access over excel?

886

Explain superior keys and candidate keys.

825

For More Un-Answered { MS Access } Questions Click Here