Overview of the Program

Welcome to our Microsoft Access Beginner Course! This course is designed for individuals who are new to Microsoft Access or have limited experience with the software. Throughout this program, you will embark on a guided journey to understand the foundational concepts and functionalities of Access. From creating databases to managing and querying data, this course will equip you with the essential skills needed to effectively work with databases using Access. Join us as we explore the basics and unlock the potential of Microsoft Access for organizing and analyzing data with ease and efficiency.

Delivery Method

The training sessions are conducted in a face-to-face format at our educational facility located in Ealing. These sessions are led by Microsoft-certified experts who possess substantial experience in instructing students on MS Office applications.

Topics Covered in the Beginner Microsoft PowerPoint Course

• Understanding Database Basics:
Gain insight into the fundamentals of databases, including an introduction to Microsoft Access and its key components.

• Exploring Database Management Systems:
Learn about the role of database management systems (DBMS) in organizing and managing data efficiently.

• Navigating the Ribbon:
Discover the Ribbon interface in Microsoft Access, which houses various commands and features for database management.

• Utilising the Quick Access Toolbar:
Explore the Quick Access Toolbar, a customizable toolbar for accessing frequently used commands and functions.

• Opening a Database:
Learn how to open existing databases in Microsoft Access, enabling you to access and work with stored data and objects.

• Understanding Database Objects:
Discover the different types of objects that constitute a database, such as tables, queries, forms, and reports.

• Managing Records:
Master essential record management tasks, including entering, editing, deleting, and sorting records within a database.

• Entering Records:
Learn how to input new records into a database, ensuring accurate and complete data entry for effective data management.

• Navigating Data Sheets and Forms:
Explore techniques for navigating data sheets and forms, enabling efficient data entry and interaction.

• Editing Field Values:
Discover methods for editing field values within records, allowing for updates and modifications as needed.

• Finding and Replacing Records:
Learn how to locate specific records within a database and replace field values as required for data maintenance.

• Deleting Records:
Explore the process of deleting records from a database, ensuring data integrity and cleanliness.

• Sorting Records:
Master the art of sorting records within a database, facilitating data organization and analysis.

• Utilizing Data:
Learn basic printing techniques and explore simple queries to extract and analyze data effectively.

• Exploring Print Preview:
Discover how to use the Print Preview feature to review and adjust the appearance of printed documents before printing.

• Adjusting Margins and Orientation:
Learn how to set margins and adjust orientation for printing various database objects, ensuring optimal printing results.

• Running Queries:
Explore the process of running queries to extract specific data subsets from a database based on predefined criteria.

This Microsoft Access Database Basics Course provides a comprehensive introduction to database management, equipping participants with the essential skills needed to navigate and utilise Microsoft Access effectively for data organization, management, and analysis.

Study Options

Choose the number of days per week you wish to study (lessons are 3 hours per day for all options):

• 5 days per week
• 3 days per week
• 2 days per week

Dates and Duration

The course is flexible. You can start on any Monday and study for as many weeks as you wish. We however recommend a minimum of 3 to 6 months to see a marked improvement in proficiency.

Requirements

The beginner’s level of this course can be started with no previous qualifications. You can choose to move on to our Microsoft Access Intermediate Course if you find the beginner level too easy.

Course Benefits

• A training program designed and delivered by qualified and experienced Microsoft Application professionals
• A Certificate of Achievement on successful completion
• Blended learning environment
• Flexible study options

Overview of the Program

Welcome to our Microsoft Access Intermediate Course! This course bridges the gap between basic proficiency and advanced mastery, offering a comprehensive exploration of intermediate-level features and functionalities in Microsoft Access. Designed for individuals with a solid understanding of Access fundamentals, this program delves deeper into database management techniques, query optimization, form customization, and report design. Throughout this course, participants will enhance their skills in manipulating data, creating dynamic forms, generating insightful reports, and streamlining database operations. Join us as we embark on a journey to elevate your Access proficiency to the next level.

Delivery Method

The training sessions are conducted in a face-to-face format at our educational facility located in Ealing. These sessions are led by Microsoft-certified experts who possess substantial experience in instructing students on MS Office applications.

Topics Covered in the Intermediate Microsoft Access Course

• Managing Objects:
Learn effective techniques for managing database objects, including organization, renaming, and deletion to streamline database navigation and maintenance.

• Formatting and Reorganizing Datasheets:
Discover methods for formatting and reorganizing datasheets to improve readability and facilitate data analysis within Microsoft Access.

• Filtering Records by Field Values:
Explore the process of filtering records based on specific field values to extract relevant data subsets for analysis and reporting.

• Filtering by Range of Field Values:
Learn to apply filters based on a range of field values, enabling precise data selection for comprehensive analysis and reporting.

• Inserting a Total Row into a Datasheet:
Master the insertion of Total rows into datasheets to calculate summary statistics or totals for numeric fields, enhancing data analysis capabilities.

