Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MS OFFICE 365/ACCESS 2019 COMPREHENSIVE - Show how to create this step by step in Microsoft Office 365 Create a database containing information about a

MS OFFICE 365/ACCESS 2019 COMPREHENSIVE - Show how to create this step by step in Microsoft Office 365

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

blur-text-image

Get Instant Access with AI-Powered 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

Consider the following code in C

Answered: 1 week ago