by Wiley | Released February 2014 | ISBN: 9781118903704

Master Access 2013 on your terms with this one-of-a-kind video training course Access 2013 is Microsoft's database management software that allows users to enter, manage, and build reports on large amounts of data. Our instructors provide expert, straight-forward, user-friendly training to help you tackle Access 2013 the way you want to learn. Get to know the Access work environment, master tables, DataFields, and Datatypes Understand queries and create a simple select query Build a simple UI with forms Create simple reports and automate tasks with macros Includes over 9 hours of Access 2013 video training If you're looking for real-world Access 2013 instruction, you'll find it here. Lesson files for this course can be found here http://www.wiley.com/WileyCDA/Section/id-826020.html Show and hide more

1. Lesson 1
   • What Is Access? 00:13:48
   • The Office 2013 Environment 00:10:55
   • The Access Work Environment 00:15:38
   • Tables 00:13:48
   • Views 00:17:57
   • Forms 00:10:10
   • Queries 00:13:17
   • Reports 00:08:36
   • Relationships 00:12:03
2. Lesson 2
   • Fields, Records, Datatypes, Data 00:21:02
   • Data Entry 00:13:50
   • The Datasheet View 00:13:20
   • Sorting, Filtering, and Totals 00:09:24
   • The Design View 00:17:00
   • AutoNumber and Primary Keys 00:07:56
   • Creating and Editing Relationships 00:15:05
   • Relationships: Referential Integrity 00:06:23
   • Input Masks and Validation 00:22:15
   • Using Lookups 00:08:47
3. Lesson 3
   • Creating a Simple Select Query 00:19:06
   • Grouping and Calculated Fields 00:11:00
   • Functions, Expressions 00:15:05
   • Joining Tables with Queries 00:15:40
   • Action Queries and Parameters 00:20:38
   • Crosstabs and Totals Queries 00:13:20
   • SQL: Access's Hidden Engine 00:09:19
4. Lesson 4
   • Building a Simple UI with Forms 00:13:30
   • Form Layout 00:14:29
   • Form Design 00:19:15
   • Adding Controls to a Form UI 00:18:31
   • Sorting and Filtering with Forms 00:07:55
   • Getting More Complex: Subforms, Split Forms, and Validation 00:12:46
   • Navigation Forms and More Subforms 00:14:23
5. Lesson 5
   • Creating Simple Reports 00:09:22
   • Using Expressions in a Report 00:06:41
   • Grouping and Sorting 00:16:09
   • Report Layout and Formatting 00:22:11
   • The Design View 00:22:39
6. Lesson 6
   • Automating Tasks with Macros 00:13:23
   • External Data: Importing, Linking, and Exporting 00:14:46
Show and hide more