Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 5

MS Office Access 2007 Level 1 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities.

Course Outline
Microsoft® Office Access 2007 – Level 1 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.

Students who complete this course can be on their way to preparing for a Microsoft Certified Application Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.

Course Outline

After completing this course, you will be able to:

  • identify parts of the Access screen
  • define fields, data types and tables
  • create a database using templates, create a blank database, open, save and close databases
  • create a table using Datasheet View or Design View
  • insert, delete and modify data in a table
  • add, modify and remove primary key fields
  • insert, modify and delete a field
  • add a total row to a table
  • format, rename and delete tables
  • save database items in a variety of file formats
  • import or export data from or to other applications
  • find and replace data using exact or partial matches, case sensitive and wildcard searches
  • sort and filter data
  • create, save, close, or run a query using the wizard or in Design View
  • create query criteria using comparison, wildcard, AND, OR operators, or calculated field
  • change queries field properties and apply aliases
Course Outline Lesson 1: Introducing Access
  • Lesson Objectives
  • Overview
  • Looking at the Screen
  • Planning a Database
  • Creating a Database Using a Template
  • Moving Around a Database
  • Creating a Blank Database
  • Organizing Files
  • Lesson Summary
  • Review Questions
Lesson 2: Creating and Modifying Tables
  • Lesson Objectives
  • Creating Tables using Datasheet View
  • Moving Around a Table
  • Inserting, Deleting and Modifying Data in a Table
  • Creating Tables using Table Templates
  • Creating Tables Based on Existing Tables
  • Creating a Table in Design View
  • Modifying Data Types
  • Modifying Field Properties
  • Adding and Removing Primary Keys
  • Adding and Removing Multiple Primary KeysLesson Summary
Lesson 3: Manipulating a Table
  • Lesson Objectives
  • Restructuring Tables
  • Formatting Tables
  • Modifying Tables
  • Printing and Distributing Tables
  • Lesson Summary
  • Review Questions
Lesson 4: Data Manipulations
  • Lesson Objectives
  • Inserting and Deleting Records
  • Importing and Exporting Data
  • Finding and Replacing Data
  • Lesson Summary
  • Review Questions
Lesson 5: Sorting and Filtering
  • Lesson Objectives
  • Sorting Records
  • Filtering Records
  • Lesson Summary
  • Review Questions
Lesson 6: Select Queries
  • Lesson Objectives
  • What is a Query?
  • Creating a Query using the Wizard
  • Creating a Query in Design View
  • Saving, Closing and Running Queries
  • Adjusting Queries
  • Sorting Fields
  • Showing and Hiding Fields
  • Applying CriteriaUsing Wildcard Characters
  • Functions and Calculated Fields
  • Changing Field Properties
  • Working with Aliases
  • Filtering Query Data
  • Lesson Summary
  • Review Questions
  • Lesson 7: Relating Multiple Tables
  • Lesson Objectives
  • Establishing Table Relationships
  • Enforced Referential Integrity
  • Print Relationships
  • Using the Table Analyzer
  • Lesson Summary
  • Review Questions
Lesson 8: Maintaining Databases
  • Lesson Objectives
  • Database Maintenance
  • Opening Databases
  • Modify Database Options
  • Modifying Database Properties
  • Using the Database Documenter
  • Saving a Database to a Previous Version
  • Saving a Database with a Password
  • Splitting Databases
  • Lesson Summary
  • Review Questions
***Guaranteed to RUN! ***
Prerequisites & Certificates

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent Microsoft Windows knowledge and experience. Students who wish to become proficient using the features of Microsoft Office Access 2007 will benefit from taking this course.

Certificates offered

Certificate of participation and course manual.

Cancellation Policy
Unless stated otherwise on your confirmation all sales are final, cancellations more than 72 hours in advance will receive a credit to be used towards a future training class. Cancellations within 72 hours result in a loss of registration fee.

Map & Reviews
Last Minute Training
[ View Provider's Profile ]


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.
this was TPN 3 as scheduling for TPN 2 was not working with my schedule. I will be taking TPN 2 (Pam Russell is unable to attend) in August or September.
Reviewed by 2017
Could have used some more breaks. Other than that she was an excellent trainer and was very helpful on helping us with our Sharepoint developement. The trainer conducted the training in our office so that section should be N/A
Reviewed by 2016
Donna's knowledge on MS project is amazing! She was very very helpful.
Reviewed by 2016
The facility and start time were our fault (terrible, but I can't put that as it should not reflect on the vendor!) - incredibly, they offered to host us for the second course. The instructor (contract employee for GK) was hilarious, incredibly knowledgeable and quickly showed tips and tricks that were previously unknown to the students. It did not fit the original request, but was completely valuable. There were no handouts, but we didn't need them for what we were doing.
Reviewed by 2016
Training Provider has a great personality with a vast knowledge and experience and could be recommended to any business seeking ways of staff development.
Reviewed by 2016
This course was fabulous - and the instructor was both professional and interesting, she presented really well!
Reviewed by 2015
The trainer was fabulous. I quite enjoyed my time with her thank you so much!
Reviewed by 2015
Just wondering about accessibility for the building-is there an elevator?
Reviewed by 2015
Excellent course. Instructor able to tailor content to my requirements which made it more relevant. Good pace and content. Instructor had deep knowledge of the subject and provided me with several different tools to use in my job.
Reviewed by 2014
Enjoyed this class a lot - Jennifer was very approachable and gave excellent, practical examples that helped bring the lessons to life.
Reviewed by 2014
I am so suprised i was the only one student so there's a lot of opportunity to learn because the instructor is concentrated on you.
Reviewed by 2014
excellent Trainer - extremely knowledgeable.
Reviewed by 2014
My big issue was the location. Not a nice part of the Danforth. Also need hand soap in ladies washroom (was only dish soap).
Reviewed by 2014
The general course content were great and the Instrauctr Inam made understanding it easy
Reviewed by 2014
The course maybe could have more hands on training exercises. For example maybe watch a meeting in progress and have the participants take minutes of the video. As a group they would discuss that content would be included in the minutes.
Reviewed by 2014
It was just the instructor and I and that was awesome as we could be as specific as I wanted to me for my needs.
Reviewed by 2014
I found it extreamly helful. Thx
Reviewed by 2014
Facility marks are N/A (not applicable): Training was at our site, and that was VERY convinient.
Reviewed by 2014
Facility marks are not relevant since the training was done at the site of Taro Pharmaceuticals Inc.
Reviewed by 2014
Facility is clean but room is cold that is why I scored it low.
Reviewed by 2014
The course was perfect for my needs. I will definately make use of the information I learned. I appreciated the courteous and very helpful communications I had prior to the course as well.
Reviewed by 2013
Overall the course is useful however the course outline needs to be more structured in my opinion. The instructor should also be a little bit more knowledgeable in regards to specifics about MS Project as there is a very high level of experience with the software expected of them.
Reviewed by 2013
Keep it up !
Reviewed by 2012
It was GREAT ! Gordon is a good presenter with a lot of experience and knowledge.
Reviewed by 2012
We would have liked if the course covered Outlook as well as the other Office programs. In our first 2 online classes, there were problems with the audio and the teacher would sometimes cut out, or fast forward, and she could barely hear us at all so all quesitons had to be typed in the chat.
Reviewed by 2011

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 325 times.