Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain using short descriptions Create a single accdb file.Create an MS Access database with content of your choice. Your database must meet the following

Please explain using short descriptions image text in transcribed
Create a single accdb file.Create an MS Access database with content of your choice. Your database must meet the following qualitative and quantitative criteria: 1. The DB must contain at least 4 tables. 2. The tables must be populated with sufficient relevant data to allow meaningful subsets of data for requirements #9 and #10 below. 3. The tables must be consistent (i.e., it must represent a single entity, and all columns must be logically attributes of that entity). 4. The DB must have at least two relationships between the tables. 5. The following field properties must be reasonably set within the logical context of your data for all fields: Field Size, Caption, Default Value, Required. 6. You must have at least one example of Input Mask and Validation Rule 7. At least on lookup must be used with reference to another table. 8. At least one form must be created involving fields from at least two tables. 9. At least one report must be created involving fields from at least two tables. The report must present a subset of data answering a specific question regarding the data. 10. At least one parametrized query must be created involving fields from at least two tables; the query must present a subset of data answering a specific question regarding the data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

C) and for AF? Pg45

Answered: 1 week ago