Access 2007: Essentials

Overview:

Are you an IT professional? Maybe you’re hoping to become an IT professional? Perhaps you’d like to design database systems? This Microsoft Access 2007: Essentials course will get you up to speed with the interface and all the various functions of Microsoft Access 2007, which will be an integral part of any IT career. This excellent Microsoft Access 2007 Advanced training course will cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. In addition, you’ll be guided through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.

Learning with 1Training.org has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What skills will I learn?

• Learn how to build new data entry forms and reports at the click of a button with the help of new Quick Create commands in Access 2007. You can then use these forms and reports as is, or modify them to your liking
• Try out the new built-in Date Picker control which can be used for any date fields. Explore how to enter a date into a field on datasheets, forms, or reports – no coding required
• Discover how to save valuable development time with the new Layout view in Access 2007. This cool new feature allows you to design your forms and reports while viewing live data. You can quickly resize, move, and align your controls without having to constantly switch between views
• Let Jeff show you how to use the new Report view, to dynamically filter the data and drill down to print only the information you need. The traditional Print Preview view is a static snapshot of your data that you view or print
• Find out how to make your data pop on screen with a Greenbar Effect by using the new Alternating Background Colour button. Your data has never been easier to read on screen or in printed form

Meet the instructor:

Jeff Conrad is a technology enthusiast with many years of database application development expertise. Jeff began working with Microsoft Access when he saw a need at his full time position for a database solution. He bought a book on Access and began teaching himself how to use the program to solve his business’s needs. He immediately became hooked on the power and ease of working with Access.

Jeff has been an active participant in the Access newsgroups for many years where he is best known as the Access Junkie. He enjoys giving back to a community that helped him when first learning how to use Access. Jeff maintains a Web site with a wealth of information and resource links for those needing guidance with Access. Jeff also owns his own company, Conrad Systems Development, creating custom database and spreadsheet applications for the food service industry.

Jeff was awarded Microsoft’s Most Valuable Professional award from 2005 to 2007 for his continual involvement with the online Access community. He is co-author of Microsoft Office Access 2007 Inside Out and is a contributing author of Microsoft Office 2007 Inside Out. Because Jeff knows Access “Inside Out”, he recently joined Microsoft as a Software Design Engineer in Test working with Access and Excel technologies. To learn more, visit his website at www.AccessJunkie.com.

 Course outline:

• Module 1: Relationships & Referential Integrity
• Module 2: Introducing Access
• Module 3: Exploring the New User Interface
• Module 4: Working in the Navigation Pane
• Module 5: Creating Tables
• Module 6: Creating Queries
• Module 7: Creating Forms
• Module 8: Creating Reports
• Module 9: Creating Macros

What are the requirements?

• You must be 16 or over
• You should have a basic understanding of English, Maths and ICT
• You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

• You will have one assignment. Pass mark is 65%.
• You will only need to pay £19 for assessment.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Those who successfully pass this course will be awarded a Access 2007 – Essentials certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

Career Path:

This excellent Access 2007 – Advanced course will qualify you to be a Software Engineer. The average salary of a Software Engineer in the UK is £34,285, and this will go up with experience (payscale.com). With this course you could enter any of the following industries:

• Software Engineer
• Technical Support
• Technical Sales
• Business Analyst
• Web Developer
• Software Tester