Office Tools for Data Management Notes | B.Sc. (Information Technology) Semester 1 | Mumbai University | munotes

Contents

Module I Practical 1

1. How This Paper Is Examined: the Journal, the Write-Up and the Practical Slip 1
2. Access from Zero: What It Is, and What You Do With It 5
3. The Access Window: the Ribbon, the Tabs and the Navigation Pane 9
4. Designing Before You Build: Entities, Keys and Normalisation 15
5. Practical 1B: Creating the Database, and Its First Two Tables 22
6. The Twelve Data Types, and Choosing One for Every Column 26
7. Practical 1B: Ten Rows in Each Table 31
8. Practical 1B: Integrity Constraints, the Primary Key, Required and the Foreign Key 35
9. Practical 1C: Building a Table With a Wizard, and Building One in Design View 40
10. Practical 1C: Adding a Field to a Table, and Deleting One 44
11. Practical 1C: the Input Mask 49
12. Practical 1C: the Validation Rule and the Validation Text 55
13. Practical 1C: Design View, Datasheet View, and Switching Between Them 60
14. Practical 2A: Typing Into a Masked Field 65
15. Practical 2B: Adding Records in the Datasheet, and Through a Form 69
16. Practical 2B: Adding Records With SQL, and the SQL View 73
17. Practical 2C: the Employee Database 79
18. Practical 2C: Deleting the Record for Kelly Marder 83
19. Practical 2C: Changing Pamela Milgrom's Salary 87
20. Practical 2C: Replace, and Every Manager That Becomes a Supervisor 91
21. Practical 3A: the Bookstore Database 96
22. Practical 3A: Adding a Book, Changing a Price, and Deleting a Title 101
23. Practical 3B: the employ Table, and Ten Records 107
24. Practical 3B: the Two Queries, Managers and Salary Over Fifteen Thousand 112
25. Queries That Go Further: Totals, Subqueries and the Joins Access Writes for You 117
26. Practical 3C: the Form Wizard 125
27. Practical 3C: Moving and Sizing Controls in a Form 131
28. Practical 3C: Using the Finished Form to Enter Data 137
29. Practical 4A: Adding Fields, and the Lookup Wizard's Combo Box 142
30. Practical 4A: Controls, Inheritance, and Command Buttons 149
31. Practical 4B: the Four Query Wizards 156
32. Practical 4C: a Query That Asks for Input 162
33. Practical 4D: the Expression Builder 168
34. Practical 5A: the Report Wizard 176
35. Practical 5A: Changing a Report's Controls 182
36. Practical 5B: a Calculated Control, and a Report Built on That Query 189
37. Practical 5B: Group Headers, Group Footers and the Totals They Carry 197
38. Practical 5C: Action Queries 204
39. Practical 5C: the Crosstab Query 211

Module II Practical 6

1. Practical 6: One Database, Several Tables, and the Relationships Window 219
2. Practical 6A: One-to-Many, and a Report That Walks It 224
3. Practical 6B: One-to-One, and When a Table Is Split in Two 230
4. Practical 6C: Many-to-Many, and the Junction Table 236
5. Practical 7A: Lookup Tables 242
6. Practical 7B: a Report From Three Tables, Field by Field 248
7. Practical 7B: Viewing by Publisher, Grouping, and Sorting 253
8. Practical 7B: Stepped Layout, Portrait, and the Report's Title 259
9. Practical 7C: the Relationship, and the Subform 264
10. Practical 8A: Importing a Table Out of an Excel Workbook 270
11. Practical 8A: the Relationship, and a Query Across Two Tables 276
12. Practical 8B: the Import Spreadsheet Wizard, Step by Step 281
13. Practical 8C: Exporting, and Every Format Access Offers 287
14. Practical 9A: Two Relationships, and What Referential Integrity Refuses 293
15. Practical 9B: the Switchboard, and the Navigation Form That Replaced It 298
16. Practical 9B: Linked Tables, and the Linked Table Manager 304
17. Practical 9C: the AutoExec Macro, and a Macro That Closes the Database 309
18. Practical 10A: the College Library Database 315
19. Practical 10A: Counting Copies by Subject 321
20. Practical 10A: Three Reports, by Publisher, by Title and by Edition 326
21. Practical 10B: the Database Splitter 332
22. Practical 10C: Making the Database Executable Only, the ACCDE 338
23. The Practical Examination: a Two Hour Plan, and Two Worked Slips 344