Microsoft Access 2013 Comprehensive 1st Edition Pratt Solutions Manual

1. Textbook Walk-Through
2. Microsoft Office 2013 and Windows 8
3. Office 2013 and Windows 8: Essential Concepts and Skills
4. Objectives
5. Introduction to the Windows 8 Operating System
6. Introduction to Microsoft Office 2013
7. Running and Using an App
8. Saving and Organizing Files
9. The Access Window
10. Screen Resolution
11. Renaming, Moving, and Deleting Files
12. Microsoft Office and Windows Help
13. Chapter Summary
14. Microsoft Office 365
15. Office 365 Essentials
16. Objectives
17. Introduction to Office 365
18. What is Office 365?
19. First Look at Office 365
20. Synchronization
21. Teams Using Office 365 in Business
22. Chapter Summary
23. Microsoft Access 2013
24. Ch 1: Databases and Database Objects: An Introduction
25. Objectives
26. Introduction
27. Project – Database Creation
28. Creating a Database
29. The Access Window
30. Determining Tables and Fields
31. Creating a Table
32. Previewing and Printing the Contents of a Table
33. Importing or Linking Data from Other Applications to Access
34. Additional Database Objects
35. Database Properties
36. Special Database Operations
37. Database Design
38. Chapter Summary
39. Ch 2: Querying a Database
40. Objectives
41. Introduction
42. Project – Querying a Database
43. Creating Queries
44. Sorting
45. Joining Tables
46. Creating a Form for a Query
47. Exporting Data from Access to Other Applications
48. Adding Criteria to a Join Query
49. Calculations
50. Crosstab Queries
51. Customizing the Navigation Pane
52. Chapter Summary
53. Ch 3: Maintaining a Database
54. Objectives
55. Introduction
56. Project – Maintaining a Database
57. Updating Records
58. Filtering Records
59. Changing the Database Structure
60. Mass Changes
61. Validation Rules
62. Making Additional Changes to the Database
63. Changing the Appearance of a Datasheet
64. Multivalued Fields in Queries
65. Referential Integrity
66. Ordering Records
67. Chapter Summary
68. Ch 4: Creating Reports and Forms
69. Objectives
70. Introduction
71. Project – Reports and Forms
72. Report Creation
73. Multiple-Table Reports
74. Form Creation
75. Mailing Labels
76. Chapter Summary
77. Ch 5: Multiple-Table Forms
78. Objectives
79. Introduction
80. Project – Multiple-Table Forms
81. Adding Special Fields
82. Updating the New Fields
83. Multiple-Table Form Techniques
84. Object Dependencies
85. Date/Time, Long Text, and Yes/No Fields in Queries
86. Datasheets in Forms
87. Creating a Multiple-Table Form Based on the Many Table
88. Chapter Summary
89. Ch 6: Advanced Report Techniques
90. Objectives
91. Introduction
92. Project – Creating Detailed Reports
93. Additional Tables
94. Creating Reports in Design View
95. Creating a Second Report
96. Chapter Summary
97. Ch 7: Advanced Form Techniques
98. Objectives
99. Introduction
100. Project – Advanced Form Techniques
101. Creating a Form with Combo Boxes and Command Buttons
102. Creating a Multipage Form
103. Chapter Summary
104. Ch 8: Macros, Navigation Forms, and Control Layouts
105. Objectives
106. Introduction
107. Project – Macros, Navigation Forms, and Control Layouts
108. Creating and Using Macros
109. Creating and Using a Navigation Form
110. Data Macros
111. Using Control Layouts on Forms and Reports
112. Chapter Summary
113. Ch 9: Administering a Database System
114. Objectives
115. Introduction
116. Project – Administering a Database System
117. Converting Databases
118. Microsoft Access Analysis Tools
119. Navigation Pane Customization
120. Table and Database Properties
121. Special Field Properties
122. Creating and Using Indexes
123. Automatic Error Checking
124. Data Type Parts
125. Templates
126. Encrypting a Database
127. The Trust Center
128. Locking a Database
129. Database Splitting
130. Web Apps
131. Chapter Summary
132. Ch 10: Using SQL
133. Objectives
134. Introduction
135. Project – Using SQL
136. SQL Background
137. SQL Queries
138. Sorting
139. Grouping
140. Joining Tables
141. Comparison with Access-Generated SQL
142. Updating Data through SQL
143. Chapter Summary
144. Ch 11: Database Design
145. Objectives
146. Introduction
147. Project – Design a Database
148. Entities, Attributes, and Relationships
149. Relational Databases
150. Database Design
151. TAL Distributors
152. Normalization
153. Special Topics
154. Chapter Summary
155. Index
156. Quick Reference Summary
157. Important Notes for Windows 7 Users
158. Dialog Boxes
159. Alternate Steps for Running an App in Windows 7

People also search:

Microsoft Access 2013 Comprehensive 1st

Microsoft Access 2013 Comprehensive 1st pdf

Microsoft Access 2013 Comprehensive 1st pdf free download

Microsoft Access 2013 Comprehensive 1st scribd

Microsoft Access 2013 Comprehensive 1st full download link

Microsoft Access 2013 Comprehensive 1st Edition Pratt Test Bank