Microsoft Access Topics
Access is a Relational Database Management Application
(Stores and Organizes raw data & retrieves information)
Access Basic Course
What is Access? What is a Database?
What are Related Tables?
Getting Started Screen
Opening a database & Exploring Environment (blank- Template- Existing)
Differences from Excel- Similarities with PowerPoint
How to plan a database?
Explore tables in datasheet & design views
Creating tables in Datasheet view
Creating tables in design View
Changing The Design Of A Table
Effective & Ineffective field names
Deleting, inserting & Moving Fields
Attachment Data Type
Add a Total row.
Finding And Editing Records
Filtering a table
Setting Field Properties
Working With Input Masks
Setting Validation Rules
What is a query?
Create Queries using a Wizard
Creating And Using in Design view
Modifying Query Results And Queries
Performing Operations In Queries
What is a form
Creating Forms by using form Button
Creating Forms by using the Wizard
Using Design View to create a form
Sorting And Filtering Records in a form
What is a Report?
Different views of a Report
Change default view
How to create a report by using the wizard
Create a Report in Design view
7 Sections of a report- Properties
Grouping feature in Reports
Modifying and printing reports
Access Intermediate Course
What is a well-structured table (Normalized)? Table Analyzer
Object Dependency (Condition)
Importance of Table Relationships- Types – How To- Printing Relationships
Enforcing Referential Integrity- Cascading Deletes & Updates.
How to Relate Tables
Implementing Referential Integrity
What is lookup field? Types
How to add a Multivalued field
How to create a Lookup Field
Modify lookup field properties (Value list Combo box- Edit list column)
Use a Subdatasheet
Create outer join, inner join, and self-join queries
Types of Queries- Unmatched Q- Find Duplicates Q
Create calculated fields in a query – Rule – Expression Builder
View summarized and grouped data from tables by using queries
Joining Fields Using the Expression Builder
Joining Tables In Queries
How to create a Form? Types of controls
Use controls to add graphics
Arranging, Aligning & Formatting Controls
Bind a control to a calculated field
Create a Calculated Control
Add a combo box (= lookup field)
Conditional Formatting in a form
Create advanced form types (Multiple Value- Split-Datasheet- Subform)
Adding Unbound Controls & Topic B: Adding Graphics
Adding Calculated Values
Adding Combo Boxes
Creating Advanced Form Types
Customize headers and footers in a report
Show report sections.
Set properties for grouping data, and modify the appearance of a report
Add calculated values in a report by using functions
Print database objects and a report of database design
Create labels report
Create and modify a chart in a form
Create and modify a chart in a report
Access Advanced Course
What is Querying with SQL
Writing SQL statement
Adding Field Aliases
Displaying Matching data from related tables
Displaying Unmatched Records
Create SQL Query in SQL view
Context Sensitive Help
Attaching SQL queries to control
Creating Advanced queries
Creating Crosstab queries
The Crosstab query wizard
Create Parameter Queries
Wild Cards in Parameter queries
Using Action Queries
Creating an Append Queries:
Creating a Delete Queries:
Creating an Update query
Creating a Make Table queries
Create and run macros to automate tasks.
What is a Macro?
Attach macros to events of database objects.
Creating Advanced Macros
Create Data Validation & Data entry Macro
Create Macros that run a parameter query.
Create AutoKeys and AutoExec macros.
Create macros to import and export database objects.
Importing, Exporting & Linking
Working with XML documents
Exporting & Importing XML documents
Exporting with an XSL File
Save an Access Object as an XPS file
Saving a table as an XPS file
Linking Access Objects
Linking to an Access table
Using the Linked Table Manager:
Creating Links to Excel
Linking to an Excel workbook
Using Hyperlinks Fields
Converting databases to earlier version
Analyzing database performance
Compacting & repairing databases:
Backing up the database
Setting Options and properties
Office Instructor 2018 | All Rights Reserved.