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

  • word 2016

    Microsoft Office Word 2016 Part 2

    $0.00 

    After you master the basics of using Microsoft Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you are ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.

    The Microsoft Office Word 2016 Part 2 courseware focuses on Creating professional-looking documents that can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.

    Objectives:

    • Organize content using tables and charts.
    • Customize formats using styles and themes.
    • Insert content using quick parts.
    • Use templates to automate document formatting.
    • Control the flow of a document.
    • Simplify and manage long documents.
    • Use mail merge to create letters, envelopes, and labels.
    Add to CartShow details
  • Access 2016

    Microsoft Office Access 2016 Part 3

    $0.00 

    In this courseware, you will learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. This courseware, added to that of Microsoft Office Access 2016 Part 1 and Microsoft Office Access 2016 Part 2 courseware, rounds out your Access education and provides you with marketable job skills.

    Objectives:

    • Customize a form layout to improve usability and efficiency of data entry.
    • Share data across applications.
    • Use macros to improve user interface design.
    • Use VBA to enhance tasks.
    • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
    • Lock down and prepare a database for distribution to multiple users.
    • Create and modify a database switchboard and set the start-up options.
    Add to CartShow details
  • PivotTables

    Microsoft Office Excel 2016/2019 Data Analysis with PivotTables

    $0.00 

    Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

    This courseware presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

    Objectives:

    • Prepare data for PivotTable reporting and create PivotTables from various data sources.
    • Analyze data by using PivotTables.
    • Work with PivotCharts.
    Add to CartShow details
  • Access 2016

    Microsoft Office Access 2016 Part 1

    $0.00 

    Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

    A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this courseware, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

    Objectives:

    • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
    • Organize and manage data stored within Access tables.
    • Use queries to join, sort, and filter data from different tables.
    • Use forms to make it easier to view, access, and input data.
    • Create and format custom reports.
    Add to CartShow details