Answer / Ganesh Prasad

Microsoft Access can be used in conjunction with Excel by linking an Access table to an Excel worksheet or creating a query that retrieves data from an Excel file. To link a table, open the Access database, and then click 'External Data' followed by 'Link Tables'. Navigate to your Excel file and select the range of cells you want to link. Click 'OK' to create the linked table.

What are the main features of ms access?

1 Answers  

---

What are the data types in ms access?

1 Answers  

---

How do I install a microsoft access driver?

1 Answers  

---

Is it possible to retrieve all tables along with all the data?how?

1 Answers  

---

How do you start ms access?

1 Answers  

---

Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?

1 Answers  

---

What is microsoft access database?

1 Answers  

---

Can I download microsoft access for free?

1 Answers  

---

Explain the index key?

1 Answers  

---

Is microsoft access going away?

1 Answers  

---

How to add microsoft access to office 2016?

1 Answers  

---

Who uses access database?

1 Answers  

---