Question

Microsoft Access

0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces and change the caption to be with spaces in the word: for example FirstName would be field name and First Name would be caption. All field sizes should be changed. Change format if necessary d. A primary key Field other than Field Name ID with an AutoNumber Data Type e. One field should have a drop-down box (Lookup Wizard) B. Populate the table with at least 15 records. Make sure all the data shows-adjust columns C. Create a form using a wizard for your database using any format of your choice. Use all D. Query the table, have at least one criteria, and name the query based on what's in it. You E. Create a report, using a wizard, based on all fields in the Query, using any suitable format. f. Name the table appropriately, there should be no tables named Table1 as needed. (No more than 25 records) fields in the Form. Name the form with the same name as your table. can have as many of the fields showing as necessary to show what you're trying to accomplish, but do not have all the fields in the query or showing. Save the report giving it an appropriate name, Submit your completed database file in the Assignment Link before its Due date (or extended

Answer 1

A.

Table Tools SteelCompany: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools Design Insert Rows 訒 Delete Row View Primary Builder Test Validation Property Indexes Rules Lookup Column Sheet iews Tools Show/Hide All Tables SteelCompanySteelCompanyQueryl Data Type Description AutoNumber Text Text Text Text Currency steelCompany : Table First Name Last Name Gender Phone salary SteelCompany Query Field Properties Field Sizée New Values Format Caption indexed Smart Tags Text Align Long Integer No A field name can be up to 64 characters long, including spaces. Press Fl for heip on tield Design view, F6-Switch panes. Fl1 Help. Num Lock | 卤匹4

B.

Table Tools SteelCompany: Database (Access 2007) - Microsoft Access Home Create External Data Database ToolsDatasheet ぬcut i Selection Copy PastejFormat Painter Replace Go To- Select- View |Blua-a- 1E 의 품티|ッ1 Refresh Ella -| >< Delete ▼-More" Togole Filter Find Clipboard Sort & Filter Find All Tables First Name ▼ Last Name | Gender Phone Salary Add New Field steelCompany : Table 13 Vishwanand Anand (New) Record: 14 l of 15 써 禾No Fiter | Search Datasheet View 25 10 40 60 45 le

C. form

SteelCompany: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools 斟 SNew Totals 7er selection nee Replace Sav Spelling Cut Copy .-, Format Painter [Biula-anlegg ViewPaste |ag).| Refresh Filter AllX Togole Filter Find DeleteMore Select Find iews Clipboard Font Rich Text Records Sort & Filter All Tables SteelCompanySteelCompany SteelCompany SteelCompany : Table ID First Name Last Name Salary ohnn Kennedy Male 9632587410 25,000.00 2 Sophia Margarette Female 9874563210 15,250.00 3 Pricilla Mary Female 8523697410 10,000.00 4 Antony Male 7412589630 40,000.00 5 Vijay Anotony Male 8547963210 60,000.00 6 Selvi Swetha Female 8794563210 45,000.00 7 Captain America Male 8023147596 70,000.00 8 Queen Elizabeth Female 9658741023 80,000.00 9 Snitha Kumaran Female 9785463210 25,000.00 Record: 14 l of 15 トト! ˋ承No Filter | Search Form View Num LockE

D. Query

SELECT SteelCompany.ID, SteelCompany.[First Name], SteelCompany.Gender, SteelCompany.Salary
FROM SteelCompany
WHERE (((SteelCompany.Gender.Value)="female"));

E.Report

SteelCompany: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools ぬcut i Selection New ΣTotals 21 Save Spelling Replace View Paste /Format Painter |Blua-a- 1E 의 품티|ッ1 Refresh >< Delete EMor Ella -| Togole Filter Find Select- Clipboard Rich Text Records Sort & Filter Find All Tables SteelCompany SteelCompany Display with Gender First Name GenderSalary 뼈 steelCompany : Table Display with Gender Stee|Company Query Sophia 3 Pricilla 6 Selvi 8 Queen 9 Snitha 10 Ramya 12 Parimala 13 Vishwanand $15,250.00 $10,000.00 $45,000.00 $80,000.00 $25,000.00 $15,000.00 $12,000.00 $17,000.00 $20,000.00 Female Female Female Female Female Female Female Female New Record: 1 of 9 INo Filter Search Ready Num Lock 司通也SQL SK

SteelCompany: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools 国门 ぬcut a Replace of Save 咢Spelling ViewPaste Ellaツー| Refresh Find Y Toggle Filter tSelect Find iews Rich Text Records Sort & Filter All Tables Display with Gender Final Report For SteelCompany steelCompany : Table Display with Gender SteelCompany Query Final Report For SteelCompany ID Gender 4 Male 7 Male 4 Male u Male a Male 12 Female 3 Female 8 Female o Female 5 Female 6 Female 9 Female 2 Female 5 Male i3 Femal<e Phone Salary $40,000.00 5 70,000.oo s8,ooo.oo First Name Last Name Antony Joseph Captain America James Vasanth Jeeva Vasanth Johnn Kennedy Parimala Thirumoorthy Pricilla Mary Queen Elizabeth Ramya Raj SaniyaMirsa Selvi Snitha Sophia Margarette VijayAnotony Vishwanan Anand Final Report For SteelCompany 9856471zo1 9410235693 963258741o 9741203896 $ 35,000.0o 5 12,ooo o0 S 10,0oo.00 9654781203 $5,000.0o S zo,0oo.oo S45.000.00 s 25.00.00 $5250.0o s 60,000.o0o S 17.000.0o Swetha 87943632o Report View