- Duration / Course length: Upto 26 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
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
- 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 12
- Create a Mailing Label Report
- Publish a Report as PDF
- Activities – Microsoft Access 2016 for Beginners
Job roles this course is suitable for:
IT Consultants , Manager IT Project Management , IT Support EngineerAbout Adams Academy
Adams Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.
Our Mission
To make learning more accessible to learning enthusiasts, regardless of where they are residing in the world. To offer different courses of different levels for the students to choose from. To position our company as a leader in the industry of online learning.
Our Vision
Maintain the good credibility and reputation that we have built as online courses provider.
