Microsoft Office Access 2 Day Introduction Course

Source: www.ashbee.co.uk
Topic: Microsoft Office

Short Desciption:
ashbee Computer Services Tel: 01483 810500 Email: enquiries@ashbee.co.uk Website: www.ashbee.co.uk Microsoft Office Access 2 Day Introduction Course Please find listed below the topics included in our ...

 

Content Inside:
© ashbee Computer Services Tel:  01483 810500 Email: enquiries@ashbee.co.uk Website: www.ashbee.co.uk Microsoft Office Access 2 Day Introduction Course Please find listed below the topics included in our Standard Microsoft Access 2 Day Introduction Course. COURSE OUTLINE Introduction What is a database? Access database terminology Access database objects Using naming conventions Designing a database Creating databases Converting/upgrading databases Database window Objects Tables Creating tables Table design options Data types and field properties Primary keys Lookup fields Data entry Editing and deleting records Table management Subdatasheets Queries Defining queries Creating simple queries Creating queries using wizards Examining the query window Adding fields to the query design Adding criteria to the query design Sorting and calculating data in queries Query views Parameter queries Running a simple query Creating multiple table queries Different query types Forms Defining forms Creating forms using the form wizard Altering form design Simple formatting Adding records to tables in a form Filtering Searching Form objects Tab order Forms with subforms Buttons on forms Switchboard Reports Creating simple reports using the report wizard Grouping data within the report wizard Totalling data within the report wizard Chart and label reports Altering report design Printing reports Relationships Creating and understanding relationships Referential integrity Print relationships Join properties Importing and Linking Data WHO SHOULD ATTEND New or inexperienced users of Access, who wish to use the database with confidence. No prior database knowledge is required. Delegates would find prior knowledge of Excel lists helpful although not necessary.

 

 

01483 810500, access2 vista, office access pdf course, microsoft office access tutorial pdf, microsoft access software tutorial pdf