MS Access 2007 Intermediate Online Course

0( 0 REVIEWS )

123 STUDENTS

ACCREDITED BY

Buy Now

Overview:

The Microsoft Access 2007 Intermediate course will teach learners how to bring together different elements and create a cohesive application. The course is perfect for users with basic knowledge of Access that will help them build on the introduction they’ve already had to the application. It is hands-on training and how to be more interactive with Access and use dialog boxes and more controls. Individuals will also learn how to create macros and how to select proper Event and Control to achieve the most productive outcome. Getting certified in Microsoft Access 2007 Intermediate will give learners the edge on showcasing their skills to potential employees as this is a popular and core skill of Microsoft.

The Microsoft Access 2007 Intermediate course will cover programming tips and how to enhance their database knowledge through macros and effective reports.

The course will help you become an expert in Access 2007 and offer insight into program system-level software. The course will help Individuals become efficient at using Access 2007 for both business and personal use. It is an essential skill that can be applied to any job role. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2007 Intermediate.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

Learn how to design an application
Learn how to use macros
Understand helpful programming tips
Learn how to effectively use dialog boxes, sub-forms and controls
Learn how to create charts and PivotTables

Course Titles

Module 01: Relational Databases
Module 02: Working with Related Tables
Module 03: Complex Queries
Module 04: Advanced Form Design
Module 05: Reports and Printing
Module 06: Charts
Module 07: PivotTables and PivotCharts

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

The course is aimed at individuals who have basic knowledge of Access 2007.
Students looking to expand their skills in Microsoft Office Access 2007.
The course is ideal for individuals working as programmers.
Anyone interested in developing their skills in Microsoft Office Access 2007.

Entry Requirements

You must be 16 or over
You should have a basic understanding of English and basic IT knowledge
You will need a computer or tablet with internet connection (or access to one)

Method of Assessment

At the end of the Microsoft Access 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2007 Intermediate.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Access 2007 Intermediate you will be qualified to work in the following positions. The Microsoft Access 2007 Intermediate qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

Programmer – £44,873 per annum
Web Developer – £24,833 per annum
Project Assistant – £20,785 per annum
Business Executive – £23,667 per annum
Business Analyst – £35,543 per annum
Technical Support Analyst – £22,753 per annum

Other Benefits

Written and designed by the industry’s finest expert instructors with over 15 years of experience
Repeat and rewind all your lectures and enjoy a personalised learning experience
Gain access to quality video tutorials
Unlimited 12 months access from anywhere, anytime
Excellent Tutor Support Service (Monday to Friday)
Save time and money on travel
Learn at your convenience and leisure
Quizzes, tests mock exams, practice exams to ensure you are 100% ready
Eligible for a NUS discount card
Free Career Support Service
25% Discount on personal Statement and covering letter writing service
Free Access to Over 150 courses for 2 days (48 hours)
Free access to course before you purchase (For selected courses only)

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

Course Curriculum Total Units : 151

➤ Module 01 - Relational Databases
1.0 Topic A: Database Normalization
	1.1 Normalization
	1.2 Steps to Normalize
	1.3 Demo – A-1: Using the Table Analyzer
	1.4 Demo – A-2: Identifying Object Dependencies
2.0 Topic B: Relating Tables
	2.1 Establishing Relationships
	2.2 Relationships Window
	2.3 Demo – B-1: Establishing a One-to-One Table Relationship
	2.4 One-to-Many Relationship
	2.5 Demo – B-2: Establishing a One-to-Many Table Relationship
	2.6 Junction Tables
	2.7 Many-to-Many with Junction
	2.8 Demo – B-3: Establishing a Many-to-Many Table Relationship
	2.9 Printing Table Relationships
	2.10 Demo – B-4: Printing Table Relationships
3.0 Topic C: Implementing Referential Integrity
	3.1 Referential Integrity
	3.2 Orphan Records
	3.3 Demo – C-1: Working with Orphan Records
	3.4 Cascading Deletes
	3.5 Demo – C-2: Setting Cascading Deletes
	3.6 Test Cascading Deletes
	3.7 Demo – C-3: Testing Cascading Deletes
	3.8 Cascading Updates
	3.9 Demo – C-4: Using Cascading Updates
	3.10 Unit 01 Review
➤ Module 02 - Working with Related Tables
1.0 Topic A: Lookup Fields
	1.1 Lookup Field
	1.2 Creating a Lookup Field
	1.3 Demo – A-1: Creating a Lookup Field
	1.4 Multivalued Fields
	1.5 A Multivalued Lookup Column
	1.6 Demo – A-2: Creating a Multivalued Lookup Field
2.0 Topic B: Modifying Lookup Fields
	2.1 Display Column Headings
	2.2 Demo – B-1: Modifying Lookup Field Properties
	2.3 Types of Controls
	2.4 Using a Value List Combo Box
	2.5 Demo – B-2: Changing a Text Box to a Combo Box
3.0 Topic C: Subdatasheets
	3.1 A Subdatasheet
	3.2 Inserting a Subdatasheet
	3.3 Demo – C-1: Using a Subdatasheet
	3.4 Unit 02 Review
➤ Module 03 - Complex Queries
1.0 Topic A: Joining Tables in Queries
	1.1 Joins
	1.2 Query Wizard
	1.3 Creating a Query
	1.4 Demo – A-1: Creating a Query Using the Simple Query Wizard
	1.5 Creating Joins in Design View
	1.6 Demo – A-2: Creating a Join in Design View
	1.7 Creating Outer Joins
	1.8 Demo – A-3: Creating an Outer Join
	1.9 Join by Using an Intermediate Table
	1.10 Demo – A-4: Creating a Join with an Intermediate Table
	1.11 Creating a Self-Join Query
	1.12 Demo – A-5: Creating a Self-Join Query
	1.13 Creating a Find Unmatched Query
	1.14 Demo – A-6: Finding Records that Do Not Match Between Tables
	1.15 Find Duplicates Query Wizard
	1.16 Demo – A-7: Finding Duplicate Records
	1.17 Demo – A-8: Deleting Tables from a Query
