In this movie, Adam walks you through the process of choosing a template, downloading and saving it, and starting to populate it with your own data. Through the use of a clear user interface, the template files allow you to get to work quickly without any prior knowledge about how the database functions behind the scenes.
- [Voiceover] Now that we have a better idea…about why we might want to move our data collection,…storage, and retrieval processes into a database,…let's dig into Access and see how we can start to…put these concepts to use.…I'm on a Windows 8 machine, so I'm gonna come down here…to the Start menu, and on the Start screen,…I can either click on the Access tile,…or if I don't see it, I'll just start typing Access here,…and press Enter to launch the program.…When you first start up Access, you'll be presented with…this startup screen.…On the left, you might see a list of…recently used database files if you have any.…You can quickly load them again simply by…clicking on one.…
At the bottom here, you'll have the option to…browse your computer's drives for…additional database files that might have…already been created.…If you're starting a new database,…then you'll want to focus on the center of the screen.…Access requires that a database file be created first,…before you can start working with it.…This is a little different than the sequence…
If you need a deeper dive into the topics discussed, check out Adam's Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view