Microsoft Access 2013 Beginner to Advanced Training
ACCREDITED BY
Course Description:
Microsoft Access is the database management system of choice for IT professionals. This course is a comprehensive guide to the programme and offers teaching on the fundamental aspects like setting up tables, manipulating data, reports, mail merges, macros, and much more. This certificate will be a great enhancement to your CV, as it is widely used by businesses.
Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
What skills will I gain?
- Generate databases and reports
- Mail merge
- Import / export data
- Advanced form design
- Data validation
- Database management
What is the target audience?
- This course would be suitable for anyone who would like to learn alongside work or childcare
- This course is suitable for those who work in, or would like to work in, technical roles within the IT industry
How will I be assessed?
- At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
- Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.
What Certification am I going to receive?
If you successfully pass the exam then you will be awarded a Microsoft Access 2013 – Beginner to Advanced certificate.
What careers can I get with this qualification?
With this course, you are able to fulfil various roles, such as:
- Software Engineer
- Technical Support
- Technical Sales
- Business Analyst
- Web Developer
- Software Tester
Key Features
Gain an accredited UK qualification
Access to excellent quality study materials
Learners will be eligible for TOTUM Discount Card
Personalized learning experience
One year’s access to the course
Support by phone, live chat, and email
Learners who successfully complete the course will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training by CPD and iAP.
Learners who successfully complete the course will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training by CPD and iAP.
| ------------ BEGINNER ------------ | |||
| 1. INTRODUCTION TO ACCESS 2013 | |||
| Orientation to Microsoft Access | |||
| Simple Access Database | |||
| Get Help in Microsoft Access | |||
| 2. TABLE DATA | |||
| Modify Table Data | |||
| Sort and Filter Records | |||
| Create Lookups | |||
| 3. QUERYING A DATABASE | |||
| Join Data from Different Tables in a Query | |||
| Sort and Filter Data in a Query | |||
| Calculations in a Query | |||
| 4. ADVANCED QUERIES | |||
| Parameter Queries | |||
| Action Queries | |||
| Unmatched and Duplicate Queries | |||
| Summarize Data | |||
| 5. GENERATING REPORTS | |||
| Create a Report | |||
| Controls to a Report | |||
| 6. ENHANCE THE APPEARANCE OF A REPORT | |||
| Appearance of a Report | |||
| Report for Print | |||
| 7. THE ACCESS OPTIONS DIALOG BOX | |||
| The Access Options Dialog Box | |||
| ------------ INTERMEDIATE ------------ | |||
| 1. RELATIONAL DATABASE | |||
| Relational Database Design | |||
| Create a Table – Access | |||
| Create Table Relationships | |||
| 2. JOINING TABLES | |||
| Create Query Joins | |||
| Join Tables That Have No Common Fields | |||
| Relate Data within a Table | |||
| Work with Subdatasheets | |||
| Create Subqueries | |||
| 3. ORGANIZING A DATABASE FOR EFFICIENCY | |||
| Data Normalization | |||
| Create a Junction Table | |||
| Improve Table Structure | |||
| 4. IMPORT AND EXPORT THE DATA | |||
| Import Data into Access | |||
| Export Data to Text File Formats | |||
| Export Access Data to Excel | |||
| 5. MAIL MERGE | |||
| Create a Mail Merge | |||
| 6. ADVANCED REPORTING | |||
| Organize Report Information | |||
| Format Reports | |||
| Control Formatting in a Report | |||
| Add a Calculated Field to a Report | |||
| Subreport to an Existing Report | |||
| ------------ ADVANCED ------------ | |||
| 1. ADVANCED FORM DESIGN | |||
| Create Subforms | |||
| Organize Information with Tabs Pages | |||
| Navigation of Forms | |||
| Conditional Formatting | |||
| 2. DATA VALIDATION | |||
| Field and Record Validation | |||
| Form Validation | |||
| 3. USER INTERFACE DESIGN | |||
| Create a Macro | |||
| Restrict Records Using a Condition | |||
| Validate Data Using a Macro | |||
| 4. DATA ENTRY USING A MACRO | |||
| Automate Data Entry Using a Macro | |||
| Convert a Macro to VBA | |||
| 5. DATABASE MANAGEMENT | |||
| Link Tables to External Data Sources | |||
| Manage a Database | |||
| Determine Object Dependency | |||
| Document a Database | |||
| Analyze the Performance of a Database | |||
| 6. SECURING A DATABASE | |||
| Splitting a Database for Multiple User Access | |||
| Implement Security | |||
| Set Passwords | |||
| 7. DISTRIBUTING DATABASE | |||
| Convert an Access Database to an ACCDE File | |||
| Analyze the Performance of a Database | |||
| 8. SWITCHBOARDS | |||
| Create a Database Switchboard | |||
| Modify a Database Switchboard | |||
| Set Startup Options | |||
| Mock Exam | |||
| Mock Exam : Microsoft Access 2013 – Beginner to Advanced | |||
| Final Exam | |||
| Exam : Microsoft Access 2013 – Beginner to Advanced | |||
Related Courses
Well Designed Course
A well designed course that fitted in with my work and home life. The knowledge I acquired has been invaluable.