
4) Explain how you can build a relationship between the different databases in Access?. 3) Between different data’s what are the types of relationship can be formed?. 2) Explain what is the size limitation for an Access database?. 1) Explain how you can import data from other sources into Access database?. In this Ms Access Database Interview Questions tutorial, you will learn: Many-to-many relationship: Where several data’s in one table is related to several other data’s in another table. One-to-many relationship: A single data in a table is linked to several data’s in another table. One-to-one relationships: A single data in one table is linked with a single data in another table. The table contains your data can build three types of relationship
👉 Free PDF Download: Microsoft Access Database Interview Questions & Answersģ) Between different data’s what are the types of relationship can be formed? The Access 2.0 database has the size limitation of 1 gigabyte.
To know which type of file can be import or link Access database, follow the instruction in the Get External Data wizardĢ) Explain what is the size limitation for an Access database?. Choose the type of the file you want to import.
In the main menu, click on EXTERNAL DATA, in the Import and Link group. 1) Explain how you can import data from other sources into Access database?