MS Access 2007 Level 2

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Course Outline

You have worked with the various Access objects, such as tables, queries, forms, and reports.
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. 

Course Outline Lesson 1: Structuring Existing Data
Topic 1A: Analyze Tables
Topic 1B: Create a Junction Table
Topic 1C: Improve Table Structure

Lesson 2: Writing Advanced Queries
Topic 2A: Create Subqueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms
Topic 4A: Display a Calendar on a Form
Topic 4B: Organize Information with Tab Pages
Topic 4C: Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective
Topic 5A: Include a Chart in a Report
Topic 5B: Print Data in Columns
Topic 5C: Cancel Printing of a Blank Report
Topic 5D: Create a Report Snapshot

Lesson 6: Maintaining an Access Database
Topic 6A: Link Tables to External Data Sources
Topic 6B: Manage a Database
Topic 6C: Determine Object Dependency
Topic 6D: Document a Database
Topic 6E: Analyze the Performance of a Database

Additional Details

Pre-Requisites

Access 2007 Level 1 or equivalent knowledge. Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.

Certificates offered

Certificate of completion

Cancellation Policy

Students are required to give notice if they are unable to attend their class:

2 weeks (10 full business days) or longer prior to training date = full refund
1 to 2 weeks (5 - 9 full business days) prior to training date = 50% of course fee refund
Less than 1 week (4 full business days or fewer) prior to training date = 0% refund

NOTE: You may substitute classes or students at any time.

Map & Reviews

New Era Technology Training
[ View Provider's Profile ]

New Era Technology Centre
#300, 633 - 6th Ave S.W., Ford Tower
Calgary, Alberta
Canada   T2P 2Y5

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

It was hard to see the instructors screen. It was a projector that was turned toward a white board.

Reviewed by Arlene R. 2012

   

Jason Hall is fantastic and I look forward to taking another course with him. My last experience at New Era was not great; the instructor did not meet our expectations and the computers were not working when we arrived. But Jason made the day fly by and I felt like I learned not only the set curriculum but gained lots of additional presentation skills.

Reviewed by Maya D. 2012

   

The instructor in this class was EXCELLENT. I would highly recommend her as she really knew what she was doing and her etaching style was great. AWESOME instuctor.

Reviewed by Pamela T. 2012

   

The trainer was very knowledgeable and kept the course moving at a great pace. I wish I could take her home with me, so she could help me teach photoshop at the school I work at.

Reviewed by Michelle . 2012

   

The course was very helpful and the instructor was very knowledgable and made the effort to make sure all class members were understanding the excersizes and were on the same page. My only complaint is that the computers seemed a little worn out. Throughout the day most students in the class ran into some sort of issue with the computer not working the way it should. And during our practice time closer to the end of the day all the computers started crashing.

Reviewed by Lori F. 2012

   

The Instructor was fabulous and is the reason that I truly enjoyed the course.

Reviewed by Michelle F. 2011

   

Alex was extrememly helpful and knowlegeable.

Reviewed by Dawn G. 2011

   

The course was excellent, but I felt a little out of my league. The participants in the course were designers and IT people who had used other versions of SharePoint. While I benefited from their questions and comments during the class, I feel "lost" now that I'm back on my own at the office. Perhaps I was in the wrong coarse, but it did say power "user".

Reviewed by Sharon T. 2011

   

Alex is great!

Reviewed by ellen m. 2011

   

Jane is a wonderful teacher! i will gladly take any class she teaches!

Reviewed by Essante P. 2011

   

Jane is an excellent teacher! She is very knowledgable and is enthusiastic about the course!

Reviewed by Essante P. 2011

   

Very good - presented course material in an engaging way.

Reviewed by Claudine T. 2011

   

The instructor didn't provide a lot of structure to the class, he just skimmed through the material and didn't go into it very deep. As a result, the class finished up 1.5 h early as well. He tried to add material from PMI (which was missing from the course materials) but this sometimes just made things more confusing. The PMI material should really be in the course material to start with. Otherwise, the instructor was helpful, knowledgeable and had a good demeanor.

Reviewed by Laverne R. 2011

   

It was informative

Reviewed by Amanda N. 2011

   

Very good course with a very knowledgeable instructor. Class was at full occupancy and I felt that the class size was too large.

Reviewed by Amanda B. 2011

   

There were only 4 students so it went fast and we finished early. Personally I would have liked to spend more time practicing. Perhaps some reference to the book and if there were any practice exercises in there that we could use to gain more experience with Visio.

Reviewed by Denise T. 2011

   

The course started 40 minutes late because they did not have the correct computers set up for the program. It's like they were not even expecting us. I found it very disorganized. For the price I paid for this course, I expected a more professional presentation.

Reviewed by Karyn J. 2011

   

Instructor was very soft spoken did not have all the answres but did get answers later in the class.

Reviewed by Thomas H. 2011