Start now your Access 2010 Course E-learning Custom-made. Beforehand you’ll recieve a practical pre-test. The result will show us which areas need improvement and with this information we’ll make a customised version of the course for you.
You need to know: About your database management systemYou need to know: The ribbon and the Quick Access toolbarOpening a database Database objects Entering records Moving around in a datasheet/form Editing the value in a fieldFinding recordsReplacing the value in a field Deleting recordsSorting recordsPrint PreviewMargins and orientation for printing any object Running a query
Managing objects Formatting/reorganising a datasheet Filtering records by the value in a field Filtering by a range of field values Total row into a datasheetCreating a database Converting a database Protecting a database Creating a table Primary keyImporting data from another application Exporting dataCreating a formObject dependenciesSelecting the records to print in a report Creating a Select query Using the query design gridSetting a selection criterion in a query Setting criteria on multiple fieldsSetting multiple criteria on the same field Sorting the records in a queryDelete queryMake Table query Update query
Datasheet view Restructuring a table in Design view Restricting what can be entered in a field Input masksLookup lists Indexing a tableRelationships between tables Form propertiesPreventing access to form fieldsChanging the order of access to fields SubformsUsing a form to enter data in several tables at once Collecting and sharing data If you ar report, position them to simplify reading.Creating a text box to represent a field Selecting and deleting controls Creating a check box/buttonCreating an option groupCreating a labelCreating a calculated controlCalculating statistics in forms and reports Creating a set list of valuesCreating a list of values from an existing table/query Moving and copying controls Aligning and spacing controls Changing the height of a section Creating a rectangle/line control Resizing controlsFormatting text in a control Aligning text in a control Formatting controls Conditional formattingCopying a format from one control to another Grouping/ungrouping controlsNumbering pages in a report or form Inserting a pictureThemes Sorting information in a report Grouping records in a reportPrinting groups on separate pages of a report Mailing labels Calculated fields in a query Statistics without grouping Statistics on groupsStatistics on groups of pre-selected records Parameter queriesFind Unmatched query Find Duplicates query Crosstab query Creating a pivot tableGrouping records in a pivot table Adding a totals field to a pivot table Pivot charts
Theme by InStijl Media