| Back to Questions Page |
| |
| Question |
can ms access be used in a website instead of sql server? |
Rank |
Answer Posted By |
|
Question Submitted By :: Abc |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | We cannot use MS Access in a WebSite instead of SQL Serve.
Becouse MS Access can be used for Local service. But in the
Website we need to be Server.  |
| Ram Birendra Jha |
| |
| |
| Answer | MS Access can be used on a website. Although Access has its limitations. The last time I checked Access is only able to handle up to 255 consecutive users. On low traffic MS Access is often the best approach.  |
| Jeff Frye |
| |
| |
| Question |
can we create relastionship bet 2 tables in ms-access |
Rank |
Answer Posted By |
|
Question Submitted By :: Panks |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | yes.
1.go "tools"
2. select "relationship"
and add table n which u want to make relationship.
now drag.  |
| Prem |
| |
| |
|
|
| |
| Answer | yes we can create relationship easily  |
| Rrrr |
| |
| |
| Question |
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 |
Rank |
Answer Posted By |
|
Question Submitted By :: Sheikh_imtiyaz |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Hi Imtiyaz,
use divison to devide the number by 10,100 the quotent will
give you the number for the box so for 20536 divide by
10000 you get 2 for 10000 , then when divide 0536 by 1000
will give 0 for 1000, 536 by 100 will give 5 for 100 and so
on..
you need to use the length to deside where to start
deviding otherwise 0 in the bozes of lacks and crosre even
if the number is in thousands.
Hope this helps.
Enjoy
DG  |
| Darsh |
| |
| |
| Question |
What’re ERD and the main elements of an ERD? Please explain
using an ERD example. |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | ERD is Entiry Relationship diagram..
the main components are Entities, and their atributes with
relations.  |
| Rajput |
| |
| |
| Answer | the main components are Entities, and their atributes with
relations.  |
| Philip |
| |
| |
| Question |
can primary key of one table be a primary key in many other
tables |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | no we can 't do like that , the primary will be the foreign
key for the another table!!  |
| Jayanth |
| |
| |
| Answer | The Primary Key of one table is foreign key for other
table. The primary key of one table can be primary key of
other tables, but there will be no use of that, it will
break the RDBMS Rule and make the RDBMS slow.  |
| Pramod |
| |
| |
| Answer | No..We can't create the primary key of one table be a
primary key in many other tables..
Primary Key will be the foreign key of another table..
only one primary key is possible 2 table.  |
| Chaitali |
| |
| |
| Question |
how to u retrieve all tables along with all the data |
Rank |
Answer Posted By |
|
Question Submitted By :: Tara Krishna Suggula |
| This Interview Question Asked @ Satyam |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | create one blank database
then go to file there u will the option external date there
select import option then select from which data base u want
to retrieve all tables , if u select the tables the data
also comes along with that  |
| Jayanth |
| |
| |
| Question |
Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example? |
Rank |
Answer Posted By |
|
Question Submitted By :: Panigrahi_saroj30 |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Yes. You CAN. you need to set the referential integrity in
Relations window in MS Access. When you add a relation to a
table, you will be prompted through Edit relations window
where you can set the cascade updates and cascade deletions.  |
| Upendra Agnihotram |
| |
| |
| Answer | After make ensure of having unique index for setting up
the "Enforce referential integrity" at relationships in MS
access we Can create a updatecascade, Deletecascade
relation in Ms-Access.
Try and let to share.
Note:- Good Upendra.A  |
| Susi Kumar.p |
| |
| |
|
| |
|
Back to Questions Page |