Microsoft Access 2010: Basic

Access 2010

This instructor-led training course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, the course will cover subjects such as how to design and create databases. Topics include: tables, fields, and records; sort and filter data; and set field properties and data entry rules. In addition, the course covers how to create queries, forms, and reports.


Gary J. Hires
Computer Instructor

Gary began working with technology at an early age. The junior high school he attended in Haltom City, Texas received an
emerging technology grant which afforded a lab of 10 Commodore Pet computers - an opportunity for a student 13 years old to experience and engage in something out of a science fiction novel. Gary quickly became the accidental techie for the teachers on campus - a small yet pivotal beginning to a life-long path of assisting others in the use of new technology. Although pursuing a Bachelor's degree of Music Education from Texas Christian University in Ft. Worth, Gary still continued the journey of assisting others. From assisting professors with purchasing their first Apple computer to setting up his church's peer-to-peer network - Gary's passion and service to help others continued to be a driving force in his life. A position at Odessa High School brought Gary to wonderful West Texas. After 2 years of teaching, Gary was called into ministry as the Director of Education and Music at Memorial Christian Church where he continued to utilize his skills as an educator, but also as a technologist advocating the use of technology to help the church effectively communicate and forward all of the church's ministries through technology.  Gary was quick to network all of the computers at the church and then teach the staff as well as members how to effectively use the various applications.  During his employment with Memorial Christian Church, a member recognized his talents with technology and offered him a job working in the IT department of the County of Midland.  During his time working for the County of Midland, Gary was instrumental in creating and updating the website as well as implementing several upgrades to the website that made the various options more user friendly for the public.  In addition, he was involved the the continual networking and upgrading of the massive computer system.  He was also charged with formally training the employees how to use the various applications.  Gary currently works at Midland College in the Workforce Continuing Education department - a position which provides him many opportunities to share and educate a great number of people the many ways to leverage technology - for home, work and play.  Gary loves technology and loves sharing technology with others.  He is a true "Computer Geek"!

  • Unit 1: Getting started
    • Topic A: Database concepts
    • Topic B: Exploring the Access environment
    • Topic C: Getting help
  • Unit 2: Databases and tables
    • Topic A: Planning and designing databases
    • Topic B: Exploring tables
    • Topic C: Creating tables
  •  Unit 3: Fields and records
    • Topic A: Changing the design of a table
    • Topic B: Finding and editing records
    • Topic C: Organizing records
  •  Unit 4: Data entry rules
    • Topic A: Setting field properties
    • Topic B: Working with input masks
    • Topic C: Setting validation rules
  •  Unit 5: Basic queries
    • Topic A: Creating and using queries
    • Topic B: Modifying query results and queries
    • Topic C: Performing operations in queries
  •  Unit 6: Using forms
    • Topic A: Creating forms
    • Topic B: Using Design view
    • Topic C: Sorting and filtering records
  •  Unit 7: Working with reports
    • Topic A: Creating reports
    • Topic B: Modifying and printing reports
XA00141Q Sep 27 8:00 am - 5:00 pm
Sat  $149.00
($154.00 out-of-state)
Registered: 0 8.0 Hours

Course Canceled!

Midland College is accredited by the Commission on Colleges of the Southern Association of Colleges and Schools to award certificates
and associate and baccalaureate degrees. Contact the Commission on Colleges at 1866 Southern Lane, Decatur, Georgia 30033-4097
or call 404-679-4501 for questions about the status of Midland College.

Midland College is an Equal Opportunity Employer/Educator

mc logo  secure90x72