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.
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.
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.
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.
Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2007 Intermediate.
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.
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.
➤ 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 |