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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!