Join Robin Hunt for an in-depth discussion in this video Calculating in Access 2013 queries, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- View Offline
- [Voiceover] So there's plenty of opportunities…to create calculations and do all sorts of things…with Excel and Access inside of queries and tables.…So we already looked at the basic calculations of…functions going to that Expression Builder.…What I want to show you is how to use different…types of queries to create things that you need.…For example, let's create a new query.…We'll call it Query3.…So I go to Create, Query Design, notice it's called Query3.…
So I have my department list.…I really want to be able to maintain that original…department list, but have the full flexibility…of working with it.…I'm going to double-click on Department List.…What I really want to do is make a table out of it.…I'm going to double-click on the asterisk,…that way I get all the fields for my table.…On the query tools and design tab you see Make Table.…I'm going to call this My Department List.…
And I'm going to store it here in this database,…although, I could put it in another one.…When I run this, it's going to create a new table…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries