Microsoft Access 2016 Beginner to Advanced

Course details

Microsoft Access is a database management system application; it stores data in its own form on the Access Jet database engine. This application is used by mainly software developers to develop application ;Microsoft Access 2016 Beginner to Advanced course is a complete collection with all the contents necessary to give you an overview of this application.
In this course, you will learn about its interface, create and edit databases, sorting and filtering data in a query, performing calculations, summarization of data, data normalization, advanced reporting, etc. By the end of this course, users should be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

COURSE CURRICULUM

Module - 1

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access
• Modify Table Data
• Work with Records
• Sort and Filter Records
• Create Lookups
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• The Access Options Dialog Box
• Relational Database Design
• Create a Table
• Modify a Table and Fields
• Create Table Relationships
• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries
• Data Normalization
• Create a Junction Table
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge
• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report
• Create a Mailing Label Report
• Publish a Report as PDF
• Activities – Microsoft Access 2016 for Beginners

Module - 2

• Add Controls to Forms
• Set Form Controls
• Create Subforms
• Organize Information with Tab Pages
• Enhance Navigation with Forms
• Format a Form
• Apply Conditional Formatting
• Field Validation
• Form and Record Validation
• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Convert a Macro to VBA
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
• Split a Database for Multiple User Access
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options
• Activities – Microsoft Access 2016 Advanced

Learning Outcomes:

• Get familiarized with Microsoft Access 2016, create simple databases, and use the help options
• Change table data, manage records and create lookups
• Join data from different tables, sort and filter them, and perform calculations for queries
• Creating, adding controls, enhancing appearance and print preparation for reports
• How to utilize Access Options dialog box
• Relational database design, creating tables, managing table fields and creating table relationships
• Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets
• Data normalization and creating junction tables
• Sharing Access data with other applications and through import and export options
• Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones
• Create mailing label report and publishing reports in PDF format
• Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting
• Data, field, form and record validation
• Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design
• Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance
• Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures
• Create and modify switchboards and startup options

Updated on 16 April, 2018