Understanding Access 2013 Databases

  • 5/15/2013

Key points

  • Access can create two distinct types of databases. The first is a desktop database. You can either create a blank desktop database or use one of a number of template desktop databases. The second type of database is a Web App, which is discussed in Chapter 40.

  • Data can be imported from a wide variety of Office files and other databases. Data can be exported from both tables and queries (discussed in the next chapter).

  • Navigating the user interface effectively involves understanding how to use both the Navigation pane and ribbon. The Quick Access Toolbar provides a useful tool for customizing how you work with Access.

  • There are a large number of configurable settings in a database, and these are set by using the Backstage view database options.

  • Access allows you to link to data held in other database systems or files. When Link Tables is used, the data is held outside of Access and will appear to change as data is modified in the source application. This makes Access a fantastic tool for gathering and reporting on data held in other systems.