Microsoft Access 2013

Microsoft Office Access 2013 helps you create databases to track and report information with ease. Data is automatically stored in a SQL database for safe-keeping and you can easily share your applications with colleagues. Get started quickly with prebuilt applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you makes sense of the data for informed decision-making.

* You have 4 weeks to complete this course from date of your enrollment.

Microsoft Access 2013 Module 1 Chapters 1 €œ 6
Access Basics, Tables and Data

Module one identifies the powerful and easy to use features that Access provides for your business needs. You will be introduced to the inner workings of Access, such as building big databases and how to seamlessly navigate the workspace. Creating applications, defining tables, and data entry basics are covered, as well as file types and uses.

• Building Big Databases
• Navigating the Workspace
• Primary Keys
• Indexing, Renaming and Modifying Tables
• Data Entry

Name of the Course Module 2 Chapters 7 €œ 16
Data Management, Forms and the Web

Module two introduces tools for data management such as importing and exporting data, sorting and filtering and using queries to edit your data automatically. The ability to generate and customize forms for specific business purposes is also covered. Recycling database parts for more efficient database buildings and learning how to work with the AND and OR operators is addressed.

• Generating and Customizing Forms
• Translating and Exporting File Formats
• Sorting and Filtering Data
• Calculations
• Action Queries

Name of the Course Module 3 Chapters 17 - 20
Simple Reporting

Module three describes the principles of automatic reporting and the basic layouts and templates that can be used. Adjustments to layouts such as designing custom headers and footers and creating custom individual sections will be covered. This module will also help you design themes, add pictures, use text boxes and labels for total customization.

• Automatic Reporting
• Print Options Tab and Page Tab
• Layout Basics
• Headers and Footers
• Adjusting Individual Sections

Name of the Course Module 4 Chapters 21 €œ 24
Additional Access Features

Module four introduces you to the Table Analyzer, which sets up and documents the performance of your database. You will also learn about documenting databases, importing spreadsheets and how to resolve common problems with Access. Tips and tricks for seamless use of Access are addressed in the last chapter, like ways to dodge deletion distress and keeping your data safe.

• Database Documenter
• Ten Common Problems
• Parameter Dialog Box
• Documenting Everything
• Delete With Caution