Microsoft Access 2016 - Intermediate (Paperback)

Ez-Ref Courseware

ISBN 10: 1544689330 / ISBN 13: 9781544689333

Published by Createspace Independent Publishing Platform, 2015

About this Item

Paperback. Note: This is the black & white version of the instructor guide designed for instructor-led classroom training and is meant to be used with our companion student training manuals for Microsoft Access 2016: Intermediate. For the black and white instructor guide, search for ISBN-13: 978-1544689333 For the color instructor guide, search for ISBN-13: 978-1544711706 For the color student manual, search for ISBN-13: 978-1544689234 For the black and white student manual, search for ISBN-13: 978-1544689111 To download the exercise files that accompany this title, please For information regarding unlimited printing with the ability to customize our courseware, please visit our website: Topics Covered for Microsoft Access 2016 - Intermediate (6-8 hours): Importing SpreadsheetsPublishing a Database ObjectCreating a Primary KeyConverting Field TypesChanging Field SizesCustom Display FormatsInput MasksUsing the Lookup WizardAssigning CaptionsSetting Default valuesUsing the Expression BuilderCreating Validity Rules & TextCreating QueriesSaving/Opening QueriesUsing WildcardsCompound QueriesCreating calculated ControlsUsing Summary OperatorsQuerying Multiple TablesAction QueriesCreating Permanent RelationshipsEnforcing Referential IntegrityCreating Custom ReportsSaving/Opening ReportsCreating Custom FormsSaving/Opening/Printing FormsDatabase Properties Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Seller Inventory # 9781544689333

Bibliographic Details

• Title: Microsoft Access 2016 - Intermediate (Paperback)
• Publisher: Createspace Independent Publishing Platform
• Publication Date: 2015
• Language: English
• ISBN 10: 1544689330
• ISBN 13: 9781544689333
• Binding: Paperback
• Condition: new

About this title

Synopsis

Note: This is the black & white version of the instructor guide designed for instructor-led classroom training and is meant to be used with our companion student training manuals for Microsoft Access 2016: Intermediate.

For the black and white instructor guide, search for ISBN-13: 978-1544689333
For the color instructor guide, search for ISBN-13: 978-1544711706
For the color student manual, search for ISBN-13: 978-1544689234
For the black and white student manual, search for ISBN-13: 978-1544689111

To download the exercise files that accompany this title, please visit http://www.ezref.com/exercise-files/

For information regarding unlimited printing with the ability to customize our courseware, please visit our website: www.ezref.com

Topics Covered for Microsoft Access 2016 - Intermediate (6-8 hours):

• Importing Spreadsheets
• Publishing a Database Object
• Creating a Primary Key
• Converting Field Types
• Changing Field Sizes
• Custom Display Formats
• Input Masks
• Using the Lookup Wizard
• Assigning Captions
• Setting Default values
• Using the Expression Builder
• Creating Validity Rules & Text
• Creating Queries
• Saving/Opening Queries
• Using Wildcards
• Compound Queries
• Creating calculated Controls
• Using Summary Operators
• Querying Multiple Tables
• Action Queries
• Creating Permanent Relationships
• Enforcing Referential Integrity
• Creating Custom Reports
• Saving/Opening Reports
• Creating Custom Forms
• Saving/Opening/Printing Forms
• Database Properties

About the Author

EZ-REF Courseware was started by two instructors back in 1993 and was the first company to offer editable courseware that could be customized by clients. Over the past two decades, EZ-REF has written hundreds of titles that have been sold worldwide to clients ranging from government agencies to universities and school districts to corporations to independent contractors.

For information regarding unlimited printing with the ability to customize our courseware, please visit our website: http: //www.ezref.com

• Designed by Instructors for Instructors
• One Time Licensing Fee (No Yearly Renewals)
• Unlimited Copies
• Not Controlled by a Scripted Schedule
• EZ to Customize - Just Cut & Paste
• Skill Levels Surveys, Exercise Files and EZ-Reference Cards
• Add Your Own Company Logo
• Everything Needed to Train Today!