jnrmod.blogg.se - Microsoft access 2013 step by step

Understand Primary Keys and Relationships.

Learn how to create relationships between Tables in a Database: using Key data.

Understand how to create and Normalize a database.

In Advanced Access, you’ll cover basic through advanced topics, including:

Use a Query to calculate the Total in a Report.

Create a Switchboard Form with Command buttons that open Forms and Reports.

Use Forms and Subforms to create a Search Form.

Learn how to design Forms and Subform that represent a one-to-many relatinship.

Create a One-From-Many Relationship by using a Combo Box on a Form.Review the definition of one-to-many relationships in a database.In Intermediate Access, you’ll cover basic through advanced topics, including: Learn how to manage Database files: Save and Save As.Learn how to design and modify Reports in Layout and Design Views.Use Query Criteria and Parameter Queries to select specific records in the Tables.Learn how to design Queries and use Queries to lookup records in the Tables.Edit the Form Properties to help Users navigate the Form Fields and enter data.Understand the purpose of Tables and how they are used in a database.Learn how to navigate the online course and submit your assignments.In Beginning Access, you’ll cover basic through advanced topics, including: Advanced Guide to Microsoft® Access 2013.Intermediate Guide to Microsoft® Access 2013.Beginning Guide to Microsoft® Access 2013.The following resources are available to download throughout the lessons:

Companion eBooks with pages of detailed instructionsĪll materials for this program are available online.Another Computer Mama Guide: If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need.