• Database Creation and Protection:
• Creating a Database:
Learn the steps involved in creating a new database in Microsoft Access, including defining database properties and specifying file locations.
• Converting a Database:
Explore methods for converting databases between different formats or versions, ensuring compatibility and data integrity across platforms.
• Protecting a Database:
Discover techniques for database protection, including setting passwords, user permissions, and other security measures to safeguard sensitive data.

• More about Data:
• Creating a Table:
Learn how to create tables in Microsoft Access to store and organize data effectively, including defining field properties and data types.
• Primary Key:
Understand the importance of primary keys in database tables for uniquely identifying each record and enforcing data integrity.
• Importing Data from Another Application:
Explore techniques for importing data from external sources or other applications into Microsoft Access, enabling seamless data integration.
• Exporting Data:
Learn how to export data from Microsoft Access to external file formats for sharing, analysis, or backup purposes.
• Creating a Form:
Discover the process of creating forms in Microsoft Access to provide a user-friendly interface for data entry and interaction.
• Object Dependencies:
Understand object dependencies in Microsoft Access, including relationships between forms, tables, queries, and reports for efficient database management.
• Selecting Records for Printing in a Report:
Learn techniques for selecting specific records to print within a report, enabling customized reporting based on user-defined criteria.

• From Question to Query:
• Creating a Select Query:
Explore the process of creating select queries in Microsoft Access to retrieve specific data subsets from one or more tables.
• Using the Query Design Grid:
Learn to use the query design grid to define query criteria, select fields, and specify sorting options for precise data retrieval.
• Setting Selection Criteria in a Query:
Discover methods for setting selection criteria in queries to filter records based on specific conditions or criteria.
• Setting Criteria on Multiple Fields:
Master the application of criteria on multiple fields within a query to refine data retrieval and analysis.
• Setting Multiple Criteria on the Same Field:
Explore techniques for setting multiple criteria on the same field within a query, enabling complex data filtering and analysis.
• Sorting Records in a Query:
Learn how to sort records within a query based on one or more fields to organize data for analysis and reporting.
• Delete Query:
Discover the functionality of delete queries in Microsoft Access for removing records from tables based on specified criteria.
• Make Table Query:
Explore the make table query in Microsoft Access for creating new tables based on query results, facilitating data transformation and analysis.
• Update Query:
Learn how to use update queries in Microsoft Access to modify existing records in tables based on specified criteria, enabling bulk data updates and corrections.

This comprehensive Microsoft Access course provides a detailed exploration of database management, data manipulation, and query creation, equipping participants with the skills needed to effectively navigate and utilize Microsoft Access for various data-related tasks.

Study Options

Choose the number of days per week you wish to study (lessons are 3 hours per day for all options):

• 5 days per week
• 3 days per week
• 2 days per week

Dates and Duration

The course is flexible. You can start on any Monday and study for as many weeks as you wish. We however recommend a minimum of 3 to 6 months to gain see a marked improvement in proficiency.

Requirements

Enrollment in the intermediate level of this course does not require any prior qualifications. However, it is essential to possess a foundational understanding of Excel at the beginner level. If you lack this skill level, we recommend taking the Beginner Access Course to acquire the necessary proficiency.

Course Benefits

By completing the Microsoft Access Intermediate course, you'll gain the following advantages:

• Certificate of Achievement:
Receive an official Certificate of Achievement upon course completion, attesting to your proficiency in Microsoft Access at the intermediate level.

• CV Enhancement:
Bolster your CV with a recognized qualification, making you a more appealing candidate to prospective employers.

• Career Advancement:
Position yourself as a stronger contender in the job market and interviews by showcasing your intermediate-level Access skills.

• Boosted Confidence:
Develop confidence in your Access abilities, allowing you to handle tasks with assurance and proficiency.

• Enhanced Efficiency:
Acquire the skills to navigate Access swiftly, resulting in increased productivity.

• Professional Competence:
Attain a user-friendly command of the software, equipping you with the tools to excel in your professional endeavors.

Completing this course equips you with a valuable skill set that not only enhances your CV but also empowers you to effectively utilise Microsoft Access for personal and professional tasks.

Overview of the Program

Welcome to our Microsoft Access Advanced Course! This course is designed for individuals who have a strong foundation in Access and are ready to elevate their skills to the next level. Throughout this program, participants will delve into advanced database management techniques, query optimization strategies, form customisation, report design, and automation. From complex data analysis to sophisticated form and report customisation, this course will equip you with the tools and knowledge needed to become a proficient Access user. Join us as we explore advanced features and functionalities that will enhance your ability to manage and analyse data effectively within the Access environment.

Delivery Method

The training sessions are conducted in a face-to-face format at our educational facility located in Ealing. These sessions are led by Microsoft-certified experts who possess substantial experience in instructing students on MS Office applications.

Topics Covered in the Advanced Microsoft Access Course

• Datasheet View:
Gain proficiency in navigating and interacting with table data using the datasheet view, allowing for quick data entry and manipulation.

