This training course covers all the functionalities of Access 2013.<\/p>\n
This is the database management software of the Office 2013 suite. In this training course, you will see how to create several tables, the tables in which the data is organized.<\/p>\n
To make filling your tables easier, Access 2013 allows you to create and customize registration forms.<\/p>\n
You can then create queries, which allow you to retrieve data from several tables, to cross-reference them and link common elements.<\/p>\n
Queries also allow calculations to be performed and columns to be automatically filled.<\/p>\n
Finally, learn how to generate reports: documents automatically completed by the software from your data.<\/p>\n
Chapter 01 - Discovering the application<\/strong> Chapter 2 - Database Structure<\/strong> Chapter 3 - Entering and Modifying Data<\/strong> Chapter 4 - Searching for Data in a Database<\/strong> Chapter 5 - Creating Forms<\/strong> Chapter 6 - Using Queries<\/strong> Chapter 7 - Working together on a document<\/strong> Chapter 8 - Configuring and customizing the application<\/strong> This training course covers all the features of Access 2013. Access is the database management software in the Office 2013 suite. In this course, you will learn how to create multiple tables, the tables in which data is organized. To more easily populate your tables, Access 2013 allows you to [\u2026]<\/p>","protected":false},"author":1,"featured_media":6049,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[2417,2416],"tags":[2457,2459,2458,461,1979,2072,2442,2428,444],"class_list":["post-6048","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-informatique","category-videotheque","tag-access","tag-access-2013","tag-apprenez","tag-astuce","tag-document","tag-etude","tag-formation","tag-tutorial","tag-video"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\n1- Create a database<\/a>
\n2- Use database templates<\/a>
\n3- Navigating the interface<\/a>
\n4- Back up your data<\/a>
\n5- Back up regularly<\/a>
\n6- Protecting access to a database<\/a><\/p>\n
\n1- The structure of a database<\/a>
\n2- Create a table<\/a>
\n3- Organizing the elements of a database<\/a>
\n4- Inserting fields into a table<\/a>
\n5- Format the fields of a table<\/a>
\n6- Edit the properties of a field<\/a>
\n7- Fill in a table<\/a>
\n8- Linking data between different tables<\/a>
\n9- Edit a relationship<\/a><\/p>\n
\n1- Formatting your data<\/a>
\n2- Create drop-down lists<\/a>
\n3- Use external data<\/a>
\n4- Import your Outlook address book<\/a>
\n5- Modify data validation rules<\/a>
\n6- Create labels<\/a><\/p>\n
\n1- Sorting your data<\/a>
\n2- Filtering the data in a table<\/a>
\n3- Quickly find a value<\/a>
\n4- Simply replace data<\/a>
\n5- Modify the search index<\/a>
\n6- Detect duplicates<\/a><\/p>\n
\n1- Create your first registration form<\/a>
\n2- Create a form manually<\/a>
\n3- Enter text into the form<\/a>
\n4- Insert input fields<\/a>
\n5- Insert a list box<\/a>
\n6- Insert checkboxes<\/a>
\n7- Insert action buttons<\/a>
\n8- Reorganize a form<\/a>
\n9- Add information to a form<\/a>
\n10- Customize the overall appearance of the form<\/a>
\n11- Modify the properties of a form<\/a><\/p>\n
\n1- Understanding the dependencies between your data<\/a>
\n2- Create a simple query<\/a>
\n3- Create a crosstab query<\/a>
\n4- Perform a simple calculation<\/a>
\n5- Create a calculation field<\/a>
\n6- Cleaning a database<\/a>
\n7- Analyze the contents of the tables<\/a><\/p>\n
\n1- Quickly create a report on your data<\/a>
\n2- Create a custom report<\/a>
\n3- Generate a document automatically<\/a>
\n4- Print items<\/a>
\n5- Send a database by email<\/a><\/p>\n
\n1- Exporting your database<\/a>
\n2- Change navigation settings<\/a>
\n3- Customize the interface display<\/a>
\n4- Customize the toolbars<\/a>
\n5- Customize the ribbon<\/a><\/p>","protected":false},"excerpt":{"rendered":"