Skip to main content

Microsoft Access- Advanced

Modify database structure- Import objects or data from other sources; Delete database objects; Hide and display objects in the Navigation Pane
Manage table relationships and keys- Understand relationships; Display relationships; Set Primary Keys; Enforce referential integrity; Set foreign keys
Print and export data- Configure print options for records, forms, and reports; Export objects to alternative formats
Create tables- Import data into tables, create linked tables from external sources, Import tables from other databases
Manage tables- Hide fields in tables; Add total rows; Add table descriptions
Manage table records- Find and replace data; Sort records; Filter records
Create and modify fields- Add and remove fields Add validation rules to fields; Change field captions; Change field sizes; Change field data types; Configure fields to auto-increment; Set default values; Apply built-in input masks
Create and run queries- Create simple queries; Create basic crosstab queries; Create basic parameter queries; Create basic action queries; Create basic multi-table queries; Save queries; Run queries
Modify queries- Add, hide, and remove fields in queries; Sort data within queries; Filter data within queries; Format fields within queries
Configure form controls- Add, move, and remove form controls; Set form control properties; Add and modify form labels
Format forms- Modify tab order on forms; Sort records by form field; Modify form positioning; Insert information in form headers and footers; Insert images on forms
Configure report controls- Group and sort fields on reports; Add report controls; Add and modify labels on reports
Format reports- Format a report into multiple columns; Modify report positioning; Format report elements; Change report orientation; Insert information in report headers and footers; Insert images on reports
Course ID/# : 4505/620379
Tuition: $0.00



Back to Course Listing page
Featured Classes
No Featured Classes today.