The Resource Access 2016 : in easy steps, Mike McGrath
Access 2016 : in easy steps, Mike McGrath
Resource Information
The item Access 2016 : in easy steps, Mike McGrath represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Randwick City Library.This item is available to borrow from 1 library branch.
Resource Information
The item Access 2016 : in easy steps, Mike McGrath represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Randwick City Library.
This item is available to borrow from 1 library branch.
- Summary
- Access 2016 in easy steps neatly demonstrates the important functions of Access 2016 in a clear and concise manner, so you can get going quickly with this popular database application. Areas covered include: Optimizing database design Creating Tables to store data in formatted fields Using handy templates to give you a head start Defining relationships between data Importing and exporting of data Making queries to extract specific data Producing Forms for data entry Constructing Reports for data presentation Sharing your database to impress your colleagues! Whether you?re upgrading to Access 2016 or new to the database concept, use this guide to learn the key features constructively and get more out of Access 2016 ? in easy steps!
- Language
- eng
- Extent
- 192 pages
- Note
- Includes index
- Contents
-
- Machine generated contents note: 1.Getting Started -- Introducing Access 2016 -- Launching the Access app -- Exploring the user interface -- Customizing Quick Access -- Managing files Backstage -- Personalizing Access options -- Converting older databases -- Using Access templates -- Searching for templates -- Getting some Help -- Applying Access updates -- 2.Designing Databases -- Arranging related data -- Understanding relationships -- Developing database design -- Producing data Tables -- Optimizing database design -- 3.Creating Tables -- Exploring the Table window -- Working in Datasheet View -- Formatting Datasheets -- Working in Design View -- Managing rows -- Setting the Primary Key -- Selecting data types -- Attaching objects -- Calculating fields -- Specifying field properties -- Stating Validation Rules -- Creating an Input Mask -- Defining a Default Value -- Referencing Indexes -- Providing a Lookup Column -- 4.Defining Relationships -- The Relationships window --
- Contents note continued: Specifying relationships -- Enforcing integrity -- Specifying Join properties -- Directing Joins -- 5.Handling Data -- Entering data -- Using the Clipboard -- Copying data to/from Excel -- Importing data from Excel -- Importing data from Access -- Managing import tasks -- Exporting data from Access -- Filtering data -- Totalling fields -- Checking spelling -- Formatting Tables -- 6.Making Queries -- Introducing Queries -- Employing the Query Wizard -- Working with Query Design -- Adding criteria to a Query -- Querying multiple Tables -- Stating criteria for numbers -- Specifying criteria for text -- Creating a Make Table Query -- Creating an Append Query -- Creating an Update Query -- Creating a Delete Query -- 7.Coding Queries -- Introducing SQL -- Exploring the SQL window -- Using the SELECT clause -- Using the WHERE clause -- Employing SQL functions -- Combining UNION Queries -- 8.Producing Forms -- Designing a Form -- Entering data via a Form --
- Contents note continued: Filtering Form data -- Employing the Form Wizard -- Providing a Simple Form -- Offering a Split Form -- Presenting Multiple Items -- Finding a record -- 9.Enhancing Forms -- Working with Design View -- Employing the Field List -- Working with Layout View -- Adding Headers and Footers -- Adding controls to a Form -- Fine-tuning Form controls -- Changing control properties -- Creating Calculated controls -- Adjusting the Tab Order -- Producing a Tabbed Form -- Using Command Buttons -- Displaying a Modal Dialogue-- Executing Macros -- 10.Supplying Reports -- Exploring the Report Wizard -- Providing a Simple Report -- Working with Design View -- Adding fields to a Report -- Adding controls to a Report -- Adding Headers and Footers -- Sorting and grouping data -- Printing labels -- Setting custom label sizes -- Using Print Preview -- Printing Reports -- Sending Reports via email -- 11.Sharing Access -- Protecting with passwords -- Preventing alteration --
- Contents note continued: Securing with backups -- Splitting databases -- Interacting with SharePoint
- Isbn
- 9781840787733
- Label
- Access 2016 : in easy steps
- Title
- Access 2016
- Title remainder
- in easy steps
- Statement of responsibility
- Mike McGrath
- Language
- eng
- Summary
- Access 2016 in easy steps neatly demonstrates the important functions of Access 2016 in a clear and concise manner, so you can get going quickly with this popular database application. Areas covered include: Optimizing database design Creating Tables to store data in formatted fields Using handy templates to give you a head start Defining relationships between data Importing and exporting of data Making queries to extract specific data Producing Forms for data entry Constructing Reports for data presentation Sharing your database to impress your colleagues! Whether you?re upgrading to Access 2016 or new to the database concept, use this guide to learn the key features constructively and get more out of Access 2016 ? in easy steps!
- Cataloging source
- YDX
- http://library.link/vocab/creatorDate
- 1956-
- http://library.link/vocab/creatorName
- McGrath, Mike
- Dewey number
- 005.5
- Illustrations
- illustrations
- Index
- index present
- LC call number
- QA76.9.D3
- LC item number
- M39535 2017
- Literary form
- non fiction
- Series statement
- In easy steps
- http://library.link/vocab/subjectName
-
- Database management
- Database design
- Label
- Access 2016 : in easy steps, Mike McGrath
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
-
- nc
- Carrier MARC source
- rdacarrier
- Content category
-
- text
- still image
- Content type code
-
- txt
- sti
- Content type MARC source
-
- rdacontent
- rdacontent
- Contents
-
- Machine generated contents note: 1.Getting Started -- Introducing Access 2016 -- Launching the Access app -- Exploring the user interface -- Customizing Quick Access -- Managing files Backstage -- Personalizing Access options -- Converting older databases -- Using Access templates -- Searching for templates -- Getting some Help -- Applying Access updates -- 2.Designing Databases -- Arranging related data -- Understanding relationships -- Developing database design -- Producing data Tables -- Optimizing database design -- 3.Creating Tables -- Exploring the Table window -- Working in Datasheet View -- Formatting Datasheets -- Working in Design View -- Managing rows -- Setting the Primary Key -- Selecting data types -- Attaching objects -- Calculating fields -- Specifying field properties -- Stating Validation Rules -- Creating an Input Mask -- Defining a Default Value -- Referencing Indexes -- Providing a Lookup Column -- 4.Defining Relationships -- The Relationships window --
- Contents note continued: Specifying relationships -- Enforcing integrity -- Specifying Join properties -- Directing Joins -- 5.Handling Data -- Entering data -- Using the Clipboard -- Copying data to/from Excel -- Importing data from Excel -- Importing data from Access -- Managing import tasks -- Exporting data from Access -- Filtering data -- Totalling fields -- Checking spelling -- Formatting Tables -- 6.Making Queries -- Introducing Queries -- Employing the Query Wizard -- Working with Query Design -- Adding criteria to a Query -- Querying multiple Tables -- Stating criteria for numbers -- Specifying criteria for text -- Creating a Make Table Query -- Creating an Append Query -- Creating an Update Query -- Creating a Delete Query -- 7.Coding Queries -- Introducing SQL -- Exploring the SQL window -- Using the SELECT clause -- Using the WHERE clause -- Employing SQL functions -- Combining UNION Queries -- 8.Producing Forms -- Designing a Form -- Entering data via a Form --
- Contents note continued: Filtering Form data -- Employing the Form Wizard -- Providing a Simple Form -- Offering a Split Form -- Presenting Multiple Items -- Finding a record -- 9.Enhancing Forms -- Working with Design View -- Employing the Field List -- Working with Layout View -- Adding Headers and Footers -- Adding controls to a Form -- Fine-tuning Form controls -- Changing control properties -- Creating Calculated controls -- Adjusting the Tab Order -- Producing a Tabbed Form -- Using Command Buttons -- Displaying a Modal Dialogue-- Executing Macros -- 10.Supplying Reports -- Exploring the Report Wizard -- Providing a Simple Report -- Working with Design View -- Adding fields to a Report -- Adding controls to a Report -- Adding Headers and Footers -- Sorting and grouping data -- Printing labels -- Setting custom label sizes -- Using Print Preview -- Printing Reports -- Sending Reports via email -- 11.Sharing Access -- Protecting with passwords -- Preventing alteration --
- Contents note continued: Securing with backups -- Splitting databases -- Interacting with SharePoint
- Control code
- 000061390980
- Dimensions
- 23 cm.
- Extent
- 192 pages
- Isbn
- 9781840787733
- Isbn Type
- (pbk.)
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
-
- n
- Other physical details
- colour illustrations
- System control number
- (OCoLC)972803535
- Label
- Access 2016 : in easy steps, Mike McGrath
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
-
- nc
- Carrier MARC source
- rdacarrier
- Content category
-
- text
- still image
- Content type code
-
- txt
- sti
- Content type MARC source
-
- rdacontent
- rdacontent
- Contents
-
- Machine generated contents note: 1.Getting Started -- Introducing Access 2016 -- Launching the Access app -- Exploring the user interface -- Customizing Quick Access -- Managing files Backstage -- Personalizing Access options -- Converting older databases -- Using Access templates -- Searching for templates -- Getting some Help -- Applying Access updates -- 2.Designing Databases -- Arranging related data -- Understanding relationships -- Developing database design -- Producing data Tables -- Optimizing database design -- 3.Creating Tables -- Exploring the Table window -- Working in Datasheet View -- Formatting Datasheets -- Working in Design View -- Managing rows -- Setting the Primary Key -- Selecting data types -- Attaching objects -- Calculating fields -- Specifying field properties -- Stating Validation Rules -- Creating an Input Mask -- Defining a Default Value -- Referencing Indexes -- Providing a Lookup Column -- 4.Defining Relationships -- The Relationships window --
- Contents note continued: Specifying relationships -- Enforcing integrity -- Specifying Join properties -- Directing Joins -- 5.Handling Data -- Entering data -- Using the Clipboard -- Copying data to/from Excel -- Importing data from Excel -- Importing data from Access -- Managing import tasks -- Exporting data from Access -- Filtering data -- Totalling fields -- Checking spelling -- Formatting Tables -- 6.Making Queries -- Introducing Queries -- Employing the Query Wizard -- Working with Query Design -- Adding criteria to a Query -- Querying multiple Tables -- Stating criteria for numbers -- Specifying criteria for text -- Creating a Make Table Query -- Creating an Append Query -- Creating an Update Query -- Creating a Delete Query -- 7.Coding Queries -- Introducing SQL -- Exploring the SQL window -- Using the SELECT clause -- Using the WHERE clause -- Employing SQL functions -- Combining UNION Queries -- 8.Producing Forms -- Designing a Form -- Entering data via a Form --
- Contents note continued: Filtering Form data -- Employing the Form Wizard -- Providing a Simple Form -- Offering a Split Form -- Presenting Multiple Items -- Finding a record -- 9.Enhancing Forms -- Working with Design View -- Employing the Field List -- Working with Layout View -- Adding Headers and Footers -- Adding controls to a Form -- Fine-tuning Form controls -- Changing control properties -- Creating Calculated controls -- Adjusting the Tab Order -- Producing a Tabbed Form -- Using Command Buttons -- Displaying a Modal Dialogue-- Executing Macros -- 10.Supplying Reports -- Exploring the Report Wizard -- Providing a Simple Report -- Working with Design View -- Adding fields to a Report -- Adding controls to a Report -- Adding Headers and Footers -- Sorting and grouping data -- Printing labels -- Setting custom label sizes -- Using Print Preview -- Printing Reports -- Sending Reports via email -- 11.Sharing Access -- Protecting with passwords -- Preventing alteration --
- Contents note continued: Securing with backups -- Splitting databases -- Interacting with SharePoint
- Control code
- 000061390980
- Dimensions
- 23 cm.
- Extent
- 192 pages
- Isbn
- 9781840787733
- Isbn Type
- (pbk.)
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
-
- n
- Other physical details
- colour illustrations
- System control number
- (OCoLC)972803535
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.randwick.nsw.gov.au/portal/Access-2016--in-easy-steps-Mike/UnkLmrFgGcE/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.randwick.nsw.gov.au/portal/Access-2016--in-easy-steps-Mike/UnkLmrFgGcE/">Access 2016 : in easy steps, Mike McGrath</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.randwick.nsw.gov.au/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.randwick.nsw.gov.au/">Randwick City Library</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item Access 2016 : in easy steps, Mike McGrath
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.randwick.nsw.gov.au/portal/Access-2016--in-easy-steps-Mike/UnkLmrFgGcE/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.randwick.nsw.gov.au/portal/Access-2016--in-easy-steps-Mike/UnkLmrFgGcE/">Access 2016 : in easy steps, Mike McGrath</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.randwick.nsw.gov.au/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.randwick.nsw.gov.au/">Randwick City Library</a></span></span></span></span></div>
