Answer Posted / sweety

SQL is a server based database whereas MS Access is a local
database.
SQL can be used when the number of users is high. For
example, considering MS Access, only 5 users can make use
of the access database at the same time. But incase of SQL,
many users can access the database at the same time.

What are the basic features of ms access?

1075

---

How ms access is better than ms sql server?

894

---

How can you maintain a relationship between different databases in access?

979

---

What do you mean by erd and its main elements?

821

---

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

874

---

What are queries in ms access?

949

---

What is a database in microsoft access?

907

---

What are the protection features in ms access?

939

---

Would you like to easily automate your MS Access database through menu driven selections?

883

---

How would you import a sharepoint list?

837

---

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

2378

---

Explain how you can import data from other sources into access database?

894

---

Tell some of the most important uses of ms access?

876

---

What joins are and how you can open the database in access?

906

---

What are the main differences between the two?

934

---