Access 2021 – Database Design

Records and data

• Managing rows and columns in a datasheet
• Creating records
• Accessing records
• Modifying field values
• Searching for records
• Replacing field values
• Deleting records
• Sorting records quickly
• Filtering records
• Specific filters
• Inserting a total row in a datasheet

Tables, fields, and table relationships

• Creating a table and field properties
• Modifying table structure in Datasheet view
• Modifying table structure in Design view
• Controlling field input
• Input masks
• Creating a lookup list
• Defining a primary key
• Indexing a table
• Relationship between tables

Forms

• Creating a form
• Form properties
• Restricting access to certain fields
• Field access order
• Subforms
• Entering data in a form and subform
• Themes
• Creating and managing controls
• Inserting a text box
• Selecting and deleting controls
• Creating a checkbox, option button, or toggle button
• Creating an option group
• Creating a text label
• Creating a calculated control
• Statistical calculations
• Creating a list of fixed data
• Creating a list of data from another table
• Copying and moving controls
• Aligning controls
• Section height
• Creating a line or rectangle
• Sizing controls
• Formatting control text
• Aligning control text
• Presentation of controls
• Conditional formatting
• Copying a control's presentation to another
• Grouping/ungrouping controls
• Page numbering
• Inserting an image

Creating and printing a report

• Creating a report
• Print preview
• Sorting order associated with a report
• Grouping records in a report
• Managing groups when printing
• Printing a report for specific records
• Print margins and orientation
• Mailing labels

Select and Action queries

• Creating a select query
• Using the query grid
• Entering criteria in the query grid
• Running a query
• Entering criteria for multiple fields
• Entering multiple criteria for the same field
• Sorting order in queries
• Calculated fields in queries
• Statistical calculations in a query
• Statistical calculations with grouping records
• Statistical calculations with specific grouping
• Parameterized select query
• Unmatched query
• Find duplicates query
• Delete query
• Make-table query
• Update query
• Crosstab query

Advanced features

• Protecting a database
• Converting a database
• Importing data from another application
• Exporting data
• Importing and exporting XML data

Book

• This module offers you access to digital course materials.
• Access 2021 General overview
• Databases
• Database objects
• Table structure
• Relationships between tables
• Records
• Data
• Printing data
• Creating a form
• Creating a report
• Printing a report
• Bound controls
• Unbound controls
• Calculated controls
• Managing controls
• Sections
• Select queries
• Calculations in queries
• Action queries
• Copying/importing/exporting
• Macros
• Customizing the Access interface