Video description
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.htmlTable of contents
-
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
-
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
-
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
-
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:54
- Getting More Complex: Subforms, Split Forms, and Validation 00:12:46
- Navigation Forms and More Subforms 00:14:23
-
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
-
Lesson 6
- Automating Tasks with Macros 00:13:23
- External Data: Importing, Linking, and Exporting 00:14:46
Product information
- Title: Access 2013 Essentials
- Author(s):
- Release date: February 2014
- Publisher(s): Wiley
- ISBN: 9781118903704
You might also like
video
Hands-On Microsoft Access 2019
Microsoft Access 2019 is an information management tool that stores information and, arguably, helps manage data …
book
Power Query Cookbook
Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily …
book
Access 2019 Bible
Master database creation and management Access 2019 Bible is your, comprehensive reference to the world's most …
video
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
