سلام عليكم
جاي استاذ سؤال صعب لاافهم حله حليته لكن غير تاكدة حله اليا ارجوكم سارسله لكم هو بلغة ئنكليزي حله ارجوكم عندي امتحان قريب جدا
Q3?
Ouestion Acsess
Open Microsoft Access
Create a blank Access database in thepractice Access files folder called Music Library
Create new table with thesefields
CD Title
Artist
Genre
Date purchased
Number of Songs
Tip :Do this in Design View
Save the tableas CDs.
Rename the IDfield totable to create the first record:
CD Title:pearls on a String
Artist:Dusty Trails
Genre:Folk
Date purchased:05/10/2001
Number of Songs:14
Tip:Do thisin Datasheet View.
It should look like this:
Close the CDs table.
Create from for inputting date input.
It should lok like this:
Use the form to enter information for four more(CDs.
Createa query that pulls out this information:
CD Title
Genre :FolK
Save the query as Quick CD Notes
Run the query
It should look like this:
Create a report based on the CDs table
Include all the field of the CDs table in the report and sort the records based on Genre.
TIP:Format the report using theFlow style.
Name the report CD inventory
It should look like this:
Insert picture onthereport
Close the report.
Exit MicrosoftAccess>