Microsoft Access Tutorial

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="keywords" content="microsoft access tutorial, free ms access tutorial, how to use, create"> <meta name="Description" content="Learn how to use Microsoft Access with this free Microsoft Access tutorial."> <link rel="canonical" href="https://www.quackit.com/microsoft_access/tutorial/"> <title>Microsoft Access Tutorial</title> <script src="//ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script> <link rel="shortcut icon" href="/pix/favicon96.png"> <link rel="apple-touch-icon" href="/pix/apple-touch-icon.png"> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Lato:ital,wght@0,400;0,700;1,400&display=swap" rel="stylesheet"> <link href="/common/css/master.45.min.css" rel="stylesheet"> <script async src="https://cdn.fuseplatform.net/publift/tags/2/3499/fuse.js"></script>  <script async src="https://www.googletagmanager.com/gtag/js?id=G-Q3H025ZKLN"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-Q3H025ZKLN'); </script> </head> <body> <header class="site-header"> <div class="site-header-base"> <div class="site-logo"> <a title="Quackit Homepage" target="_top" href="/"><img src="/pix/quackit_logo_watermark.png" width="87" height="33" alt="Quackit Logo"></a> </div> <button id="site-nav-toggler" class="site-nav-toggler" aria-expanded="false" aria-controls="site-nav"> <span class="sr-only">Toggle navigation</span> ☰ </button> </div> <nav id="site-nav" class="site-nav"> <div class="site-links"> <ul> <li><a href="/"><i class="fa fa-home"></i> <span class="sr-only">Home</span></a></li> <li><a href="/html/">HTML</a></li> <li><a href="/css/">CSS</a></li> <li><a href="/scripting/">Scripting</a></li> <li><a href="/database/">Database</a></li> </ul> </div> <div class="site-search-top"> <form action="/search/" id="cse-search-box-bottom" class="site-search"> <div> <input type="hidden" name="cx" value="partner-pub-6331358926293806:98x0fk-bbgi"> <input type="hidden" name="cof" value="FORID:10"> <input type="hidden" name="ie" value="ISO-8859-1"> <input type="text" name="q" size="20" class="site-search-input"> <button type="submit" name="sa" class="site-search-button"><i class="fa fa-search"></i></button> </div> </form> </div> </nav> </header> <div class="main"> <article class="content"> <h1 class="page-title">Microsoft Access Tutorial</h1> <div class="ad ad-top">  <div data-fuse="23059883638"></div> </div> <ul class="pager"> <li><a href="/microsoft_access/howto/"><i class="fa fa-long-arrow-left" aria-hidden="true"></i> Access "How To" Articles</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm">Start Tutorial <i class="fa fa-long-arrow-right" aria-hidden="true"></i></a></li> </ul> <p class="lead">Learn Microsoft Access, starting with the basics. Create a database, tables, add a form, query data, and more. </p> <p>This tutorial uses Access 2016. For other versions, see below. </p> <div class="index"> <div class="row"> <div class="cell col-2"> <ul> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm">Introduction to Access</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_database_in_microsoft_access.cfm">Create a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_table_in_microsoft_access.cfm">Create a Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_table_in_design_view_in_microsoft_access.cfm">Create a Table in Design View</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_an_input_mask_in_microsoft_access.cfm">Create an Input Mask</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/add_data_to_a_table_in_microsoft_access.cfm">Add Data to Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/import_data_into_microsoft_access.cfm">Import Data from a CSV File</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_relationship_in_microsoft_access.cfm">Create a Relationship</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_lookup_table_in_microsoft_access.cfm">Create a Lookup Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_query_in_microsoft_access.cfm">Create a Query</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_query_with_user_input_in_microsoft_access.cfm">Create a Query with User Input</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/use_the_expression_builder_in_microsoft_access.cfm">How to use the Expression Builder</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/export_data_from_microsoft_access.cfm">Export Data to Excel (and XML)</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_form_in_microsoft_access.cfm">Create a Form</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/add_a_combo_box_to_a_form_in_microsoft_access.cfm">Add a Combo Box to a Form</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_report_in_microsoft_access.cfm">Create a Report</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_macro_in_microsoft_access.cfm">Create a Macro</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/backup_a_database_in_microsoft_access.cfm">Backup a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/split_a_database_in_microsoft_access.cfm">Split a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/make_an_executable_database_in_microsoft_access.cfm">Make an Executable Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/install_the_northwind_database_in_microsoft_access.cfm">Install the Northwind Database</a></li> </ul> </div> <div class="cell col-2"> <a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm"><img src="/pix/microsoft_access/tutorial/tutorial_home_access_2016.png" class="screenshot" alt="Screenshot of the MS Access 2016 Welcome Screen"></a> </div> </div> <div class="clr"></div> </div> <div class="ad">  <div data-fuse="23059883644"></div> </div> <p>This Microsoft Access tutorial is aimed at anyone who wishes to learn how to use Microsoft Access. It assumes a basic understanding of databases and how they work.</p> <ul class="pager"> <li><a href="/microsoft_access/howto/"><i class="fa fa-long-arrow-left" aria-hidden="true"></i> Access "How To" Articles</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm">Start Tutorial <i class="fa fa-long-arrow-right" aria-hidden="true"></i></a></li> </ul> <h2>More Access Tutorials</h2> <ul class="steps"> <li> <figure> <a href="/microsoft_access/howto/"><img src="/pix/microsoft_access/microsoft_access_2016/howto/how_to_create_a_totals_row_in_access_2016_5.png" class="screenshot steps" alt="Screenshot of a totals row in MS Access"></a> <figcaption> <h3><a href="/microsoft_access/howto/">Access "How To" Articles</a></h3> <p>Large list of "how to" articles that show step-by-step instructions for doing common tasks in Access.</p> <p>Includes mini-tutorials for doing things like, creating a totals row, creating a parameter query, password protecting your database, doing a mail merge, and much more. </p> <a class="btn btn-default" href="/microsoft_access/howto/">Go to Access Howto</a> </figcaption> </figure> </li> <li> <figure> <a href="/database/tutorial/"><img src="/pix/microsoft_access/tutorial/tutorial_home_database_tutorial.png" class="screenshot steps" alt="Screenshot of a database"></a> <figcaption> <h3><a href="/database/tutorial/">Introduction to Databases</a></h3> <p>If you don't currently have an understanding of how databases work, no worries — I have written a <a href="/database/tutorial/">basic database tutorial</a> just for you!</p> <p>This tutorial covers the basic concepts of databases, and the examples use Microsoft Access, so that will make it easier for you once you return here.</p> <a class="btn btn-default" href="/database/tutorial/">Go to the Database Tutorial</a> </figcaption> </figure> </li> </ul> <h2>Previous Versions of Access</h2> <p>Here are tutorials from previous versions of Access.</p> <ul class="steps"> <li> <figure> <a href="/microsoft_access/microsoft_access_2013/tutorial/"><img src="/pix/microsoft_access/tutorial/tutorial_home_access_2013.png" class="screenshot steps" alt="Screenshot of Microsoft Access 2013"></a> <figcaption> <h3><a href="/microsoft_access/microsoft_access_2013/tutorial/">Access 2013 Tutorial</a></h3> <p>Microsoft Access 2013 is the predecessor to Access 2016. There's not much difference in functionality between Access 2016 and 2013, so you could do both tutorials with either 2013 or 2016.</p> <a class="btn btn-default" href="/microsoft_access/microsoft_access_2013/tutorial/">Go to Access 2013 Tutorial</a> </figcaption> </figure> </li> <li> <figure> <a href="/microsoft_access/microsoft_access_2003/tutorial/"><img src="/pix/microsoft_access/tutorial/tutorial_home_access_2003.gif" class="screenshot steps" alt="Screenshot of Microsoft Access 2003"></a> <figcaption> <h3><a href="/microsoft_access/microsoft_access_2003/tutorial/">Access 2003 Tutorial</a></h3> <p>Check out what Access used to look like back in 2003! See how far Access has come since the early days. </p> <a class="btn btn-default" href="/microsoft_access/microsoft_access_2003/tutorial/">Go to Access 2003 Tutorial</a> </figcaption> </figure> </li> </ul> <ul class="pager"> <li><a href="/microsoft_access/howto/"><i class="fa fa-long-arrow-left" aria-hidden="true"></i> Access "How To" Articles</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm">Start Tutorial <i class="fa fa-long-arrow-right" aria-hidden="true"></i></a></li> </ul> </article> <div class="sidebar"> <nav> <ul> <li> <h3><a href="/microsoft_access/tutorial/"><i class="fa fa-database"></i> MS Access 2016 Tutorial</a></h3> <ul> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/access_2016_introduction.cfm">Introduction to Access</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_database_in_microsoft_access.cfm">Create a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_table_in_microsoft_access.cfm">Create a Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_table_in_design_view_in_microsoft_access.cfm">Create a Table in Design View</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_an_input_mask_in_microsoft_access.cfm">Create an Input Mask</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/add_data_to_a_table_in_microsoft_access.cfm">Add Data to Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/import_data_into_microsoft_access.cfm">Import Data from a CSV File</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_relationship_in_microsoft_access.cfm">Create a Relationship</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_lookup_table_in_microsoft_access.cfm">Create a Lookup Table</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_query_in_microsoft_access.cfm">Create a Query</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_query_with_user_input_in_microsoft_access.cfm">Create a Query with User Input</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/use_the_expression_builder_in_microsoft_access.cfm">How to use the Expression Builder</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/export_data_from_microsoft_access.cfm">Export Data to Excel (and XML)</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_form_in_microsoft_access.cfm">Create a Form</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/add_a_combo_box_to_a_form_in_microsoft_access.cfm">Add a Combo Box to a Form</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_report_in_microsoft_access.cfm">Create a Report</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/create_a_macro_in_microsoft_access.cfm">Create a Macro</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/backup_a_database_in_microsoft_access.cfm">Backup a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/split_a_database_in_microsoft_access.cfm">Split a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/make_an_executable_database_in_microsoft_access.cfm">Make an Executable Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/install_the_northwind_database_in_microsoft_access.cfm">Install the Northwind Database</a></li> </ul> </li> <li> <h3><a href="/microsoft_access/howto/"><i class="fa fa-question-circle"></i> How To...</a></h3> <ul> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_create_a_totals_row_in_access_2016.cfm">Create a Totals Row</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_create_a_calculated_field_in_access_2016.cfm">Create a Calculated Field</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_create_a_parameter_query_in_access_2016.cfm">Create a Parameter Query</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_find_duplicate_records_in_access_2016.cfm">Find Duplicate Records</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_use_the_crosstab_query_wizard_in_access_2016.cfm">How to use the Crosstab Query Wizard</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_password_protect_a_database_in_microsoft_access_2016.cfm">Password Protect a Database</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_create_a_database_diagram_in_access_2016.cfm">Create a Database Diagram</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_add_a_subform_to_a_form_in_access_2016.cfm">Create a Subform</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_do_a_mail_merge_in_access_2016.cfm">Do a Mail Merge</a></li> <li><a href="/microsoft_access/microsoft_access_2016/howto/how_to_link_an_access_database_to_sql_server_in_microsoft_access_2016.cfm">Link Access to SQL Server</a></li> <li><a style="font-style:italic;" href="/microsoft_access/howto/">More...</a></li> </ul> </li> <li> <h3 class="heading-only"><i class="fa fa-book"></i> Access Versions</h3> <ul> <li><a href="/microsoft_access/microsoft_access_2016/tutorial/">MS Access 2016</a></li> <li><a href="/microsoft_access/microsoft_access_2013/tutorial/">MS Access 2013</a></li> <li><a href="/microsoft_access/microsoft_access_2003/tutorial/">MS Access 2003</a></li> </ul> </li> <li> <h3><a href="/database/"><i class="fa fa-database"></i> Other DB Tutorials</a></h3> <ul> <li><a href="/database/tutorial/" title="Into to databases">Database Tutorial</a></li> <li><a href="/sql/tutorial/" title="Structured Query Language">SQL Tutorial</a></li> <li><a href="/sqlite/tutorial/" title="">SQLite Tutorial</a></li> <li><a href="/mysql/tutorial/" title="Open source DB management system">MySQL Tutorial</a></li> <li><a href="/sql_server/tutorial/" title="Microsoft SQL Server">SQL Server Tutorial</a></li> <li><a href="/mongodb/tutorial/" title="Document-store database for big data.">MongoDB Tutorial</a></li> <li><a href="/neo4j/tutorial/" title="Graph database management system for big data.">Neo4j Tutorial</a></li> </ul> </li> </ul> </nav> <div class="ad ad-left">  <div data-fuse="23059883641"></div> </div> </div> <div class="ads"> <div class="ad ad-right">  <div data-fuse="23059511718"></div> </div> </div> </div> <div class="searchbox-bottom"> <form action="/search/" id="cse-search-box-bottom" class="site-search"> <div> <input type="hidden" name="cx" value="partner-pub-6331358926293806:npmuvy-i8kk"> <input type="hidden" name="cof" value="FORID:10"> <input type="hidden" name="ie" value="ISO-8859-1"> <input type="text" name="q" size="30" class="site-search-input"> <button type="submit" name="sa" class="site-search-button"><i class="fa fa-search"></i></button> </div> </form> <script src="//cse.google.com/cse/brand?form=cse-search-box-bottom&lang=en"></script> </div> <footer> <p class="about"><a href="/"><i class="fa fa-home"></i> Home</a> | <a href="/about.cfm" rel="nofollow">About</a> | <a href="/contact.cfm" rel="nofollow">Contact</a> | <a href="/terms_of_use.cfm" rel="nofollow">Terms of Use</a> | <a href="/privacy_policy.cfm" rel="nofollow">Privacy Policy</a></p> <p>© Copyright 2000 - 2025 Quackit.com  </p> </footer> <script src="/common/js/spectrum/spectrum.js"></script> <script src="/common/js/lightbox2-master/dist/js/lightbox.min.js" charset="utf-8"></script> <script> $(document).ready(function(){ $( "#site-nav-toggler" ).click(function() { $( "#site-nav" ).toggle( "slow" ); }); }); </script> <script> $(function(){var a=window.location.href;$(".sidebar nav a").each(function(){a==this.href&&$(this).closest("li").addClass("selected")})}); </script> </body> </html>

CINXE.COM

Microsoft Access Tutorial