Description: Chapter 1 - Introduction to Access: Finding Your Way through a DatabaseSection 1: Data and Files Everywhere!Exploring, Describing, and Navigating Among the Objects in an Access DatabaseUnderstanding the Difference Between Working in Storage and MemoryPracticing Good File ManagementBacking up, Compacting, and Repairing Access FilesHands-On Exercises 1 Introduction to DatabasesSection 2: Filters, Sorts, and Access Versus ExcelCreating FiltersSorting Table Data on One or More FieldsKnowing When to Use Access or Excel to Manage DataHands-On Exercises 2: Data Manipulation: Filters and SortsSection 3: The Relational DatabaseUsing the Relationship WindowUnderstanding Relational PowerHands-On Exercises 3: Introduction to RelationshipsSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and UsingSection 1: Related DataTable Design, Properties, Views, and WizardsDesigning DataCreating TablesHands-On Exercises 1: Table Design, Properties, Views, and WizardsSection 2: Multiple Table DatabaseUnderstanding Table RelationshipsSharing Data with ExcelEstablishing Table RelationshipsHands-on Exercises 2: Imports and RelationshipsSection 3: QueriesCreating a QuerySpecifying Criteria for Different Data TypesCopying and Running a QueryUsing the Query WizardUnderstanding Large Database DifferencesHands-On Exercises 3: Multi-Table QuerySummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make DecisionsSection 1: Data Summary and AnalysisUnderstanding the Order of PrecedenceCreating a Calculated Field in a QueryHands-On Exercises 1: Calculated Query FieldsSection 2: Expression BuilderCreating Expressions with the Expression BuilderCreating and Editing Access FunctionsPerforming Date ArithmeticHands-On Exercises 2: Expression Builder, Functions, and Date ArithmeticSection 3: Data AggregatesCreating and Working with Data AggregatesHands-On Exercises 3: Data AggregatesSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful ReportsSection 1: Appearance MatterPlanning ReportsUsing Different Report ViewsCreating and Editing a ReportHands-On Exercises 1: Introduction to Access ReportsSection 2: The Anatomy of a ReportIdentifying Report Elements, Sections and ControlsAdding Grouping Levels Using the Layout ViewAdding Fields to a ReportHands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from ReportsSection 3: The Report and Label WizardUsing the Report WizardHands-On Exercises 3: Report WizardSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini Cases

Please Wait