Microsoft Access Basic

Duration

1 day

Overview

Microsoft Access Basic explains how to get data into a database, either directly by entering it into tables or indirectly by using forms; and how to get information out of a database, either by displaying it on the screen or by printing it in reports.

Course Objectives

• Creating and formatting database elements
• create a database from scratch and from a template
• create, modify, rename, summarize, and delete tables
• create and modify fields and field properties
• create and modify various types of forms and reports
• Entering and modifying data
• enter, edit, delete, and move among records
• sort and filter data in tables, queries, reports, and forms
• find and replace data
• attach documents to records

Lesson 1: Database Essentials

• Start Access in Windows 10
• Open an Existing Database
• Use the Navigation Pane
• Use Object Tabs
• Change Views
• Use the Ribbon
• Use the Backstage View
• Review Database Fields
• Review and Modify Data Types for Fields
• Define Database Tables (Relational Database)

Lesson 2: Creating Database Tables

• Use a Template to Create a Database
• Create a Blank Database
• Create a Table Using the Application Parts Gallery and Quick Start
• Create a Table from Another Table
• Save a Table

Lesson 3: Working with Tables and Database Records

• Use the Keyboard to Navigate among Records
• Use Navigation Buttons
• Enter, Edit, and Delete Records
• Define a Primary Key
• Define and Modify a Multifield Primary Key
• Find and Replace Data
• Attach and Detach Documents
• Sort Data within a Table
• Filtering Data within a Table
• Remove a Filter
• Freeze/Unfreeze and Hide/Unhide Fields
• Define Table Relationships
• Modify Table Relationships
• Print Table Relationships

Lesson 4: Modifying Tables and Fields

• Modify Table Properties
• Rename a Table
• Delete a Table
• Set a Field Property in Datasheet View and Design View
• Define Input Masks for Fields
• Allow Zero Length
• Set Data Validation Rules
• Enter Captions
• Create Fields
• Delete a Field
• Create a Multivalued Lookup Field

Lesson 5: Creating Forms

• Create a Simple Form and Delete a Form
• Create a Form in Design View
• Create a Form in Layout View
• Use the Form Wizard
• Apply a Theme
• Sort Data within a Form
• Filter Data with Common Filters
• Use Filter by Form

Lesson 6: Creating Reports

• Create and Delete a Report
• Use the Report Wizard
• Create a Report in Design View
• Apply a Theme
• Group and Sort Data within a Report
• Filter Data within a Report
• Find Data within a Report

Programme scope, delivery arrangements and suitability are confirmed during enquiry.