100 megs data gift for every genuine quote requested
Access 2013 has enhanced features, and the knowledge of which is essential to use Access 2013 efficiently will be taught in this Access 2013 Beginner Training Course.
The course is designed to provide participants with the knowledge to use of all the essential functions of Access 2013.
From basic functions such as opening and closing Access to creating new apps, this training course helps participants to use Access 2013 to fulfil multiple tasks.
This dynamic training course is now available in Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
This course is for students with no prior knowledge of Microsoft Access or relational databases.
This course is designed to teach you the concepts of relational database architecture and knowledge for building an Access database.
During this course, you will learn how to build tables to store data in related tables, create forms for data entry, create and execute queries to analyse data and produce printable reports.
If you have inherited an Access database that you have to learn how to manage and maintain or simply just need to know how to work with an Access database, then this course is for you.
At the completion of this course, students will gain a solid understanding of the relational database concepts and terminology used throughout Microsoft Access.
Students will also be able to build a simple database, manipulate data via forms and create basic queries and reports.
Learning Outcomes - Microsoft Access 2013 Beginner Training Course
Developing essential knowledge and skills in using Access 2013 helps participants to perform various tasks, including creating a new app, managing his/her account, using the interface, understanding database terms, and more.
After completing this course, participants will have learned to:
- Navigate within the Microsoft Access application environment and create a simple database.
- Organise and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Create advanced queries, including action queries and parameter queries.
- Create and format custom reports.
- Customise Access configuration options.
Course Content - Microsoft Access 2013 Beginner Training Course
Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help in Microsoft Access
Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic C: Create Lookups
Lesson 3: Querying a Database
Topic A: Join Data from Different Tables in a Query
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Create Action Queries
Topic C: Create Unmatched and Duplicate Queries
Topic D: Summarize Data
Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Lesson 6: Customizing the Access Environment
Topic A: The Access Options Dialog Box