Course Code | VEL157 |
---|---|
Qualification | Certificate |
Payment Options | Upfront & Payment Plans |
Delivery | Online & Correspondence |
Duration | 25 Hours |
SECTION 1: Customizing Access
Lesson 1.1: Customizing Menus and Toolbars
Customizing Menus
Creating Menus
Showing and Hiding Toolbars
Customizing Toolbars
Creating Toolbars
Practice Exercise
Lesson 1.2: Setting Access Options, Part 1
Setting General and View Options
Setting Editing and Keyboard Options
Setting Datasheet, Form, and Report Options
Setting Page and Tables/Queries Options
Setting Advanced Options
Practice Exercise
Lesson 1.3: Setting Access Options, Part 2
Setting Training Materials Options
Setting Spelling Options
Setting AutoCorrect Options
Setting Start-Up Options
Practice Exercise
Lesson 1.4: Creating Macros
Using the Macro Design Toolbar
Creating a Macro
Running a Macro
About Macro Groups
Practice Exercise
Lesson 1.5: Advanced Macro Uses
Editing a Macro with the Visual Basic Editor
Assigning a Macro to a Keystroke
Assigning a Macro to a Toolbar
Viewing and Printing Macro Definitions
Practice Exercise
Section 1: Review Questions
SECTION 2: Advanced Data Tools
Lesson 2.1: Switchboards
Using a Switchboard
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard
Practice Exercise
Lesson 2.2: Creating Data Access Pages
Using the Data Access Page Wizard
Using Design View to Create a Data Access Page
Using an Existing HTML Page
Practice Exercise
Lesson 2.3: Modifying Data Access Pages
Adding a Theme
Adding Text and Controls
Formatting Text and Controls
Aligning and Sizing Content
Adding Images
Practice Exercise
Lesson 2.4: Using Data Access Pages
Basics of Using Data Access Pages
Viewing Data Entered Via a Data Access Page
Protecting Data
Practice Exercise
Section 2: Review Questions
SECTION 3: Advanced Queries
Lesson 3.1: Table Relationships
Normalizing Your Data
Establishing Referential Integrity
Using Cascade Update and Cascade Delete
Setting Fields for Indexing
Using Indexing
Practice Exercise
Lesson 3.2: Using CrossTab Queries
Understanding CrossTab Queries
Creating a CrossTab Query Using the Wizard
Creating a CrossTab Query Manually
Practice Exercise
Lesson 3.3: Using Parameter Queries
Setting up Parameter Queries
Using a Parameter Query
Practice Exercise
Lesson 3.4: Advanced Reporting Features
Using AutoFormat
Aligning and Formatting Controls
Adding Pictures and Lines
Practice Exercise
Section 3: Review Questions
SECTION 4: Pivot Tables and Pivot Charts
Lesson 4.1: Creating a PivotTable
Creating a PivotTable Using the Wizard
Continuing Where the Wizard Left Off
More about Fields
Completing Your PivotTable
Practice Exercise
Lesson 4.2: Using AutoForm and Creating PivotCharts
Creating a PivotTable Using AutoForm
Creating a PivotChart Using AutoForm
About PivotChart Fields
Completing a PivotChart
Practice Exercise
Lesson 4.3: Using PivotTables and PivotCharts
Using a PivotTable
Using a PivotChart
Editing a PivotTable or PivotChart
Common PivotChart Editing Features
Turning a PivotTable into a PivotChart and Vice-Versa
Practice Exercise
Section 4: Review Questions
We live in a society where the pressures of daily living are high with financial expenses, personal and work commitments, and mortgage and rental obligations. Then there are the unexpected life challenges that also get thrown our way. With this in mind the thought of taking on study can be daunting for most people. Here at Learning Cloud we understand that life doesn’t run in a straight line it has many ups and downs.
As an enrolled student at Learning Cloud, you are entitled to access a variety of non-academic support services from the Student Services Unit. These supports are designed to walk beside you throughout your studies they will assist you in life’s ups and downs to provide you the best opportunity to successfully complete your chosen course.
STUDENT SERVICES PROGRAMS INCLUDE:
Call our student support today on 0800 000 361 or Email Faculty
Get more informationWant more information about financial and student support? Fill out the enquiry form to the right and a study consultant will contact you with the details you need.
How will this course advance my career?
Learning Cloud programs have been developed in response to industry demand and are specifically designed to equip graduates with work-ready skills. Each participant will be trained and assessed in theory and in practical tasks and Real-world exercises are used throughout the program.
Studies prove, time and again, that college-educated workers earn more than those with only a high school qualification. College graduates often enjoy additional benefits, including greater job opportunities and promotions. Though the proof for greater earning potential exists, some might wonder whether the cost of the education warrants the overall expense in the long run.
College Graduate vs. Non-Graduate Earnings
The National Centre for Education Statistics (NCES) analyses employee earnings data biennially, according to education level. Findings indicate that workers with a qualification earn significantly more than those without. Since the mid-1980s, education has played a large part in potential wages, with bachelor's degree holders taking home an average of 66% more than those with only a high school diploma do. While college-educated workers' wages have increased over the past two decades, those with only a high school education have seen decreases in annual salaries in the same time period (nces.ed.gov).
How else will I benefit from studying with Learning Cloud?