Microsoft Access
Interview Questions
You'll Most Likely Be Asked
Job Interview Questions Series
*****
Microsoft Access Interview Questions You'll Most Likely Be Asked
Published by Vibrant Publishers at Smashwords
Copyright 2012 Vibrant Publishers, USA.
Smashwords Edition, License Notes
This ebook is licensed for your personal use only. This ebook may not be re-sold or given away to other people. If you would like to share this book with another person, please purchase an additional copy for each recipient. If you’re reading this book and did not purchase it, or it was not purchased for your use only, then please return to Smashwords.com and purchase your own copy. Thank you for respecting the hard work of this author.
This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. The author has made every effort in the preparation of this book to ensure the accuracy of the information. However, information in this book is sold without warranty either expressed or implied. The Author or the Publisher will not be liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Vibrant Publishers books are available at special quantity discount for sales promotions, or for use in corporate training programs. For more information please write to bulkorders@vibrantpublishers.com
Please email feedback / corrections (technical, grammatical or spelling) to spellerrors@vibrantpublishers.com
To access the complete catalogue of Vibrant Publishers, visit www.vibrantpublishers.com
*****
5. Unmatched And Duplicate Queries
10. Manipulating Data In Records
16. Advanced Data Management - Lookup Fields
17. Advanced Data Management - Subdatasheets And Attachments
18. Importing And Exporting Data
19. Pivot Tables And Pivot Charts
*****
Microsoft Access Interview Questions
Review these typical interview questions and think about how you would answer them. Read the answers listed; you will find best possible answers along with strategies and suggestions.
*****
1: What are joins?
Answer:
Joins extend and describe relationships in Access by specifying the details of the relationship between two tables. A relationship is usually a link between two common fields in the tables. In one of the tables, the field is known as the primary key and in the other table, it is known as the foreign key.
2: In one-to-many relationships, how do you choose the primary and the foreign key?
Answer:
The primary key is in the “one” table and the foreign key is in the “many” table.
3: When does Access automatically define joins for tables?
Answer:
It automatically defines joins when the relationship between the tables is already defined.
4: What are the four main types of joins?
Answer:
Inner join, outer join, cross join and unequal join
5: What is the difference between an inner join and an outer join?
Answer:
An inner join returns matching values from both tables, whereas outer join requires only one or neither of the tables to have matching values.
6: What are the types of outer join?
Answer:
Full outer join, left outer join and right outer join
7: If you drag a field from table A to a field from table B when describing a relationship in design view, which table will be considered the “left” field?
Answer:
Table A
8: What does a right outer join do?
Answer:
It retrieves matching records from the “left” table and all records from the “right” table.
9: What does a left outer join do?
Answer:
It includes matching records from the “right” table and all records from the “left” table and then returns that resultset.
10: What does a full outer join do?
Answer:
It includes all the records from both the left and the right tables and then returns that resultset.
11: What does an inner join do?
Answer:
It retrieves all the records that match from both the left and the right tables.