
Identify the target users for Access 2013 - beginners, users of older versions, and recent version users - and explore the ribbon, web apps, and core changes.
Watch this video to learn how to access downloadable exercise files and which files to open for each exercise; unzip them and adjust high-definition playback speed.
Discover what's new in Access 2013 with a focus on apps and web apps. Learn about desktop databases, SharePoint and SQL Server support, templates, data import improvements, and deployment options.
Learn how to use touch with Access 2013 and the Office suite, including touch mode on the ribbon, larger targets, selecting objects, dragging, and typing options with an external keyboard.
Explore the Access 2013 workspace, templates, and how to create and save a desktop database. Learn to open files, search online templates, and handle security warnings about enabling content.
Explore the Access 2013 workspace, including the ribbon, quick access toolbar, and navigation pane; open and design forms, and use backstage view for save, print, compact, repair, and password encryption.
Explore how to access online, offline, and contextual help in Access 2013, including the help browser, search features, print options, and contextual dialog tips.
Explore keyboard shortcuts and key tips in Access 2013, view screen tips on the ribbon, and use Access Help to access a categorized list of shortcuts and subcategories.
Explore how to customize Access 2013 using the backstage view and the Access options dialog, adjusting general, current database, language, screen tips, and default save formats to suit your workflow.
Explore Access 2013 ribbon, its tabs, groups, and contextual tools, including the quick access toolbar and touch mode, switch between mouse and touch, minimize the ribbon, and add new tabs.
Explore the quick access toolbar in Access 2013, customize its visible commands, add the Find or Quick Print buttons, and position options below the ribbon for faster workflow.
Learn to customize the status bar in Access 2013 by switching between data sheet, form, layout, and design views with bottom-right controls and the view shortcuts.
Discover the main features of a desktop Access database, including managing a contact list with forms and data sheets, designing tables, entering records, and exploring web apps in Access 2013.
Build and publish access web apps that host data on SQL Server via SharePoint, enabling browser-based views for contacts and customers.
Create and design tables in Access 2013 using a movies database, switch between design and datasheet views, and define an auto number primary key with fields like title and year.
Explore adding gender and genre lookups in Access 2013, using combo boxes and limited lists, and create a dedicated genre table with a prefixed naming convention.
Explore creating and enforcing relationships between tables in an Access database by building a linking table between movies and genres, using primary keys and foreign keys, and enforcing referential integrity.
Create a movie_actor linking table to connect movies and actors with a role, enforce referential integrity, and illustrate one-to-many relationships between movies and actors.
Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.
Learn to Capture and Synthesize Information, Becoming a Data Management Guru.
Being a data rock star is more important than ever. To stand out in the workplace, it's essential to be able to find information fast and to identify game-changing insights.
The Microsoft Access 2013 database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications, included in the Professional and higher editions, or sold separately.
It is a tool that spans across many fields and is helpful to anyone needing to tightly organize varied data: office managers, project managers, executive assistants, scientists, and busy families to list a few.
Contents and Overview
Through 96 lectures, 19 hours of quality content, and 2 quizzes, this 19-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources.
Budding Access 2013 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence.
Practice files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application.
This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills.
Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.
** Updated June 2017. Course transcripts now available.