Microsoft Office 2007 Access Intermediate

5( 1 REVIEWS )
532 STUDENTS

Description:

This Microsoft Office 2007 Access Intermediate is designed to build on your existing skills. This intermediate series follows the Microsoft Access 2007 Basic series. You will learn more sophisticated concepts of working with Microsoft Access 2007 such as controlling data entry, joining tables, working with PivotTables and PivotCharts, create and manage a database, create queries, create reports, build tables, create forms, and much more.

Before getting this course you must have a basic knowledge of Access and be able to create simple queries, forms and reports. This course will give an advanced knowledge you need to know about Microsoft Access. So, you can have this course if you have an understanding of Microsoft Access 2007. As a Microsoft office tools, Access is a very useful software and can be beneficial for anyone in their future.

Who is this Course for?

Microsoft Office 2007 Access Intermediate is perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Entry Requirement:

  • This course is available to all learners, of all academic backgrounds.
  • Learners should be aged 16 or over to undertake the qualification.
  • Good understanding of English language, numeracy and ICT are required to attend this course.

Assessment:

This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Course Curriculum

Relational Databases
Database Normalization 00:04:00
Using the Table Analyzer 00:05:00
Identifying Object Dependencies 00:01:00
Relating Tables 00:05:00
Establishing a One-to-One Table Relationship 00:03:00
Establishing a One-to-Many Table Relationship 00:02:00
Establishing a Many-to-Many Table Relationship 00:02:00
Printing Table Relationships 00:01:00
Implementing Referential Integrity 00:02:00
Working with Orphan Records 00:02:00
Setting Cascading Deletes 00:01:00
Testing Cascading Deletes 00:01:00
Using Cascading Updates 00:02:00
Working with Related Tables
Lookup Fields 00:02:00
Creating a Lookup Field 00:06:00
Creating a Multivalued Lookup Field 00:03:00
Modifying Lookup Fields 00:01:00
Modifying Lookup Field Properties 00:02:00
Changing a Text Box to a Combo Box 00:02:00
Subdatasheets 00:01:00
Using a Subdatasheet 00:02:00
Complex Queries
Joining Tables in Queries 00:04:00
Creating a Query Using the Simple Query Wizard 00:02:00
Creating a Join in Design View.mp4 00:03:00
Creating an Outer Join 00:02:00
Creating a Join with an Intermediate Table 00:02:00
Creating a Self-Join Query 00:01:00
Finding Records that Do Not Match Between Tables 23:49:00
Finding Duplicate Records 00:01:00
Deleting Tables from a Query 00:02:00
Calculated Fields 00:03:00
Creating a Calculated Field 00:02:00
Modifying the Format of a Displayed Value 00:01:00
Using the Expression Builder 00:01:00
Summarizing and Grouping [email protected] 00:01:00
Using Queries to Concatenate Values 00:02:00
Advanced Form Design
Adding Unbound Controls 00:01:00
Drawing a Rectangle Around a Control 00:01:00
Changing Tab Order 00:01:00
Grouping Controls 00:01:00
Adding Graphics 00:01:00
Adding a Graphic to a Form 00:02:00
Embedding a Graphic in an Unbound Object Frame 00:02:00
Adding Calculated Values 00:01:00
Binding a Control to a Calculated Field 00:02:00
Creating a Calculated Control 00:03:00
Adding Combo Boxes 00:01:00
Adding a Combo Box to a Form 00:02:00
Creating Advanced Form Types 00:02:00
Creating a Multiple Item Form 00:02:00
Creating a Datasheet Form 00:02:00
Creating a Subform 00:03:00
Reports and Printing
Customized Headers and Footers 00:04:00
Adding a Report Header 00:03:00
Adding a Report Footer 00:02:00
Applying Conditional Formatting 00:01:00
Keeping Parts of a Report on the Same Page 00:01:00
Adding Controls to Group Folders 00:03:00
Forcing a New Page 00:01:00
Adding Calculated Values 00:02:00
Working with the DateDiff Function 00:04:00
Using the IIf Function 00:02:00
[email protected] 00:01:00
Printing a Database Document 00:02:00
Labels 00:02:00
Creating Labels 00:02:00
Charts
Charts in Forms 00:01:00
Creating a Chart in a Form 00:04:00
Modifying a Chart in a Form 00:01:00
Charts in Reports 00:01:00
Adding a Chart to a Report 00:03:00
Modifying a Chart in a Report 00:02:00
PivotTables and PivotCharts
PivotTables 00:03:00
Examining the PivotTable View 00:02:00
Adding Fields to a PivotTable 00:04:00
Modifying PivotTables 00:01:00
Creating Totals 00:01:00
Moving Fields in a PivotTable 00:01:00
Showing and Hiding Details in a PivotTable 00:01:00
Formatting Fields 00:01:00
PivotCharts 00:01:00
Creating a PivotChart 00:03:00
PivotTable Forms 00:01:00
Creating a PivotTable Form 00:01:00
Assessment
Course Certification
Order your Certificate 00:00:00

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Overall Course Review

    5

    It is an interesting course as it contains advanced components and it i interesting.

TAKE THIS COURSE

Instructors

532 STUDENTS ENROLLED

© Course Gate Edukite Ltd, Reg no: 11378092