• Design View:
Learn to customize table structure and properties using the design view, enabling precise control over field definitions and data types.

• Restricting Data Entry in Fields:
Discover methods for restricting what data can be entered into specific fields, ensuring data integrity and consistency.

• Input Masks:
Explore the use of input masks to standardize data entry formats and enforce specific patterns for data input.

• Lookup Lists:
Learn to create lookup lists for fields, providing users with predefined options for data entry and enhancing data consistency.

• Indexing a Table:
Understand the importance of indexing tables for optimizing data retrieval performance and enforcing data integrity constraints.

• Establishing Table Relationships:
• Relationships Between Tables:
Master the establishment of relationships between tables, enabling the creation of logical connections for efficient data retrieval and analysis.

• Forms for Data Entry:
• Form Properties:
Explore form properties to customize form appearance and behavior, enhancing user experience and interaction.
• Preventing Access to Form Fields:
Learn techniques for preventing access to specific form fields, ensuring data security and integrity.
• Changing Field Access Order:
Discover methods for changing the order of field access within forms, optimising data entry workflows.
• Utilising Subforms:
Learn to incorporate subforms within main forms to display related data from multiple tables, facilitating comprehensive data entry and interaction.

• Collecting and Sharing Data:
• Controls Positioning and Organisation:
Explore techniques for positioning and organizing form controls to optimize user interface layout and usability.
• Creating Text Boxes and Other Controls:
Learn to create various form controls, including text boxes, check boxes, option groups, labels, and calculated controls, to facilitate data entry and presentation.
• Calculating Statistics in Forms and Reports:
Explore methods for calculating and displaying statistics within forms and reports, providing valuable insights into data trends and patterns.
• Creating Set Lists of Values:
Learn to create lists of predefined values for form controls, enabling standardized data entry and consistency.

• Customising Control Presentation:
• Moving, Copying, and Resizing Controls:
Master techniques for moving, copying, and resizing form controls to achieve desired layout and presentation.
• Formatting Text and Controls:
Explore options for formatting text and controls, including font styles, colors, and alignment, to enhance visual appeal and readability.
• Conditional Formatting:
Learn to apply conditional formatting to form controls, dynamically altering appearance based on specified criteria for improved data visualization.
• Grouping and Ungrouping Controls:
Discover methods for grouping and ungrouping form controls to organize and manage complex forms more effectively.

• Enhancing Reports for Data Communication:
• Sorting and Grouping Records in Reports:
Explore techniques for sorting and grouping records in reports to present data in a logical and organized manner.
• Printing and Page Formatting:
Learn to format reports for printing, including options for page numbering, headers, footers, and printing groups on separate pages.
• Creating Pivot Tables and Pivot Charts:
Discover the power of pivot tables and pivot charts for dynamic data analysis and visualization, enabling interactive exploration of large datasets.

• Advanced Query Techniques:
• Calculated Fields, Statistics, and Parameter Queries:
Explore advanced query techniques, including calculated fields, statistics without grouping, parameter queries, and advanced query types like find unmatched and find duplicates.
• Crosstab Queries and Pivot Tables:
Learn to create crosstab queries and pivot tables for summarizing and analyzing data across multiple dimensions, providing valuable insights into data trends and patterns.

This comprehensive Microsoft Access course provides in-depth coverage of table design, form and report creation, advanced query techniques, and data analysis tools, empowering participants to effectively manage and analyze data within the Access environment.

Study Options

Choose the number of days per week you wish to study (lessons are 3 hours per day for all options):

• 5 days per week
• 3 days per week
• 2 days per week

Dates and Duration

The course is flexible. You can start on any Monday and study for as many weeks as you wish. We however recommend a minimum of 3 to 6 months to see a marked improvement in proficiency.

Requirements

To enroll in the Advanced Microsoft Access Course, it is essential to possess an Intermediate level of proficiency in MS Access. If you currently lack this skill level, we recommend considering enrollment in the Intermediate Microsoft Access Course to acquire the necessary expertise before progressing to the advanced level.

Course Benefits

Completing the Advanced Microsoft Access Course offers a multitude of advantages:

• Certificate of Achievement:
Attain an official Certificate of Achievement at the Advanced level, validating your advanced proficiency in Microsoft Access.

• CV Enhancement:
Elevate your CV with a recognized qualification, bolstering your appeal to potential employers.

• Career Advancement:
Sharpen your competitive edge in the job market and interviews by showcasing your advanced Access skills.

• Enhanced Confidence:
Develop a strong sense of confidence in your ability to navigate and utilize Access' advanced features.

• Increased Efficiency:
Acquire the skills to swiftly perform tasks, boosting your productivity.

• Professional Competence:
Gain a user-friendly mastery of the software, making you a proficient and effective professional.

By completing this course, you will not only solidify your Access skills but also set yourself apart as an advanced user, well-equipped to excel in various professional scenarios.