Access 2016

Microsoft Office Access 2016 Part 2

$0.00

Digital Courseware

Practical Exercise Files

In stock

Add to wishlist
Categories: , .

In this courseware, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

Objectives:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

Related Products

  • PowerPoint 2016

    Microsoft Office PowerPoint 2016 Part 2

    $0.00

    Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Without the help of a robust set of tools, it would be nearly impossible. However, Microsoft Office PowerPoint 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also do not consume all of your available time.

    Objectives:

    • Modify the PowerPoint 2016 environment.
    • Customize design templates.
    • Add SmartArt and math equations to a presentation.
    • Work with media and animations.
    • Collaborate on a presentation.
    • Customize a slide show.
    • Secure and distribute a presentation.
    Add to CartShow details
  • excel-2016

    Microsoft Office Excel 2016 Part 1

    $0.00

    This courseware aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

    Objectives:

    • Get started with Microsoft Office Excel 2016.
    • Perform calculations.
    • Modify a worksheet.
    • Format a worksheet.
    • Print workbooks.
    • Manage workbooks.
    Add to CartShow details
  • project-2016

    Microsoft Project 2016 Part 2

    $0.00

    This courseware covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

    Upon successful completion of this course, you will be able to manage an existing Microsoft Project Professional project plan.

    Objectives:

    • Identify project management concepts and navigate the Project 2016 environment.
    • Create and define a new project plan.
    • Create and organize tasks.
    • Manage resources in a project plan.
    • Finalize a project plan.
    Add to CartShow details
  • excel-2016

    Microsoft Office Excel 2016 Part 2

    $0.00

    This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel Expert Exam.

    Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

    Objectives:

    • Work with functions.
    • Work with lists.
    • Analyze data.
    • Visualize data with charts.
    • Use PivotTables and PivotCharts.
    Add to CartShow details