Course Code: GES831
Receive an introduction to tables. Learn how to design tables, add fields, change layouts, and edit form properties.
Learn how to design queries, use criteria and parameters, use design view, and save works in progress.
Cover one-to-many relationships, create a combo box, and use forms and subforms to represent one-to-many relationships.
Understand how to create the search form, link to forms and subforms, manage the database environment, create a switchboard form, test your software, and use a query to calculate the total.
Receive instruction regarding normalizing databases, how to process key data in tables, and how to evaluate primary keys and relationships.
Complete the course by learning how to design and link two forms. You’ll also understand how to design a report, design a subreport, work with dates, visualize and export data results. Finally, you’ll learn how to use action queries and optimize Access for multiple users.
Elizabeth Ann Nofs is the designer and developer of the Computer Mama series. She is the author of 44 books, including the Computer Mama Guide to Computers, the Comma Method of Computer Training, the Comma Teachers Edition, and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training. She received her Bachelor of Arts in Biology from the University of Michigan, Ann Arbor.
Before you enroll in the Microsoft Access 2010 Certification Training course, you should have strong computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up your files. You should also be proficient in Microsoft Excel. This course is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This course will also suit you if you want to learn about this software and expand your job possibilities.
Other: Email capabilities and access to a personal email account.
The instructional materials required for this course are included in enrollment.
The following textbooks are available to download throughout the lessons:
Microsoft is a global leader in software development and technology solutions. Microsoft programs such as Excel, Word, Outlook, and PowerPoint are used both at home and at work. Microsoft provides certifications in these programs that range from beginner to expert level, helping professionals realize their full potential. Whether you want to learn a single program or the entire Office Suite, completing a Microsoft-certified course is the first step.
Yes, ed2go courses are online, so you never have to actually travel to the school. Most schools offer telephone or online registration.
This course is open enrollment, so you can register and start the course as soon as you are ready. Access to your course can take 24-48 business hours.
This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive six (6) months to complete the course.
The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee may be charged.
You may be assigned with an instructor or team of industry experts for one-on-one course interaction. Your support will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our instructors are successful working professionals in the fields in which they teach. You will be assigned to an Advisor for academic support.
Upon successful completion of the course, you will be awarded a Certificate of Completion.
This course will provide you with the skills you need to obtain an entry-level position in most cases. Potential students should always do research on the job market in their area before registering.
ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA and Pell Grant. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements. Financing is available from select schools. Learn more: https://www.ed2go.com/career/financial-assistance
If you have questions that are not answered on our website, please feel free to contact us via LIVE CHAT or by calling us at (855) 520-6806. If you are visiting us during non-business hours, please feel free to send us a question using the Contact Us form.
This course teaches the exam objectives for Exam 77-885: MOS: Microsoft Office Access 2010. However, this is an elective exam and is not required for the MOS Certification.