Question
Create a database containing information about a topic or subject of your choice. Some suggestions include: Something you own or collect, such as music (CDs/albums/song
Create a database containing information about a topic or subject of your choice. Some suggestions include:
Something you own or collect, such as music (CDs/albums/song files), movies (DVDs/Blu-rays/video files)
2. The database must have at least three tables, and the table containing the main subject/theme item must have at least 15 rows. The others can have fewer rows. Each table should be related to one or more of the other tables.
There must be a way to connect or link the tables, although each table does not have to link directly to all the other tables. Each table should have its own unique/primary id.
3. Create at least four queries that answer questions about items in your database. At least two must join two or more tables . Use of the following concepts is required :
criteria
AND/OR logic
comparison (such as >, <, >=, <=)
a calculated or aggregated field
4. Create one form of your choosing .
5. Create one report of your choosing.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started