About this Course
Microsoft® Access 2010 Core teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data. Students will use the Expression Builder to create expressions and insert identifiers as property settings, use advanced form controls to locate information and restrict data entry, and will set form properties that respond to events.
Course Prerequisites :
This course is designed for studentswho arefamiliar with personal computers, using a keyboard and using amouse. The course assumes that students have completed the Microsoft Windows course or have equivalentMicrosoft Windows knowledge and experience.
- start and run Windows
- use the taskbar
- use the Start button
- use the Help feature
- use Minimize, Restore Down/Maximize, or Close
- use the left and right mouse buttons appropriately
- understand file management techniques
- navigate between files, folders, or drives
Course Objectives : This course book teaches the skills you will need to successfully complete the Access 2010 exam. You will use Access to create a database solution that will track information, generate reports, analyze data and streamline the data entry process. You will also explore various techniques for ensuring good database design and for preserving data integrity. After completing this course, you will be able to: define the function of a database compare databases identify Access file types and file name extensions identify database objects identify the main components of the Access user interface create and open databases add a password and encrypt a database file back up, compact and repair a database set database options plan tables and table fields for a database draw a model of a table understand data types modify field properties and field descriptions define primary keys modify table structure insert, delete and rename fields use Quick Start fields use Application Parts enter records in Datasheet view import data append records modify the layout of a datasheet create relationships create lookup fields add records to related tables using subdatasheets use the Find feature use wildcards in expressions sort and filter records create queries add, move and rearrange query fields hide and show query fields add criteria to a query use operators in expressions work with joined tables create ad hoc relationships use the Expression Builder add totals and calculated fields create make-table, append and crosstab queries create forms use Form Design tools apply form design options add bound and unbound controls format form headers and footers view form code convert macros to Visual Basic view the Property Sheet add existing fields from the Field List pane work with form layouts reposition and format controls using anchors, padding and margins insert image controls onto forms add expressions to form controls format forms use report views Using the Report Tool and Wizard create reports work with controls group and sort report records add calculated controls use the Chart Wizard modify page size and orientation work with report headers and footers add logos, titles, date and time, and page numbering apply conditional formatting modify tab order align, space, move and size controls find, sort, and filter records on a report preview and print reports Duration : 3days / 22 hrs Entry Requirement : Basic Computer Knowledge
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider G-TEC COMPUTER EDUCATION CENTRE (PTE. LTD.)
- Course Category Technology
- Course Price $590
Comments