What you will learn:
- Import, link and export tables
- Work with advanced table properties
- Use advanced select queries and create crosstab queries and charts, as well as use action queries
- Design forms and use subforms
- Create simple macros
- Design reports
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Post Course Support
Course prerequisites
Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.
Do I need to bring my own laptop?
Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.
Topics covered in this training course
- Introduction revision
- Drag and drop import
- Troubleshooting importing
- Import a CSV file
- Linking tables
- Modify data in linked tables
- Importing vs linked tables
- Export data from Access
- Export to Excel
- Export to Access
- Review basic field properties
- Create a custom format
- Custom date formats
- Input mask property
- Validation rules
- Validation text property
- Table properties
- Modify lookup field properties
- The relationships window
- Set table relationships
- Relationship types
- Referential integrity
- Cascade updates and deletes
- Find null values
- To exclude null values
- NOT queries
- Parameter queries
- Parameter data types
- Query multiple tables
- Table joins
- Find orphan (unmatched) records
- Use expression builder
- Convert nulls to zeros
- Concatenation
- StrConv function
- Date functions
- DateAdd()
- DateDiff()
- IIF() function
- Aggregate queries
- Format query field properties
- Format the query headings
- Top values query
- Form design view
- Breaking form layouts
- Selecting form controls
- Form properties
- Form control properties
- Create an unbound control
- Add a calculation
- Add a drop-down control
- Change combo box properties
- Add a button
- Change tab order
- Align controls
- Resize controls
- Evenly spacing controls
- Add a logo to a form
- Link a query to a form
- Create a crosstab query using the wizard
- Modify a crosstab query
- Create a crosstab query manually
- Make table query
- Delete query
- Update query
- Append query
- Create a subform from control wizard
- Modify the subform
- Datasheet view
- Subform properties
- Continuous forms view
- Calculations on a subform
- Report design view
- Add a logo to a report
- Add calculations to reports
- Concatenation
- Add calculations to a footer
- Sum calculated fields
- Advanced report properties
- Show and hide report sections
- Add page breaks
You might be interested in:
