Access: Access 2016 (Windows) beginner
Technology:
Expertise:
- 3 Courses | 1h 19m 28s
- 5 Books | 48h 8m
- 2 Courses | 53m 13s
- 4 Books | 25h 14m
- 2 Courses | 1h 16m 44s
- 3 Books | 37h 12m
- 2 Courses | 1h 47s
- 5 Books | 55h 6m
- 5 Courses | 2h 30m 21s
- 4 Books | 43h 2m
- 5 Courses | 3h 23m 9s
- 3 Books | 23h 31m
- 5 Courses | 4h 3m 37s
- 2 Books | 25h 14m
- 5 Courses | 3h 59m 9s
- 3 Books | 35h 41m
Microsoft Access is a relational database system. Explore Access and how to use it.
GETTING STARTED
Working with Databases in Access 2019 for Windows
-
4m 41s
-
4m 30s
GETTING STARTED
Working with Databases in Access 2016 for Windows
-
4m 3s
-
4m 58s
GETTING STARTED
Working with Databases in Access 2013 for Windows
-
6m 43s
-
5m 43s
GETTING STARTED
Working with Databases in Access 2010 for Windows
-
6m 15s
-
5m 54s
GETTING STARTED
Inserting, Importing & Formatting Data in Access 2019 for Windows
-
3m 8s
-
3m 21s
GETTING STARTED
Tables, Fields, & Entries in Access 2016 for Windows
-
5m 37s
-
2m 48s
GETTING STARTED
Understanding Tables, Fields, & Entries in Access 2013 for Windows
-
5m 54s
-
4m 34s
GETTING STARTED
Understanding Tables, Fields, & Entries in Access 2010 for Windows
-
6m 41s
-
4m 58s
COURSES INCLUDED
Working with Databases in Access 2019 for Windows
A database is an organized collection of data that can be accessed, analyzed, and exported into useful reports. In order to create a database, you will first need to become familiar with the database tool at hand. In this 6-video course, "Working with Databases," you will explore the Access 2019 database application in the Microsoft Office 2019 suite. Learners will also discover how to open existing databases and create new ones, and learn how to customize the interface, including the Quick Access Toolbar and ribbon. Begin the Access 2019 course by observing how to open the application and open a database, and then how to use database templates to create a database quickly. You will then navigate the interface to locate tools available to manage and create a database, and explore how to customize the application's interface and theme. This leads into customizing the Quick Access toolbar. Learners will conclude the course by observing how to customize the tool ribbon.
6 videos |
25m
Assessment
Badge
Saving, Printing & Exporting Databases in Access 2019 for Windows
In this 6-video course, "Saving, Printing, and Exporting Databases," learners will discover how to save data, print database items, export a database, and send tables via email in Access 2019. To begin, learn how to save your data as a database or object, and then move onto saving regularly and repairing, backing up, and adjusting your database save settings. This leads learners into observing how to protect a database by adding password encryption if it contains confidential or sensitive data. Any object contained in your Access database can be printed, so you will next learn how to print items in your database. Furthermore, learn how to export data that you have compiled in your database to a different program; observe how Access allows you to export data in a variety of different formats including Excel spreadsheets, PDF files, and HTML formatted web pages. You will conclude the course by discovering how to send your database table via email using Access's integrated email function.
6 videos |
20m
Assessment
Badge
Tables, Fields & Entries in Access 2019 for Windows
To get the most out of Access 2019, one needs to understand the structure and main elements of a database. In this 9-video course, "Access 2019: Tables, Fields, and Entries," learners can explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties. Begin by learning the structure and key features of your database such as a table, field, value, query, and form. Then learn how to create a table automatically or manually in a database, and organize, filter, and hide database items. Examine how to insert fields into tables, format database fields, and edit database field properties, as each field in an Access data table has a particular format. In Access, you will often find that data values inserted into different tables are related, so discover how to link data in different tables to help visualize the relationship between records spread across multiple tables. Then move on to observing how to manage data relationships, and finally, to learning how to visualize object dependencies.
9 videos |
33m
Assessment
Badge
COURSES INCLUDED
Working with Databases in Access 2016 for Windows
Access 2016 is the database application in the Microsoft Office 2016 suite. Discover how to open existing databases and create new ones, and learn how you can customize the interface, including the Quick Access Toolbar and ribbon.
6 videos |
27m
Assessment
Badge
Saving, Printing & Exporting Databases in Access 2016 for Windows
Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2016.
6 videos |
26m
Assessment
Badge
COURSES INCLUDED
Working with Databases in Access 2013 for Windows
Make the most of Access 2013 by learning the basics of database creation. Explore the interface; learn about default navigation settings; and discover how to customize the interface, Quick Access Toolbar, and ribbon.
7 videos |
43m
Badge
Saving, Printing, & Exporting Databases in Access 2013 for Windows
Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2013.
6 videos |
33m
Badge
COURSES INCLUDED
Working with Databases in Access 2010 for Windows
An Access 2010 database allows you to store data for a variety of different purposes. Discover how to create a database, use and customize the interface, modify default navigation settings, and adjust program settings.
5 videos |
33m
Badge
Saving, Protecting, & Exporting Databases in Access 2010 for Windows
In order to get the most out of Access 2010, you need to understand how to use it. Discover how to save, protect, back up, and export data. Also, learn how to share a table via email.
5 videos |
27m
Badge
COURSES INCLUDED
Inserting, Importing & Formatting Data in Access 2019 for Windows
In this 8-video course, "Access 2019: Inserting, Importing, and Formatting Data," learners will discover how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with data. Begin the course by learning how to insert data into a table, and then explore how to modify the default navigation settings. In Access, you can import data that has been created or edited in a different program, which can save you the time required to manually reenter your data values or records. You will next learn how to use Excel data in a database. This leads into exploring how to import an address book from Outlook. Thereafter, learners will delve into formatting text in their data; creating a dropdown menu; and also creating data validation rules, which can be used to place limits on the information that can be inserted into access data tables. The course concludes by demonstrating how to create labels.
8 videos |
31m
Assessment
Badge
Finding & Organizing Data in Access 2019 for Windows
There are multiple ways to find or search for elements and Access allows you to adapt your view on fields by sorting and filtering data values. This 6-video course, "Access 2019: Finding and Organizing Data," allows learners to discover how to sort, filter, find, and replace features available in Access 2019. This process will enable you to save time and locate the information you need most within your Access database values. To begin, you will learn how to sort the data in the data tables, and then filter the data in the data tables. Explore how to search and locate data values, which is useful if you have a large number of records in your data table. Also, you will discover how to replace data values. Creating an index in Access can help find a value or record more quickly, which is particularly useful if a data table contains a large number of records; learners will also observe how to edit database indexes. Conclude with a look at finding duplicate values in a database.
6 videos |
22m
Assessment
Badge
Creating Forms & Queries in Access 2019 for Windows
Forms in Access 2019 are designed to help you visualize records and create new data entries more easily. In this 8-video course, "Access 2019: Creating Forms and Queries," learners discover how to create forms quickly using the form wizard tool, add data values, create queries, and perform calculations. Begin by learning how to create a data entry form with the wizard tool, before exploring the use of different form types. Discover how to create a data entry form from scratch, and edit form elements by inserting text in a form. You will then observe how to create a simple query, as well as a crosstab query, which allows you to cross reference data that you have extracted from your Access database. The course continues by demonstrating how to perform a simple calculation, with which, for example, you can apply sum, maximum, and average formulas to analyze the information inserted into a query, and concludes by showing learners how to create a calculated field.
8 videos |
33m
Assessment
Badge
Customizing Forms in Access 2019 for Windows
In this 8-video course, "Access 2019: Customizing Forms," learners explore how to add and customize forms, restructure individual elements, or change the theme to enhance a form's look and feel. Begin by formatting text boxes inserted into a form. Then move on to inserting a list box-list boxes can be used to limit values that can be inserted into forms. Next, observe how to insert checkboxes, which can be used to simplify some of the questions or fields in an Access form. This leads into inserting buttons, used to give users greater control over Access data entry forms. Next, delve into reorganizing a form, making an Access form easier to use by reorganizing different elements and controls that have been created. Then explore editing information in a form, such as title, time, date, or adding images. Discover how to customize the appearance of a form, by, for example, changing the overall theme, selecting a new color, and changing the text font schemes. Conclude the course by observing how to edit a form's properties.
8 videos |
41m
Assessment
Badge
Using the Report & Analysis Tools in Access 2019 for Windows
To get the most out of a database, you can extract data and analyze data patterns. Reports allow you to extract and view the information you need. You can also get a clear global view of a database by keeping your data clean. Once you have created a database, it is important to know how to analyze and interpret data. In this 5-video Access 2019 course, you will discover how to create reports, as well as how to create custom and automatic reports to extract needed information. Also, learners will observe how to clean up a database and analyze the database itself. Begin by creating a quick report, then learn how to create a database report from scratch. This leads to exploring how to customize a report, for example, formatting text and inserting additional items, modifying the layout or page orientation. Next, explore cleaning up a database; Access Speech is a useful query that can be used to clean up a database file. Conclude the course by observing how to analyze a database.
5 videos |
20m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Tables, Fields, & Entries in Access 2016 for Windows
To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties.
9 videos |
39m
Assessment
Badge
Inserting, Importing, & Formatting Data in Access 2016 for Windows
There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data.
8 videos |
35m
Assessment
Badge
Finding & Organizing Data in Access 2016 for Windows
As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records.
6 videos |
24m
Assessment
Badge
Creating Forms & Queries in Access 2016 for Windows
Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries.
16 videos |
1h 16m
Assessment
Badge
Using the Report & Analysis Tools in Access 2016 for Windows
For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.
5 videos |
28m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Understanding Tables, Fields, & Entries in Access 2013 for Windows
Before creating your database in Access 2013, it is a good idea to have an understanding of how it is structured. Learn about working with tables and fields, as well as formatting, editing, data relationships, and object dependencies.
9 videos |
52m
Badge
Inserting, Importing, & Formatting Data in Access 2013 for Windows
After creating tables and fields, you're ready to add and format your data. Learn how to insert and format table data, create dropdown menus and validation rules, use external data, import address books, and create labels in Access 2013.
7 videos |
40m
Badge
Finding & Organizing Data in Access 2013 for Windows
Adjust how you view and analyze your data by learning about the sorting and filtering features in Access 2013. Explore locating and replacing values, editing indexes, and finding duplicates.
6 videos |
29m
Badge
Creating Forms & Queries in Access 2013 for Windows
In Access 2013, forms can simplify the process of data entry and queries allowing you to return information based on specified criteria. Learn about creating and customizing forms, as well as creating queries and calculations.
15 videos |
1h 28m
Badge
Report & Analysis Tools in Access 2013 for Windows
In Access 2013, a report can be used to present information that has been extracted from a database. Discover how to create a quick, database, and automatic reports. Also, explore methods of cleaning up and analyzing databases.
5 videos |
32m
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Understanding Tables, Fields, & Entries in Access 2010 for Windows
Within a database, data is stored and organized in tables. Discover how to create and manage tables, insert and edit fields and field properties, link table data, and manage relationships in Access 2010.
9 videos |
52m
Badge
Inserting, Importing, & Formatting Data in Access 2010 for Windows
Once you've created fields in Access 2010, you can begin entering and formatting data. Discover how to add and format data, create dropdown menus, configure data validation, use external data, import an address book, and create labels.
7 videos |
40m
Badge
Finding & Organizing Data in Access 2010 for Windows
Organize data for better analysis. Explore sorting and filtering, locating and replacing data values, editing database indexes, and finding duplicates in an Access 2010 database.
6 videos |
29m
Badge
Creating Forms & Queries in Access 2010 for Windows
A form provides an interface where you can insert data into multiple fields from multiple tables via a single screen. Discover how to create and customize forms, and create queries in Access 2010.
14 videos |
1h 10m
Badge
Report & Analysis Tools in Access 2010 for Windows
A PivotTable can be used to change how data is visualized and help with analyzing database records. Discover how to create and use PivotTables and PivotCharts, and use database reporting and cleanup in Access 2010.
8 videos |
46m
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Access 2019 BibleWith clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer.
16h 34m
By Dick Kusleika, Michael Alexander
Book
Access 2019 for DummiesHolding all the secrets behind the mysteries of Access, this book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports.
5h 41m
By Ken Cook, Laurie Ann Ulrich
Book
Access in Easy StepsWhether you're using Access in the Office 365 suite or a standalone Office product, you can use this guide to learn the key features and get more out of Access.
1h 25m
By Mike McGrath
Book
Discovering Microsoft Office 2019: Word Excel Access Powerpoint, Includes Windows 10Microcomputers are wonderful tools that can save time and energy when used correctly. This book is designed to help you learn firsthand just how easy these tools are to use.
5h 6m
By Edward G. Martin
Book
Microsoft Access 365 Complete: In Practice, 2019Offering a fresh approach to teaching today's students Microsoft Access, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
19h 22m
By Annette Easton, Randy Nordell
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2016 in Easy StepsWhether you're upgrading to Access 2016 or new to the database concept, this resource neatly demonstrates the important functions in a clear and concise manner, so you can get going quickly with this popular database application.
1h 43m
By Mike McGrath
Book
Access 2016 BibleWith clear guidance toward everything from the basics to the advanced, this go-to reference provides everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way.
16h 22m
By Dick Kusleika, Michael Alexander
Book
Access 2016 For DummiesWritten in a friendly and accessible manner, yet assuming no prior Access or database-building knowledge, this helpful guide walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis.
5h 44m
By Ken Cook, Laurie Ulrich Fuller
Book
Access in Easy StepsWhether you're using Access in the Office 365 suite or a standalone Office product, you can use this guide to learn the key features and get more out of Access.
1h 25m
By Mike McGrath
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2013 BibleProviding you with a thorough look at everything Access can do, this well-rounded, authoritative resource helps you gain a solid understanding of database purpose, construction, and application with Access 2013.
19h 33m
By Dick Kusleika, Michael Alexander
Book
Access 2013 For DummiesCombining the latest Access features with the basics of building usable databases, this handy, friendly guide unlocks the magic of Access so you can learn to create an app from the Welcome screen, get support for your desktop databases, and much more.
5h 41m
By Ken Cook, Laurie Ulrich Fuller
Book
Access 2013 All-in-One for DummiesExactly what you need to get up to speed on the latest changes to Access, this easy-to-understand resource provides invaluable advice enabling you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources.
11h 58m
By Alison Barrows, Allen G. Taylor, Joseph C. Stockman
BOOKS INCLUDED
Book
Straight to the Point: Microsoft Access 2010Assessing what's new in Microsoft Access 2010, this book introduces Relational Databases; explains how to create a database, table, form, query, or report; explores expressions; offers keyboard shortcuts; and more.
3h 45m
By Dinesh Maidasani
Book
Microsoft Access 2010 All-in-One For DummiesIf you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference will help you make Access more accesssible, from the basics like tables, queries, and forms, to advanced functions such as database administration.
12h 57m
By Alison Barrows, Joseph C. Stockman, Margaret Levine Young
Book
Access 2010 24-Hour TrainerDesigned for beginner-to intermediate-level Access users, this practical guide covers the basics of building and working with the major features of the program and provides examples of building Access database applications from scratch or from existing templates.
10h
By Geoffrey L. Griffith, Truitt L. Bradly
Book
Access 2010 For DummiesIn the classic For Dummies tradition, this book provides an education in Access, the interface, and the architecture of a database, and explains the process of building a database, linking information, sharing data, generating reports, and much more.
6h
By Ken Cook, Laurie Ulrich Fuller
Book
Access 2010 BibleWhether you want to use the power of Access 2010 to manipulate datasheets, build forms with wizards, or automate query parameters, this book is packed with pages of tips, techniques, and the instruction you need to succeed with Access 2010.
22h 24m
By Michael R. Groh
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2019 for DummiesHolding all the secrets behind the mysteries of Access, this book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports.
5h 41m
By Ken Cook, Laurie Ann Ulrich
Book
Access 2019 BibleWith clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer.
16h 34m
By Dick Kusleika, Michael Alexander
Book
Access in Easy StepsWhether you're using Access in the Office 365 suite or a standalone Office product, you can use this guide to learn the key features and get more out of Access.
1h 25m
By Mike McGrath
Book
Microsoft Access 365 Complete: In Practice, 2019Offering a fresh approach to teaching today's students Microsoft Access, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
19h 22m
By Annette Easton, Randy Nordell
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Access 2016 For DummiesWritten in a friendly and accessible manner, yet assuming no prior Access or database-building knowledge, this helpful guide walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis.
5h 44m
By Ken Cook, Laurie Ulrich Fuller
Book
Access 2016 BibleWith clear guidance toward everything from the basics to the advanced, this go-to reference provides everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way.
16h 22m
By Dick Kusleika, Michael Alexander
Book
Access in Easy StepsWhether you're using Access in the Office 365 suite or a standalone Office product, you can use this guide to learn the key features and get more out of Access.
1h 25m
By Mike McGrath
BOOKS INCLUDED
Book
Access 2013 For DummiesCombining the latest Access features with the basics of building usable databases, this handy, friendly guide unlocks the magic of Access so you can learn to create an app from the Welcome screen, get support for your desktop databases, and much more.
5h 41m
By Ken Cook, Laurie Ulrich Fuller
Book
Access 2013 BibleProviding you with a thorough look at everything Access can do, this well-rounded, authoritative resource helps you gain a solid understanding of database purpose, construction, and application with Access 2013.
19h 33m
By Dick Kusleika, Michael Alexander
BOOKS INCLUDED
Book
Microsoft Access 2010 All-in-One For DummiesIf you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference will help you make Access more accesssible, from the basics like tables, queries, and forms, to advanced functions such as database administration.
12h 57m
By Alison Barrows, Joseph C. Stockman, Margaret Levine Young
Book
Access 2010 BibleWhether you want to use the power of Access 2010 to manipulate datasheets, build forms with wizards, or automate query parameters, this book is packed with pages of tips, techniques, and the instruction you need to succeed with Access 2010.
22h 24m
By Michael R. Groh
Book
Access 2010 In PicturesHelping beginners learn to use Access 2010, this useful guide shows you how to work with tables, forms, queries, and reports that will make your databases shine.
20m
By In Pictures, Inc.
