Tables Creation

Question 1

Term Project: Getting Started with Microsoft Access 2013

•To be able to create databases in Access 2013

•To be able to create tables in Access 2013

•To understand Access 2013 data types

•To be able to insert data into tables in Access 2013

•To be able to create relationships between tables in Access 2013

•To be able to create Query-by-Example (QBE) queries in Access 2013

Project Report by Individual, APA Format, Minimum 5 Pages, Double Spacing:

• Introduction
• Create database
• Create tables
• Using Access 2013 data types
• Insert data into the tables
• Create relationships between tables
• Create query
• Conclusions

Question 2

Prompt II: Technical Proposal

Having successfully explained the value of designing a warehouse to facilitate the merger between Virtual World Insurance Company and Maxon Insurance, you are now responsible for creating the full-fledged proposal. Your proposal must include your architecture and a technical plan for implementation that highlights potential difficulties. It is important that you communicate in a manner that can be understood by executives, but can also be understood by members of your IT group to plan for future implementation. The challenge will be balancing audience-appropriate communication with adhering to the technical nature of your task. Remember to include all of the necessary aspects of a data warehouse and to attend to potential issues, both common aspects and those unique to your organization.