Mastering Access Made Easy DVD-ROM Self-Study Training CourseProduct Name: Mastering Access Made EasyManufacturer: TeachUcomp, Inc.Versions Covered:2013, 2010 & 2007Course Length:6 HoursVideo Lessons:111Instruction Manuals: 3 (PDF)Learn Microsoft Access 2013 with this comprehensive course from TeachUcomp, Inc.Mastering Access Made Easy features 111 video lessons with over 6 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more. Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply insert the DVD-ROM into your computer to launch the easy-to-use interface, click to launch a video lesson or open one of the manuals and you're on your way to mastering Access. This course also includes bonus lessons for versions prior to 2013, making an upgrade from earlier versions a breeze.Getting Acquainted with Access1. Creating a New Database - 20132. Creating a New Database - 2010:20073. Overview of a Database4. The Access Interface5. Touch Mode6. Viewing Database Objects in the Navigation Bar7. Opening and Closing Databases - 20138. Opening and Closing Databases - 2010:2007Creating Relational Database Tables1. The "Flat File" Method of Data Storage2. The Relational Model of Data Storage3. Tips for Creating a Relational Database4. Creating Relational Database Tables5. Assigning a Primary Key to a TableUsing Tables1. Using Datasheet View2. Navigating in Datasheet View3. Adding Records in Database View4. Editing and Deleting Records in Datasheet View5. Inserting New Fields6. Renaming Fields7. Deleting FieldsField Properties1. Setting Field Properties2. The 'Field Size' Property3. The 'Format' Property for Date/Time Fields4. The 'Format' Property for Logical Fields5. Setting Default Values for Fields6. Setting Input Masks7. Setting Up Validation Rules and Responses8. Requiring Field Input9. Allowing Zero Length EntriesJoining Tables in a Database1. The Relationships Window2. Enforcing Referential Integrity3. Creating Lookup FieldsIndexing Tables1. Indexes2. Creating Indexes3. Deleting IndexesQueries1. Using the Simple Query Wizard2. Designing Queries3. Joining Tables in a Query4. Adding Criteria to the QBE Grid5. Running A Query6. How is Using the QBE Grid Writing SQL Code?7. Sorting Query Results8. Hiding Fields in a Query9. Using Comparison Operators10. Using 'AND' and 'OR' ConditionsAdvanced Queries1. Using the 'BETWEEN...AND' Condition2. Using Wildcard Characters in Criteria3. Creating a Calculated Field4. Creating 'Top Value' Queries5. Function Queries6. Parameter QueriesAdvanced Query Types1. Make-Table Queries2. Update Queries3. Append Queries4. Delete Queries5. Crosstab Queries6. The 'Find Duplicates' Query7. The 'Find Unmatched' QueryCreating Forms1. Forms Overview2. The Form Wizard3. Creating AutoForms4. Using Forms5. Form and Report Layout View6. Form and Report Design View7. Viewing the Ruler and Gridlines8. The 'Snap to Grid' Feature9. Creating a Form in Design ViewForm & Report Controls1. Selecting Controls2. Deleting Controls3. Moving and Resizing Controls4. Sizing Controls 'To Fit'5. 'Nudging' Controls6. Aligning, Spacing and Sizing Controls7. Formatting Controls8. Viewing Control PropertiesUsing Controls1. The Controls Group2. Adding Label Controls3. Adding Logos and Image Controls4. Adding Line and Rectangle Controls5. Adding Combo Box Controls6. Adding List Box Controls7. Setting Tab OrderSubforms1. Creating Subforms2. Using the Subform/Subreport ControlReports1. Using the Report Wizard2. Using Basic Reports3. Creating a Report in Design View4. Sorting and Grouping Data in Reports5. Creating Calculated FieldsSubreports1. Creating SubreportsCharting Data1. Using ChartsMacros in Access 20071. Creating and Using Macros2. Macro Actions3. Assigning Macros to a Command Button4. Conditional Macros and Option Groups5. Using Group Names in Macros6. Creating Autoexec MacrosMacros in Access 2013:20101. Creating a Standalone Macro2. Assigning Macros to a Command Button3. Using Program Flow with Macros4. Creating Autoexec Macros5. Creating Data MacrosSwitchboard and Navigation Forms1. Creating a Switchboard Form2. Creating a Navigation Form - 2013:20103. Controlling Startup Behavior - 20074. Controlling Startup Behavior - 2013:2010Advanced Features1. Getting External Data2. Exporting Data3. Setting a Database Password - 20074. Setting a Database Password - 2013:20105. Using Help1 GHz Intel Pentium Processor or equivalentWindows 8, 7, Vista, XP, Mac OS X 10.1 or later1 GB RAM256 color SVGA capable of 1024x768 resolutionSpeakers or headphonesDVD-ROM DriveWhich methods of payment do you accept?PayPal (preferred) or VISA/MC/AMEX/DISC. Payment is due within 3 days following the product (72 hours). After 4 days, we file an eCRATER non-paying buyder alert.Where do you ship?We ship all over the world. Please check the shipping options for each item for specifics. We ship Monday-Friday (except Holidays). Orders placed by 2 pm Eastern ship the same day. Where do you charge sales tax?Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax usyour tax exempt license at 517-333-2958.What is your Privacy Policy?We value your right to privacy. When you order products from TeachUcomp, Inc., your personal information is kept in strict confidence. We do not rent, sell or provide your personal data to any other entity unless required by law.I have more questions. How can I contact you?Please use the eCRATER message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day. We're always happy to answer questions. We want to make your buying experience as pleasurable as possible.©TeachUcomp, Inc. All Rights Reserved.inkfrog terapeaki000000