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), books, figurines, etc.

An inventory of a home, apartment, dorm room, etc.

A business, service project, marketing program, etc.

An activity, sport, or organization you participate in, belong to, or follow

Any of these can be real or made up, and can contain actual data and/or some you make up.

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.