Access 2016

Microsoft Office Access 2016 Part 3

$0.00

Digital Courseware

Practical Exercise Files

In stock

Add to wishlist
Categories: , .

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.

Related Products

  • 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
  • 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
  • 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
  • word 2016

    Microsoft Office Word 2016 Part 1

    $0.00

    Microsoft Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this courseware, you will learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

    Objectives:

    • Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
    • Format text and paragraphs.
    • Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
    • Enhance lists by sorting, renumbering, and customizing list styles.
    • Create and format tables.
    • Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
    • Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
    • Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
    Add to CartShow details