Important Information: Texas SB 11 (Campus Concealed Carry) does not go into effect for community colleges until August 1, 2017.

Sign In
Access 2007: Advanced

This course is designed for individuals interested in learning the skills necessary to structure existing data, write advanced queries, work with macros, make effective use of forms and reports, and perform database maintenance.


​Description Upon successful completion of this course, individuals will be able to:
  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Write advanced queries to analyze and summarize data.
  • Create and revise Microsoft Office Access 2007 macros.
  • Display data more effectively in a form.
  • Customize reports by using various Microsoft Office Access 2007 features, making them more effective.
  • Maintain your database using tools provided by Microsoft Office Access 2007.
​Prerequisites To ensure success, we recommend you first take the following courses or have equivalent knowledge of:
  • Microsoft Windows 2000 (or above)
  • Microsoft Office Access 2007 - Beginning
  • Microsoft Office Access 2007 - Intermediate
​Pre-Work Required None
​Suggested Class Size

Minimum 3
Maximum 12


​Course Length ​8 hours

©2015 Brazosport College | 500 College Drive| Lake Jackson, TX 77566 | (979) 230-3000

Webmail | ASTRA | BC Alert | F.A.S. | Institutional Profile | Equal Opportunity | Login

A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459;