Introduction to Microsoft Access 2010
Introduction to Microsoft Access 2010
In this practical and project-oriented course, you will learn how to use this award-winning MS Office software to create and customize tables. You will build relationships between your tables to eliminate redundancies and slash data entry time.
In addition, you will find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You will learn how to retrieve exactly what you need from your database with powerful queries and reports, and you will even start automating routine tasks with labor-saving macros.
By the time you finish this course, you will know how to create an effective database for any information you need to store, document, and manage—at home or on the job.
Syllabus
- Lesson 1 – Getting to Know Access 2010
- Lesson 2 – Controlling Your Access Table Fields
- Lesson 3 – Creating Tables and Relationships
- Lesson 4 – Building Powerful Forms
- Lesson 5 – Adding Versatility to Forms
- Lesson 6 – Interviewing Your Database
- Lesson 7 – Taking Queries to the Next Level
- Lesson 8 – Multi-Table Query Control
- Lesson 9 – Reporting on Your Tables
- Lesson 10 – Creating Query-Based Reports
- Lesson 11 – Mastering Report Design
- Lesson 12 – Automating Your Database With Macros
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- Microsoft Access 2010 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
Email capabilities and access to a personal email account.
Prerequisites:
There are no prerequisites to take this course.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
<ul><li>6 Weeks Access</li>
<li>Course Code: ia0</li>
<li>Start Dates* Jan 12 | Feb 09 | Mar 16 | Apr 13</li>
<li>$187.00 USD</li></ul>
Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.