|
Introduction to databases
- Tables and Forms
- Queries and Reports
Creating Tables
- Adding and naming fields
- Field types
- Setting field properties
- Setting default values
Working with data
- Enter, copy and edit data
- Undo changes
- Save records
- Autocorrect
Finding data
- Find specific record
- Find and replace data
Filters
- Create and apply filters
- Remove and delete filters
Sorting data
- Considerations when sorting
- Sort records in table
- Removing sort order
Basic queries
- Types of query
- Display specific fields
- Modify a query
- Use queries to sort records
- Naming and saving queries
- Printing queries
- Deleting queries
|
Using query criteria
- Enter query criteria
- Rename and hide fields in a query
- Use mathematical operators
- Use text operators in queries
- Use logic in queries
Basic screen forms
- Create form using Form Wizard
- Use the form
- Save and print the form
Customising forms
- Use customising tools
- Move and size controls
- Align controls
- Add text and date to a form
- Add headers and footers to a form
Basic reports
- Create using the Report Wizard
- Save and close a report
- Use report to print data
Customising reports
- Create reports with grouped records
- Create a mailing label report
- Group, move and size controls
- Add lines and rectangles to reports
- Setting fonts, colours and borders
- Add headers and footers to a report
- Changing colours and styles
|
