Microsoft Access Intermediate
Short course
In Nantwich
Description
-
Type
Short course
-
Level
Intermediate
-
Location
Nantwich
-
Duration
1 Day
To show users how to improve their Access databases. We will learn how to create more advanced queries, connect to other data sources and design friendlier user interfaces.
Facilities
Location
Start date
Start date
About this course
Users should be able to do the following within an Access database:-
- Create Tables
- Create simple Select Queries
- Create Forms and Sub Forms
An understanding of database design and relationships is recommended, although this topic is refreshed at the start of this course.
Reviews
Subjects
- Microsoft Access
Course programme
Course Outline:
- Database Design Refresher
- Designing a database
- Primary and Foreign Keys
- Relationships and Referential Integrity
The Lookup Wizard
- Using the Lookup Wizard
- Pros and Cons of using Lookups
- Amending a Lookup
Connecting to Other Data Sources
- Importing Data
- Linking Data
- Connecting to Access Data
- Connecting to Excel Data
- Connecting to ODBC Data
- Splitting a Database
Select Queries
- Changing a Queries Join type
- Finding unmatched data
- Hiding duplicate data
- Top Values
- Parameter Queries
Using Functions in Queries
- Iif() function
- Date() function
- DateAdd() function
- Format() function
Other Queries Techniques
- Crosstab Queries
- Provide query parameters from a Form
- Making a parameter optional
Form Design
- Changing Form Properties
- Tab Order
- Conditional Formatting
- Creating Switchboards
- Using Command Buttons
- Creating Search boxes
Report Design
- Creating Summary fields
- Creating Conditional Summaries
- Using Sub Reports
- Inserting Charts into Reports
- Displaying parameters in a report
Microsoft Access Intermediate