Harpenden

<p>This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database.</p>This workshop will help participants:<ul><li>Ensure the integrity of their databases</li><li>Manage field properties</li><li>Use the query functions effectively</li><li>Save time with the query expression builder</li><li>Create different types of query more quickly</li><li>Design better forms</li><li>Link expressions in forms</li><li>Create better and more useful reports</li><li>Import and export tables more easily</li></ul><section>
                    <h3>1 Table relationship integrity</h3><ul><li>Identifying relationships</li><li>Identifying criteria for data integrity</li><li>Applying referential integrity</li><li>Managing relationship join types</li></ul> <h3>2 Table field properties</h3><ul><li>Field properties overview</li><li>Using input mask field</li><li>Using default value fields</li><li>Using field validation rules</li></ul> <h3>3 Query functions</h3><ul><li>Running aggregate function calculations</li><li>Running sum, average, count, max and min functions</li><li>Grouping calculated data</li></ul> <h3>4 Query calculations</h3><ul><li>Using query operators and expressions</li><li>Adding calculated fields to a query</li><li>Using the query expression builder</li></ul> <h3>5 Action queries</h3><ul><li>Creating make table queries</li><li>Creating append queries</li><li>Creating update queries</li><li>Creating delete queries</li></ul> <h3>6 Designing forms</h3><ul><li>Adding form controls</li><li>Aligning and arranging form controls</li><li>Adding pictures and labels to forms</li><li>Adding new fields to a form</li><li>Controlling tab order</li><li>Adding command buttons</li><li>Adding a combo box control</li><li>Formatting data using conditional formatting</li></ul> <h3>7 Form expressions (calculations)</h3><ul><li>Using the form expression builder</li><li>Working with a property sheet within a form</li><li>Linking expressions within a form</li></ul> <h3>8 Working with reports</h3><ul><li>Creating reports with the report wizard</li><li>Inserting report fields</li><li>Formatting fields</li><li>Inserting report headers and footers</li><li>Working with a property sheet within a report</li></ul> <h3>9 Grouped reports</h3><ul><li>Creating groups with the report wizard</li><li>Sorting grouped data</li><li>Grouping alphabetically</li><li>Grouping on date intervals</li><li>Creating sub reports</li><li>Adding calculations to groups</li></ul> <h3>10 Importing and exporting tables</h3><ul><li>Importing tables into Access</li><li>Exporting tables from Access</li><li>Importing and linking data in Access</li></ul> 


                </section>

The In House Training Company

Office Skills & Productivity

Microsoft Forms

Excel Analytics

Access VBA

Computer Skills

Microsoft Access

Access - intermediate (In-House)

<p>This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports.</p>This course will help participants:<ul><li>Plan and create a database</li><li>Sort and filter records</li><li>Use field data types</li><li>Work with tables</li><li>Create and manage a query</li><li>Create and work with forms, and use the form wizard</li><li>View, create and print reports</li></ul><section>
                    <h3>1 Access introduced</h3><ul><li>Planning a database</li><li>Creating a blank database</li><li>Opening an existing database</li><li>Security warnings</li><li>The navigation pane</li><li>Previewing database components</li><li>Closing an Access database</li></ul> <h3>2 Tables introduced</h3><ul><li>Viewing and navigating table data</li><li>Navigating using keyboard shortcuts</li><li>Editing table data</li><li>Adding records to tables</li><li>Selecting and deleting records</li><li>Finding and replacing data</li><li>Filtering tables</li><li>Summing table data</li></ul> <h3>3 Queries introduced</h3><ul><li>Opening a query in datasheet view</li><li>Opening a query in design view</li><li>Adding fields to a query</li><li>Sorting query results</li><li>Modifying datasheet view</li><li>Saving and closing queries</li></ul> <h3>4 Forms introduced</h3><ul><li>Working with form data</li><li>Sorting records</li><li>Filtering records</li><li>Working in design and layout views</li><li>Changing object attributes</li></ul> <h3>5 Reports introduced</h3><ul><li>Opening and viewing reports</li><li>Viewing a report in design view</li><li>Previewing and printing report data</li><li>Creating reports with auto report</li><li>Creating reports with the report wizard</li><li>Changing field attributes</li></ul> <h3>6 Creating a new database</h3><ul><li>Creating database tables</li><li>Creating table fields</li><li>Selecting field data types</li></ul> <h3>7 Table relationships</h3><ul><li>Introducing relationships</li><li>Establishing table relationships</li><li>The one-to-many relationship type</li><li>Establishing referential integrity</li></ul> <h3>8 Creating queries</h3><ul><li>Streamline query criteria using wildcards</li><li>Creating summary queries</li><li>Creating queries based on criteria</li><li>Running date queries</li><li>Formatting field properties</li><li>Building queries from multiple tables</li><li>Summing in queries</li></ul> <h3>9 Creating forms</h3><ul><li>Creating a new form</li><li>Inserting form fields</li><li>Working with the property sheet</li><li>The command button wizard</li><li>The command button wizard</li><li>Programming without typing</li><li>Creating forms with embedded sub forms</li><li>Creating forms with the sub form wizard</li><li>Creating forms with the form wizard</li></ul> <h3>10 Creating reports</h3><ul><li>What are report bands?</li><li>Managing report controls</li><li>Basing reports on multiple tables</li><li>Basing reports on queries</li><li>Sorting and grouping records</li></ul> 


                </section>

Data Entry Skills

Trainers Course

Access - introduction (In-House)

Educators providing Courses in Nottingham

Courses matching "MS Access"

Access - intermediate (In-House)

By The In House Training Company

Access - introduction (In-House)

By The In House Training Company

Search By Location