Access Intermediate
Short course
In Ferndown
Description
-
Type
Short course
-
Location
Ferndown
-
Start date
Different dates available
This Microsoft Access course is designed for those who are familiar with most of the topics from our Access Beginners course, either from attending our Access Beginners Course or knowledge gained from their own experience.
Course Delivery
On site tailored training for up to 8 people
On site one to one surgery type training
Client courses using Training Rooms in Bournemouth Dorset
Client courses using Training rooms in Wimborne Dorset
Benefits Of Access Intermediate Training
Following on from our Access Beginners course you will learn how to use some of the more advanced Access functions and examine different ways to format and present reports using Access.
Facilities
Location
Start date
Start date
About this course
We usually train at client site where we can tailor the training.
Costs for a day's training at your site:
1 to 1 £295 + VAT
2 to 4 people - £455 + VAT
5 to 8 people - £595 + VAT
Reviews
Subjects
- Design
- Database
- Database training
- Access
- Intermediate
- Present reports
- <br /> skills
- Tables
- Filtering
- Sorting
- Reports
- Database Items
- Layout
- Columns
- Field properties
Course programme
Print Access Intermediate Course Content 2007
Print Access Intermediate Course Content 2010
Basics
Understanding database objects
Open Access; Create a new database
Open an existing database; Task Pane
The database window explained
Close a database
Toolbars display and hide toolbars and Task Pane
Tables
Create a new database and table structure
Setting a primary key’ Set the field properties
Save a table design
Lookup field
Open an existing table
Change between views
Enter data into a table
Navigation tips
Create an indexed field
Validation rules and messages
Add or delete a field in design view
Delete or rename a table; Preview and print a table
Print specific number of pages
Print selection of records
Create/delete a relationship
Set and delete referential Integrity
Editing Sorting And Filtering
Adjust column widths; Move columns
Search for data in a table; Replace data in a table
Use wild cards in a search or replace
Navigate
Undo an action
Insert/delete records
Enter the same value in a field from previous record
Sorting data
Filtering records by selection; Filter by form’ Filter by excluding selection
Queries
Create a single table query
Add fields to the query design grid
Sort a query
Show/hide fields
View (run) and save a query
Search expressions
Hash symbols and quotation marks
Use 'And' or ‘Or’ in the criteria
Create and run a parameter query
Edit a query design view; Delete a query
Rearrange fields in design view
Create a query using related tables
Print preview/print selected records
Forms
Create a data entry form using the wizard
Enlarge a section in a form design
Rearrange fields and labels in a form
Move and widen fields and labels in a form design
Headers and footers using toolbox and text frames
Format font and edit text
Design a form
Navigating through records
Finding a record
Print Preview; Print all or individual records
Delete a form
Reports
Create a report using the wizard
Enlarge a section in a report design
Rearrange fields and labels in a report design
Move and widen fields and labels in a report design
Align text boxes
Headers and footers using toolbox and text frames
Format font in headers; footers or field labels
Edit text in headers; footers or field labels
Set grouping; Set sorting
Adding calculations
Print and print preview
Deleting a report
Access Intermediate