2.0 Topic B: Calculated Fields
	2.1 Calculated Fields Syntax
	2.2 Creating Calculated Fields
	2.3 Demo – B-1: Creating a Calculated Field
	2.4 Modifying Formats
	2.5 Demo – B-2: Modifying the Format of a Displayed Value
	2.6 Expression Builder Dialog Box
	2.7 Specifying Criteria
	2.8 Demo – B-3: Using the Expression Builder
3.0 Topic C: Summarizing and Grouping Values
	3.1 Using Summary Functions in Queries
	3.2 Concatenation
	3.3 Demo – C-1: Using Queries to Concatenate Values
	3.4 Unit 03 Review
➤ Module 4 - Advanced Form Design
1.0 Topic A: Adding Unbound Controls
	1.1 Unbound Controls
	1.2 Drawing a Rectangle
	1.3 Demo – A-1: Drawing a Rectangle Around a Control
	1.4 Change Tab Order
	1.5 Demo – A-2: Changing Tab Order
	1.6 Create a Grouped Control
	1.7 Demo – A-3: Grouping Controls
2.0 Topic B: Adding Graphics
	2.1 Add a Graphic to a Form
	2.2 Demo – B-1: Adding a Graphic to a Form
	2.3 Use Unbound Object Frame
	2.4 Demo – B-2: Embedding a Graphic in an Unbound Object Frame
3.0 Topic C: Adding Calculated Values
	3.1 Bind a Control to a Calculated Field
	3.2 Demo – C-1: Binding a Control to a Calculated Field
	3.3 Create a Calculated Control
	3.4 Align Controls in a Form
	3.5 Demo – C-2: Creating a Calculated Control
4.0 Topic D: Adding Combo Boxes
	4.1 Add a Combo Box to a Form
	4.2 Demo – D-1: Adding a Combo Box to a Form
	4.3 Modify Combo Box Properties
5.0 Topic E: Creating Advanced Form Types
	5.1 Create a Multiple Item Form
	5.2 Demo – E-1: Creating a Multiple Item Form
	5.3 Split Form
	5.4 Demo – E-2: Creating a Datasheet Form
	5.5 Datasheet Form
	5.6 A Form and Subform
	5.7 Demo – E-3: Creating a Subform
	5.8 Unit 04 Review
➤ Module 5 - Reports and Printing
1.0 Topic A: Customized Headers and Footers
	1.1 Report Header
	1.2 Add a Report Header
	1.3 Demo – A-1: Adding a Report Header
	1.4 Report Footer
	1.5 Demo – A-2: Adding a Report Footer
	1.6 Conditional Formatting Dialog Box
	1.7 Demo – A-3: Applying Conditional Formatting
	1.8 Set the Keep Together Property
	1.9 Demo – A-4: Keeping Parts of a Report on the Same Page
	1.10 Group, Sort, and Total Pane
	1.11 Demo – A-5: Adding Controls to Group Folders
	1.12 Force a New Page
	1.13 Demo – A-6: Forcing a New Page
2.0 Topic B: Adding Calculated Values
	2.1 The DateDiff Function
	2.2 Using the DateDiff Function
	2.3 Demo – B-1: Working with the DateDiff Function
	2.4 The IIf Function
	2.5 Demo – B-2: Using the IIf Function
3.0 Topic C: Printing
	3.1 Printing a Database Object
	3.2 Printing with the Database Documenter
	3.3 Demo – C-1: Printing a Database Document
4.0 Topic D: Labels
	4.1 Using the Label Wizard
	4.2 Labels in Print Preview
	4.3 Demo – D-1: Creating Labels
	4.4 Unit 05 Review
➤ Module 6 - Charts
1.0 Topic A: Charts in Forms
	1.1 Charts in Forms
	1.2 Chart Types
	1.3 Demo – A-1: Creating a Chart in a Form
	1.4 Titling the X and Y Axes
	1.5 Demo – A-2: Modifying a Chart in a Form
2.0 Topic B: Charts in Reports
	2.1 Charts in Reports
	2.2 Demo – B-1: Adding a Chart to a Report
	2.3 Format a Chart Item
	2.4 Chart Type Dialog Box
	2.5 Demo – B-2: Modifying a Chart in a Report
	2.6 Unit 06 Review
➤ Module 7 - PivotTables and PivotCharts
1.0 Topic A: PivotTables
	1.1 PivotTable View
	1.2 Drop Areas
	1.3 Demo – A-1: Examining the PivotTable View
	1.4 Add Fields to a PivotTable
	1.5 Demo – A-2: Adding Fields to a PivotTable
2.0 Topic B: Modifying PivotTables
	2.1 Summarize Data
	2.2 Demo – B-1: Creating Totals
	2.3 Move Fields in a PivotTable
	2.4 Demo – B-2: Moving Fields in a PivotTable
	2.5 Show and Hide Details
	2.6 Demo – B-3: Showing and Hiding Details in a PivotTable
	2.7 Change Field Settings
	2.8 Demo – B-4: Formatting Fields
3.0 Topic C: PivotCharts
	3.1 PivotChart Field Mapping
	3.2 Sample PivotChart
	3.3 Demo – C-1: Creating a PivotChart
4.0 Topic D: PivotTable Forms
	4.1 Create a PivotTable Form
	4.2 Demo – D-1: Creating a PivotTable Form
	4.3 Unit 07 Review
	4.4 Course Closure