Microsoft Access 2016 for Beginners هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

The new version of Access has included few features and other connectivity options that will help users to be more efficient. If you have no experience, then learning more about financial literacy is ideal.
This course presentation will help users to address their concerns about Access programs. To be able to access the flagship database, you should choose skills and training application in the most convenient place and time to reap more benefits from it.

COURSE CURRICULUM

Getting Started with Access

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access

Working with Table Data

• Modify Table Data
• Work with Records
• Sort and Filter Records
• Create Lookups

Querying a Database

• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query

Creating Advanced Queries

• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data

Generating Reports

• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print

Customizing the Access Environment

• The Access Options Dialog Box

Designing a Relational Database

• Relational Database Design
• Create a Table
• Modify a Table and Fields
• Create Table Relationships

Joining Tables

• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries

Organizing a Database for Efficiency

• Data Normalization
• Create a Junction Table

Sharing Data Across Applications

• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge

Advanced Reporting

• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report 12

Additional Reporting Options

• Create a Mailing Label Report
• Publish a Report as PDF

Activities

• Activities – Microsoft Access 2016 for Beginners

تحديث بتاريخ 17 September, 2019