Database: Design, Create, Populate, and Test

To procure the criteria the evidence must show that the learner is able to Task no(prenominal) Evidence Create and populate a selective in imprintationbase SMS 3 Import information from an external source Create features in data entry forms to check over validity and integrity of data Perform queries using twofold tables and multiple criteria VI Export data to an external source Include an go feature in a database mark Implement an automated flow Test a relative database SMS, RL Discuss how potential errors in the design and construction of a database can be avoided III 4 Evaluate a database against the specified user needLearner Declaration certify that the work submitted for this assignment is my own. I have clearly referenced any sources used in the work. I understand that false declaration is a form of malpractice. Learner hint Title Date Assignment Design, build, populate and describe the features of a relative database. Purpose of this assignment The aim of this uni t is to enable students to understand the features of relational databases and develop the necessary skills to design, create, populate and test a relational database incorporating mature features. Task 3 ScenarioImplement the database design from project 2 in Microsoft ability Access Task 3 3. 1 Implement the database design from tax 2 in Microsoft Office Access by creating at least(prenominal) five tables. Create both the tables as identified in your data model Set up relationships and enforce referential integrity to renounce cascade updating and deletion of linked records Populate tables with valid and just test data Export all table definitions to a invent document This Provides evidence for CPA 3. 2 Create test data in a spreadsheet and import into the relevant tables. You exit need to document for each one step of this processThis Provides evidence for MM 3. 3 Design and implement all the forms (including at least one sub-form) that have been outlined in the Requ irements Specification (see task 2 in the Systems outline and Design assignment). A consistent of room must be used in order to create a professional mage to allow users to interact with the system. Your implementation must include at least ternion features for ensuring data validity. Demonstrate and explain your forms to your private instructor who allow provide a witness statement confirming your success. This Provides evidence for CPA 3. 4Perform three different types of queries using multiple tables and multiple criteria to search and sort data that are required from the output requirements (see task 2 in the Systems Analysis and Design assignment). Demonstrate and explain your queries to your tutor who will provide a witness statement confirming your success. This Provides evidence for UP 3. 5 Export the results of a query to another application. This Provides evidence for MM 3. 6 Design and implement all the reports that have been outlined in the requirements taking care to ensure trunk in line with your form designs.Create a Main Menu form as detailed in the requirements and implement at least one advanced feature. This Provides evidence for MM 3. 7 Demonstrate and explain the process to your tutor who will provide a witness Implement at least one automated feature from the list below Macro Scripts political platform code This Provides evidence for AS 3. 8 Once you have completed the database, you will need to make sure that the database is working correctly. You are required to create a test plan that tests the main database functionality. Any test failures should be corrected and annotated using screen shots in a est. log.