Access 2013: An introduction in pdf

In Access 2013 data is stored in tables. Each table holds data about a specific ‘thing’ and is related to at least one other table. Although the data is held in tables, the best way to access and edit data is not within these tables, but by using data entry forms. Queries are used to filter the data and also to do other things, some of which we will see on this course. Reports let you group the data together in printer-friendly format. 

Contents

• Document information
• Opening the course database 
• Using the data entry form
• Using queries to view specific data 
• Single table query: adding simple criteria, showing, sorting
• Wildcards and operators
• And/Or criteria
• Running, modifying and exporting saved queries
• Multi-table queries
• Multi-table query with different table joins 
• Create an update query (if we have time) 
• Create a grouped report based on a query