Tables to Handle Data Access Assignment
Think of a small organization that is building a small database to manage part of its business.
• build two or more related Tables to handle the data o consider what common field (key) will connect the tables o create a relationship to join the tables together • create at least five Queries to combine information from two (or more) tables o one Query should include a mathematical function using the Expression Builder o one Query should include statistics (e.g., sum, average, etc.) • create a Form with Sub-Form that displays data from both tables • create a Report with an image and some formatting that displays information from both Tables