This course is designed for participants who have little or no knowledge of MS Access. On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.
- Course Outline
This course is designed for participants who have little or no knowledge of MS Access. Participants should have basic knowledge of Windows, keyboard and mouse operations.
On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.
SECTION 1: Customizing Access
Lesson 1.1: Customizing Menus and Toolbars
Lesson 1.2: Setting Access Options, Part 1
Lesson 1.3: Setting Access Options, Part 2
Lesson 1.4: Creating Macros
Lesson 1.5: Advanced Macro Uses
SECTION 2: Advanced Data Tools
Lesson 2.1: Switchboards
Lesson 2.2: Creating Data Access Pages
Lesson 2.3: Modifying Data Access Pages
Lesson 2.4: Using Data Access Pages
SECTION 3: Advanced Queries
Lesson 3.1: Table Relationships
Lesson 3.2: Using CrossTab Queries
Lesson 3.3: Using Parameter Queries
Lesson 3.4: Advanced Reporting Features
SECTION 4: Pivot Tables and Pivot Charts
Lesson 4.1: Creating a PivotTable
Lesson 4.2: Using AutoForm and Creating PivotCharts
Lesson 4.3: Using PivotTables and PivotCharts
SECTION 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Using the Access Interface
Lesson 1.3: Getting Help
SECTION 2: Creating a Database
Lesson 2.1: First Steps
Lesson 2.2: Records
Lesson 2.3: Creating a Table
Lesson 2.4: Formatting Text
Lesson 2.5: Formatting Controls
SECTION 3: Doing More with Your Database
Lesson 3.1: Creating Forms
Lesson 3.2: Creating Queries
Lesson 3.3: Reports
Lesson 3.4: Sorting and Filtering Data
SECTION 4: Viewing and Printing Your Data
Lesson 4.1: Formatting a Datasheet
Lesson 4.2: Viewing Data
Lesson 4.3: Printing a Database Object
- Prerequisites & Certificates
Participants should have basic knowledge of Windows, keyboard and mouse operations.
Certificate of completion
- Cancellation Policy
Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.
- Map & Reviews
[ View Provider's Profile ]
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 2754 times.