How can you maintain a relationship between different databases in access?
Answer / Tanya Gautam
To maintain relationships between different tables in an Access database, you can use the 'Relationships' tool. Here are the steps:
1. Open the 'Relationships' window by clicking on 'Database Tools' -> 'Relationships'.
2. Drag and drop the fields from one table to another that have a relationship.
3. Set the relationship type (One-to-Many, One-to-One, etc.) and click 'Create'n
| Is This Answer Correct ? | 0 Yes | 0 No |
Can I download microsoft access for free?
can ms access be used in a website instead of sql server?
Can you download access on mac?
How do I update access 2013?
Is microsoft access important?
What is meant by database in access 2010?
Explain how we can do multi-join query in ms access?
What is field size access?
Is access better than excel?
Explain about relationships and look up fields?
How do I start microsoft access?
Does office 2019 include microsoft access?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)