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 6164

What is Tab Query Whats its advantage over Sql-Query

TELUS, Unisys,

3206

how to u retrieve all tables along with all the data

Satyam,

1 4014




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

4 6463

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

3 9760

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 2554

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

1 2465

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

1741




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

1198

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 1968

can we create relastionship bet 2 tables in ms-access

2 3417

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

3 5467

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

1264

what is the 4 types of validation

2 4549

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 2532


Post New MS Access Questions






Un-Answered Questions { MS Access }

How we can apply bit m a podded index in ms access

960


how to toggle ms word to ms excel or ms excel to ms word

1072


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

1198


can we call primary key a 'address'????

1290


Define Primary key, Foreign key, Weak key in your own words.

2036






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

1264


How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.

1299


What is Tab Query Whats its advantage over Sql-Query

3206


I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

906


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

1741