 An Access database is a collection of various objects which include tables and queries. It’s important to know the distinction between MS Access queries and their close cousin; the table and below I’m going to give you a summary to get you started. To hold and archive real data (or physical data) you use a table in your Access database. You can of course have more than one table which can be joined in a relationship to make you Access database a relational database(RDBMS). I’m often asked about the Access foreign key and why we should use it in the first place. Well, to start with, take a look at this quick one and half minute video tutorial below to cover one use for it which briefly also explains one reason… | 
