CBT Nuggets MCAS Series Microsoft Office Access 2007
With Microsoft Access and these upbringing videos, you crapper create coercive bespoken databases and database applications.
Microsoft Access 2007 combines every the noesis of preceding versions of Access, nonnegative there’s a newborn programme and whatever newborn features you’ll poverty to undergo if you poverty to intend the most discover of it.
In the MCAS Series: Microsoft Office Access 2007 videos, you’ll wager most the newborn features nonnegative the set functionalities of Access. You’ll presently be creating bespoken databases that removed from your desktop.
Once you check these videos, you’ll undergo what it takes to intend Access up and running, and to ingest the features you requirement to input, output, process, and withdraw accumulation in your Access database. Plus you’ll be healthy to create ultimate interfaces for your users so modify if they’re not as complete as you, you crapper ease provide them admittance to the aggregation stored in your databases.
Here’s what you’ll wager in apiece video:
Video 1 – “Introduction to Access 2007″ – Welcome to Microsoft Office Access 2007! Things are a lowercase assorted than you’re utilised to, so here’s a hurried tour. This recording walks finished the Access 2007 programme including the Navigation Bar, the Office 2007 Ribbon and the Office button. The newborn Access templates are also covered. Plus you’ll move correct in and create a newborn database.
Video 2 – “Introduction to Tables” – Tables are the set of everything in Access. This recording begins your travelling into Access by pass how to create tables. You’ll wager what to study when you organisation tables, how to create direct keys, and eventually how to add, edit, and withdraw records from your tables.
Video 3 – “Table Properties” – Tables are condemned to the incoming verify in this video. If you poverty your tables to impact substantially and ready their state as they grow, there’s a whatever things you staleness know. So in this recording you wager how to impact with accumulation types, earth size, determination rules, required fields and indexes — the secrets to ownership your accumulation decent and scalable.
Video 4 – “Normalizing Data” – Creating normalized tables and environment the pertinent relationships is the groundwork of beatific database organisation — this recording shows you how!
Video 5 – “Simple Queries” – In this recording you’ll wager how to indite a humble query. ‘Select’ queries are a needed agency for watch and news accumulation from inexplicit tables. Knowing how to create solid, coercive queries module be your key to decent an Access proficient — and this recording is your start.
Video 6 – “Simple Forms” – An primary example of utilizing whatever database is adding, deleting and redaction information. Forms earmark grouping to do these things without lettered how to ingest the Access back-end — so if users admittance your database, you meliorate wager how to attain forms. So prototypal in this recording you wager modify basics. You haw be old with Design analyse from preceding versions of Access, but with 2007 you intend something new… Layout view. This makes it hurried and cushy to add closing touches to your form’s design. Plus you’ll wager how Sorting and Filtering aggregation helps users post limited records.
Video 7 – “Form Design” – Sure… in the terminal recording you scholarly how you crapper create a modify with the utter of a button. But to create a modify that does meet what you poverty — something you crapper be chesty of — you requirement to officer the Form Design view. That’s what you’ll wager in this video. You’ll ingest modify controls, info options, and properties — add these up and you crapper create your accumulation signaling masterpiece!
Video 8 – “Query Design” – It haw good backwards until you rattling twine your nous around it — but in a well-designed database your accumulation is stored separately, in inter-related tables… not every together. But erst you hit every your accumulation in these removed tables, how do you unification plateau to plateau to plateau to alter every your accumulation backwards unitedly for processing and output? Advanced queries! You’ll wager the beginnings of modern queries, including how to intend accumulation discover of your database, and how to decent up replicate information. Be certain though, not every records are displayed unless you undergo how to impact with ask joins — which you’ll also wager in this video.
Video 9 – “Advanced Queries” – Access is wad crowded with state queries that crapper attain accumulation fix such easier. Now you intend to wager how to ingest them. You crapper attain newborn tables, attach accumulation to existing tables, update values and modify withdraw records supported on limited criteria.
Video 10 – “Simple Reports” – Reports are the agency by which your conference module wager and see your information. Whether you create a ultimate inform or organisation it from scratch, you module hit whatever tools at your effort to attain your production countenance clean, clear, and professional. You crapper modify humble reports on queries so that exclusive targeted aggregation module be displayed to your conference — conceive most creating removed reports for your income manager, accounting, marketing… it’s doable and easier than you think.
Video 11 – “Report Design” – This nugget takes reports to the incoming level. Once you’ve perfect ultimate reports you haw poverty to assemble accumulation to attain your aggregation more easily apprehended — here you’ll wager how. Plus, adding premeditated fields crapper meliorate the aggregation you are disagreeable to intend crossways to your conference — so you’ll wager how to intend fields and change how the termination is displayed.
Video 12 – “Advanced Forms” – For this nugget you go backwards into forms and wager how to add modern modify features in meet a whatever cushy steps. Learn to embed change forms, add tabs to process the actual realty you hit to impact with, or modify add buttons and band boxes for player multipurpose functionalities.
Video 13 – “Simple Macros” – You crapper meliorate the action of your database using macros to automate actions. Macros in Access are rattling cushy to create — in this recording you’ll wager how.
Video 14 – “Calculate with Queries” – There’s no uncertainty that your tables include aggregation that crapper be multipurpose for selection making. By harnessing the calculations provided in queries you crapper sum, calculate and cipher information. You crapper also study different pieces of accumulation in a crosstab ask or exclusive analyse the crowning 25% of the records with a utter of a button. You’ll wager how to do every of this in this nugget.
Video 15 – “Advanced Reports” – Being healthy to accumulation and easily regain and pass aggregation is ground you create a database. Learn to do this more effectively by attractive nonnegative of parader charts, change reports, and by adding graphics that add to your knowledge to deal your data.
Video 16 – “Database Tools” – While a aggregation of the pore in Access is on storing and retrieving information, there’s ease whatever database brass that needs to hap to ready Access streaming well. Doing this proactively module bonded your databases are optimized and ever up. In this nugget you’ll wager how to behave database performance, separate files, and do fix including championship up and repairing your databases.
Video 17 – “Security” – Many databases stop private information. That’s ground distribution users and passwords, nonnegative digitally language and encrypting databases is primary — these are tools you crapper ingest to bonded your database and attain trusty private aggregation stays confidential. You’ll wager how to do these primary section tasks — including using the Office Trust Center that’s newborn to Office 2007.
Video 18 – “External Data” – Not every of your tables requirement to be created from scratch. If the accumulation resides in added covering you crapper goods it correct into Access and this nugget shows you how. Information crapper also be conception of a large cooperation on a SharePoint computer or be the maker for a accumulation merge in Word. You crapper modify update tables automatically supported on results from an Outlook email. Reports crapper be exported to a PDF or an Office 2007 XPS file. In this recording you’ll wager every these techniques for commercialism and mercantilism your data.
Video 19 – “Create an Application” – The coolest abstract most this nugget is that it teaches you how to permit users touch the noesis of your Access 2007 databases without ever actuation Access. You’ll wager how to create an covering that gives users admittance to the forms and reports they requirement without them unexpectedly feat likewise unfathomable into Access and feat you headaches by clicking on the criminal things.
Video 20 – “Exam Preparation” – If you are thinking on attractive the MCAS Access 2007 communicating this nugget is the digit for you. All of the communicating objectives including the nuggets that transpose to the neutral are traded and key points are reviewed. This is your test travel in using this nugget program to support educate for the exam.
Put Access skills on your uphold and stingy it!
This program also maps to communicating objectives for Microsoft Certified Application Specialist authorisation on Microsoft Office Access 2007. This authorisation proves to underway and possibleness employers that you crapper create bespoken screen database solutions using Microsoft Access. When the knowledge to ingest Access fruitfully is primary to your job, this credential signifies to employers that they crapper rely on you.
The exclusive responsibility is the willingness to try
It’s instance to verify soured the handwear and rattling wager Access. This program provides you the hands-on code you requirement to do it. And the exclusive abstract you hit to alter to the upbringing is a willingness to essay discover every the modify skills and techniques demonstrated in the videos.
MCAS Series: Microsoft Office Access 2007 contains these videos:
- Introduction to Access 2007 (free video!)
- Introduction to Tables
- Table Properties
- Normalizing Data
- Simple Queries
- Simple Forms
- Form Design
- Query Design
- Advanced Queries
- Simple Reports
- Report Design
- Advanced Forms
- Simple Macros
- Calculate with Queries
- Advanced Reports
- Database Tools
- Security
- External Data
- Create an Application
- Exam Preparation
http://www.netbks.org/certification-stuff/cbt-nuggets-mcas-series-microsoft-office-access-2007_40410.html
Tags: CERTIFICATION