2013 Access Lesson 1 PowerPoint Guided Notes

  1. What is a database?
  1. What are the 2 examples given in the PowerPoint as examples of simple databases?
  1. A computerized ______, such as Microsoft Office Access, enables you to easily collect large volumes of data organized into categories of related information.
  2. What are the four options you have at the Access startup screen in terms of creating or opening a database?
  1. What is an Organizational account?
  1. What is Microsoft SkyDrive?
  1. Do we use Windows 8?
  1. Explain the Open Other Files command on the Access Startup Screen
  1. What button must you use to access the Open dialog box?
  1. Explain the options available when using the drop down arrow next to the Open button:
  • Open
  • Open Read-Only
  • Open Exclusive
  • Open Exclusive Read Only
  1. The Access Navigation pane enables users to do what?
  1. What is the most basic database object that stores data in categories?
  1. What allows a user to search and retrieve data that is stored?
  1. What controls entry and data views and provides visual cues that make data easier to work with?
  1. What presents your information in ways that re most useful to you?
  1. What is an object tab?
  1. What are the two main views for a table?
  1. What is a datasheet?
  1. What is a query?
  1. How do you change views?
  1. When you change views, do the commands on the Ribbon change context to match the tasks you will be performing in that view?
  1. A Ribbon is contextual. What does that mean?
  1. What does the Quick Access Toolbar contain?
  1. Can you customize the Quick Access toolbar?
  1. When you press the ALT key, what appears?
  1. What are badges?
  1. Does every command on the Ribbon have a Key Tip?
  1. Where is the Backstage View?
  1. Which option in Backstage view are the following:
  • ______Default view. Use this option to view the current database file path and view and edit database properties. Compact and repair the database and encrypt the database with a password to restrict access.
  • ______Use this option to create a new database from scratch or from available templates
  • ______Use this option to open an existing database and view a list of recently accessed databases.
  • ______Use this option to return to the open database window where objects can be saved.
  • ______Use this option to save the current database object (such as a table, query, form, or report) as a new object or save the database in another format that is compatible with earlier versions of Access. You can save the database to a document management server for sharing or you can package the database and apply a digital signature. You can also back up the database.
  • ______Use this option to quick-print straight to the printer, open a dialog box from which to choose print options, or preview your document before printing.
  • ______Use this option to close the open database but keep the Access application open.
  • ______Use this option to view and modify user account settings. Change application background and theme. Add a service and activate Access with a product key.
  • ______Use this option to customize language settings, display settings, and other settings.
  1. What is the Change Help Location Menu?
  1. What is the first step in planning a database?
  1. When you categorize information by dividing it into subjects, what do these become in your database?
  1. Each ______should only contain information that relates to that ______.
  1. How is data stored in a database table?
  1. What is each row in a table called?
  1. What is each column in a table called?
  1. What is a primary key?
  1. What does a data type control?
  1. What are the two new data types to Access 2013?
  1. How many characters can the short text data type store? How many can the long text data type store?
  1. What are the most basic organizational element of a database?
  1. What is a relational database?
  1. What happens when you import data into and Access database?
  1. Explain linking.