Microsoft Access 2016 for Beginners - CPD Certified & IAO Approved
Course
Online
Description
-
Type
Course
-
Level
Beginner
-
Methodology
Online
-
Class hours
269h
-
Duration
Flexible
-
Start date
Different dates available
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.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.
On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods
Reviews
Subjects
- Access
- Options
- Database
- Database training
- Microsoft Access
- Action Queries
- Filter Records
- Summarize Data
- Data in a Query
- Report for Print
Teachers and trainers (1)
Adams Academy
Instructor
Course programme
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
Microsoft Access 2016 for Beginners - CPD Certified & IAO Approved