Buy New Perspectives Microsoft Office 365 & Access 2019 Comprehensive, 1st Edition PDF ebook by author Mark Shellman; Sasha Vodnik – published by Cengage Learning in 2020 and save up to 80% compared to the print version of this textbook. With PDF version of this textbook, not only save you money, you can also highlight, add text, underline add post-it notes, bookmarks to pages, instantly search for the major terms or chapter titles, etc.
You can search our site for other versions of the New Perspectives Microsoft Office 365 & Access 2019 Comprehensive, 1st Edition PDF ebook. You can also search for others PDF ebooks from publisher Cengage Learning, as well as from your favorite authors. We have thousands of online textbooks and course materials (mostly in PDF) that you can download immediately after purchase.
Note: e-textBooks do not come with access codes, CDs/DVDs, workbooks, and other supplemental items.
- Full title: New Perspectives Microsoft Office 365 & Access 2019 Comprehensive, 1st Edition
- Edition: 1st
- Copyright year: 2020
- Publisher: Cengage Learning
- Author: Mark Shellman; Sasha Vodnik
- ISBN: 9780357119990, 9780357119990
- Format: PDF
Description of New Perspectives Microsoft Office 365 & Access 2019 Comprehensive, 1st Edition:
Develop the Microsoft Office 365 and Access 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & ACCESS 2019: COMPREHENSIVE. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Table of Contents of New Perspectives Microsoft Office 365 & Access 2019 Comprehensive, 1st Edition PDF ebook:
Brief ContentsTable of ContentsGetting to Know Microsoft Office VersionsUsing SAM Projects and Textbook ProjectsAccess ModulesModule 1: Creating a Database: Tracking Patient, Visit, and Billing DataSession 1.1 Visual Overview: The Access WindowIntroduction to Database ConceptsStarting Access and Creating a DatabaseCreating a Table in Datasheet ViewCreating a Table in Design ViewClosing a Table and Exiting AccessSession 1.1 Quick CheckSession 1.2 Visual Overview: The Create Tab OptionsEntering Data into TablesCopying Records from Another Access DatabaseNavigating a DatasheetCreating a Simple QueryCreating a Simple FormCreating a Simple ReportViewing Objects in the Navigation PaneUsing Microsoft Access HelpManaging a DatabaseSession 1.2 Quick CheckReview AssignmentsCase ProblemsModule 2: Building a Database and Defining Table Relationships: Creating the Billing and Patient TabSession 2.1 Visual Overview: Table Window in Design ViewGuidelines for Designing DatabasesGuidelines for Setting Field PropertiesModifying a Table in Design ViewModifying the Structure of an Access TableModifying Field PropertiesSession 2.1 Quick CheckSession 2.2 Visual Overview: Understanding Table RelationshipsAdding Records to a New TableImporting Data from an Excel WorksheetCreating a Table by Importing an Existing Table or Table StructureAdding Fields to a Table Using the Data Type GalleryModifying the Structure of an Imported TableSetting the Default Value Property for a FieldAdding Data to a Table by Importing a Text FileDefining Table RelationshipsSession 2.2 Quick CheckReview AssignmentsCase ProblemsModule 3: Maintaining and Querying a Database: Updating and Retrieving Information about Patients, VSession 3.1 Visual Overview: Query Window in Design ViewUpdating a DatabaseIntroduction to QueriesCreating and Running a QueryUpdating Data Using a QueryCreating a Multitable QuerySorting Data in a QueryFiltering DataSession 3.1 Quick CheckSession 3.2 Visual Overview: Selection Criteria in QueriesDefining Record Selection Criteria for QueriesDefining Multiple Selection Criteria for QueriesChanging a Datasheet’s AppearanceCreating a Calculated FieldUsing Aggregate FunctionsWorking with the Navigation PaneSession 3.2 Quick CheckReview AssignmentsCase ProblemsModule 4: Creating Forms and Reports: Using Forms and Reports to Display Patient and Visit DataSession 4.1 Visual Overview: Form Displayed in Form ViewCreating a Form Using the Form WizardModifying a Form’s Design in Layout ViewNavigating a FormFinding Data Using a FormMaintaining Table Data Using a FormPreviewing and Printing Selected Form RecordsCreating a Form with a Main Form and a SubformSession 4.1 Quick CheckSession 4.2 Visual Overview: Report Displayed in Print PreviewCreating a Report Using the Report WizardModifying a Report’s Design in Layout ViewUsing Conditional Formatting in a ReportSession 4.2 Quick CheckReview AssignmentsCase ProblemsModule 5: Creating Advanced Queries and Enhancing Table Design: Making the Clinic Database Easier toSession 5.1 Visual Overview: Calculated FieldReviewing the Clinic DatabaseUsing a Pattern Match in a QueryUsing a List-of-Values Match in a QueryUsing the Not Logical Operator in a QueryAssigning a Conditional Value to a Calculated FieldCreating a Parameter QuerySession 5.1 Quick CheckSession 5.2 Visual Overview: Advanced Query WizardsCreating a Crosstab QueryCreating a Find Duplicates QueryCreating a Find Unmatched QueryCreating a Top Values QuerySession 5.2 Quick CheckSession 5.3 Visual Overview: Lookup Fields and Input MasksCreating a Lookup FieldUsing the Input Mask WizardIdentifying Object DependenciesDefining Data Validation RulesWorking with Long Text FieldsDesignating a Trusted FolderSession 5.3 Quick CheckReview AssignmentsCase ProblemsModule 6: Using Form Tools and Creating Custom Forms: Creating Forms for Lakewood Community Health SSession 6.1 Visual Overview: Anchoring ControlsDesigning FormsCreating a Relationship Report and Using the DocumenterCreating Forms Using Form ToolsSession 6.1 Quick CheckSession 6.2 Visual Overview: Custom Form in Design ViewPlanning and Designing a Custom FormCreating a Custom Form in Design ViewSelecting, Moving, and Aligning Form ControlsResizing and Deleting ControlsAdding a Combo Box Control to a FormUsing Form Headers and Form FootersSession 6.2 Quick CheckSession 6.3 Visual Overview: Custom Form in Form ViewAdding a Combo Box to Find RecordsAdding a Subform to a FormDisplaying a Subform’s Calculated Controls in the Main FormChanging the Tab Order in a FormImproving a Form’s AppearanceSession 6.3 Quick CheckReview AssignmentsCase ProblemsModule 7: Creating Custom Reports: Creating Custom Reports for Lakewood Community Health ServicesSession 7.1 Visual Overview: Report SectionsCustomizing Existing ReportsViewing a Report in Report ViewModifying a Report in Layout ViewModifying a Report in Design ViewSession 7.1 Quick CheckSession 7.2 Visual Overview: Form in Design View and Print PreviewPlanning and Designing a Custom ReportCreating a Query for a Custom ReportCreating a Custom ReportWorking with Controls in Design ViewHiding Duplicate Values in a ReportSession 7.2 Quick CheckSession 7.3 Visual Overview: Custom Form in Design ViewUnderstanding Page Header and Page Footer SectionsCreating Mailing LabelsSession 7.3 Quick CheckReview AssignmentsCase ProblemsModule 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing DatSession 8.1 Visual Overview: Exporting Data to XML and HTMLExporting an Access Query to an HTML DocumentImporting a CSV File as an Access TableWorking with XML FilesSession 8.1 Quick CheckSession 8.2 Visual Overview: Tabbed Control with a ChartUsing a Tab Control in a FormCreating a Chart Using the Chart WizardUsing Templates and Application PartsExporting a Report to a PDF FileIntegrating Access with Other ApplicationsSession 8.2 Quick CheckReview AssignmentsCase ProblemsModule 9: Using Action Queries and Advanced Table Relationships: Enhancing User Interaction with theSession 9.1 Visual Overview: Action QueriesAction QueriesSession 9.1 Quick CheckSession 9.2 Visual Overview: Many-to-Many RelationshipUnderstanding Types of Table RelationshipsDefining M:N and 1:1 Relationships between TablesUnderstanding Join TypesUsing Indexes for Table FieldsSession 9.2 Quick CheckReview AssignmentsCase ProblemsModule 10: Automating Tasks with Macros: Creating a User Interface for the Health DatabaseSession 10.1 Visual Overview: The Macro Designer WindowIntroduction to MacrosRunning a MacroViewing a Macro in the Macro DesignerAdding Actions to a MacroSingle Stepping a MacroUsing a Command Button with an Attached MacroAdding a SubmacroAdding a Command Button to a FormAttaching a Submacro to a Command ButtonSession 10.1 Quick CheckSession 10.2 Visual Overview: A Navigation FormDesigning a User InterfaceCreating an Unbound FormAdding a List Box Control to a FormIntroduction to SQLCreating Multiple Macros for a FormCreating a Navigation FormSession 10.2 Quick CheckReview AssignmentsCase ProblemsModule 11: Using and Writing Visual Basic for Applications Code: Creating VBA Code for the Health DaSession 11.1 Visual Overview: VBA Code WindowIntroduction to Visual Basic for ApplicationsUsing an Existing VBA ProcedureCreating Functions in a Standard ModuleTesting a Procedure in the Immediate WindowSession 11.1 Quick CheckSession 11.2 Visual Overview: Example of an Event ProcedureUnderstanding How an Event Procedure Processes CommandsAdding an Event ProcedureAdding a Second Procedure to a Class ModuleAdding an Event Procedure to Change the Case of a Field ValueHiding a Control and Changing a Control’s ColorSession 11.2 Quick CheckReview AssignmentsCase ProblemsModule 12 Managing and Securing a Database: Administering the Health DatabaseSession 12.1 Visual Overview: Multivalued Fields and SubqueriesAdditional Filtering OptionsCreating a SubqueryUsing Multivalued FieldsSession 12.1 Quick CheckSession 12.2 Visual Overview: Database OptionsCreating an Attachment FieldUsing an AutoNumber FieldSaving an Access Database as a Previous VersionAnalyzing Database Performance with the Performance AnalyzerLinking Tables between DatabasesUsing the Database SplitterSecuring an Access DatabaseSetting the Database Startup OptionsSession 12.2 Quick CheckReview AssignmentsCase ProblemsAppendix A: Relational Databases and Database DesignIndex